Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Retrieve data from last row / cell in Dynamic Range 1

      • WillAnt
    2. Replies
      1
      Views
      1k
      1
    3. royUK

    1. Last cell containing data in Dynamic Range 1

      • WillAnt
    2. Replies
      1
      Views
      402
      1
    3. royUK

    1. Integrate Formula into VLOOKUP 9

      • WillAnt
    2. Replies
      9
      Views
      699
      9
    3. Carim

    1. Return Header Data for first consecutive cell 1

      • wildus
    2. Replies
      1
      Views
      184
      1
    3. Carim

    1. IFS function giving #NAME? error 1

      • wildeye
    2. Replies
      1
      Views
      769
      1
    3. NBVC

    1. discount codes 1

      • whatisVBA
    2. Replies
      1
      Views
      738
      1
    3. Grimes0332

    1. Use a cell as reference to sheet to look in 1

      • wes2706
    2. Replies
      1
      Views
      252
      1
    3. wittonline

    1. Conditional Formatting based on another cell having data 6

      • WendleB
    2. Replies
      6
      Views
      232
      6
    3. Carim

    1. Extract text string 5

      • Webbers
    2. Replies
      5
      Views
      591
      5
    3. KjBox

    1. Count with multiple criteria including a date plus an "or" variable 3

      • Webbers
    2. Replies
      3
      Views
      421
      3
    3. Carim

    1. Gantt Chart - Data Bars not all correct color for each project 10

      • Webbers
    2. Replies
      10
      Views
      907
      10
    3. Webbers

    1. Search Multiple Ranges for Keywords within Text Strings 4

      • Webbers
    2. Replies
      4
      Views
      393
      4
    3. Webbers

    1. If statement 10

      • waterscapes
    2. Replies
      10
      Views
      671
      10
    3. Carim

    1. Calculate Holidays with Networkdays 1

      • Wasiq
    2. Replies
      1
      Views
      770
      1
    3. Ger Plante

    1. VLookup Formula that can change Negative number to Positive and leave Positive 1

      • Washerz
    2. Replies
      1
      Views
      1.8k
      1
    3. Carim

    1. Need help creating a formula that automatically reallocates unspent funds 7

      • wangs930
    2. Replies
      7
      Views
      431
      7
    3. wangs930

    1. Date string conversion 6

      • waldis
    2. Replies
      6
      Views
      940
      6
    3. skywriter

    1. Looping through multiple data validation lists

      • waimea
    2. Replies
      0
      Views
      328
    1. Moving to a specific cell based on another cell's data. 2

      • VWRSue
    2. Replies
      2
      Views
      308
      2
    3. Carim

    1. Providing Notification of When a Task is Due Based on Dates 1

      • VWRSue
    2. Replies
      1
      Views
      552
      1
    3. vietnt.fov

Display Options