Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Vlook up an amount for an item and deduct it from that row - issue is that items repeat multiple times - need to take into account the amount already deducted from the same item in the above rows 1

      • jpetraityte
    3. Replies
      1
      Views
      330
      1

    4. Estevaoba

    2. #VALUE result whenever I use the Age Today formula 1

      • vinceymarko
    3. Replies
      1
      Views
      179
      1

    4. royUK

    2. Simple kids math training tool 6

      • ravenoki
    3. Replies
      6
      Views
      379
      6

    4. royUK

    2. Excel formula or VBA code for extracting external file links 1

      • dkool
    3. Replies
      1
      Views
      226
      1

    4. royUK

    2. Count Consecutive Days Worked by an employee

      • osuhail
    3. Replies
      0
      Views
      262

    2. Based on value, find next highest value in range and return it's adjacent cell 3

      • t33p33
    3. Replies
      3
      Views
      502
      3

    4. Ingo_Ingo

    2. Multi-Parts Log Calculation

      • corkant
    3. Replies
      0
      Views
      130

    2. Dynamic Formula To Lookup Most Recent Data On Or Before Given Data Based On Multiple Criteria 1

      • EnginerdUNH
    3. Replies
      1
      Views
      346
      1

    4. EnginerdUNH

    2. Need help with a count formula that needs to eliminate duplicated records

      • AOrsborn
    3. Replies
      0
      Views
      158

    2. match the cell name to tab name and then run a formula 2

      • pjums
    3. Replies
      2
      Views
      273
      2

    4. royUK

    2. how to extract 10 digit mobile number within text or specialcharacter 4

      • PrasadK
    3. Replies
      4
      Views
      543
      4

    4. bosco_yip

    2. Count from Unique Criteria 6

      • Shawn Michaels
    3. Replies
      6
      Views
      491
      6

    4. Shawn Michaels

    2. Formula for: If a Cell contains text 3

      • JulianR
    3. Replies
      3
      Views
      329
      3

    4. royUK

    2. SUMIFS with 2 values in Criteria 1 3

      • Raluca
    3. Replies
      3
      Views
      458
      3

    4. rory

    2. UDF in a Userform 3

      • wings
    3. Replies
      3
      Views
      312
      3

    4. royUK

    2. Matching a name across 2 sheets and then pulling a value from sheet2 and marking sheet1 with a yes based on partial text 6

      • PLucas1
    3. Replies
      6
      Views
      885
      6

    4. Ingo_Ingo

    2. Extract Year part from Date and convert to text 1

      • tomchy
    3. Replies
      1
      Views
      348
      1

    4. rollis13

    2. Please help to make organized data after selection of drop drop box

      • postingart003
    3. Replies
      0
      Views
      528

    2. Extract numbers after specific text in a text string with bracket for negative values and divide the number by 100 if letter 'c' associated with number 6

      • dijoy
    3. Replies
      6
      Views
      689
      6

    4. dijoy

    2. Return Text Before Nth Instance of Particular Character 2

      • thenoodly1
    3. Replies
      2
      Views
      383
      2

    4. thenoodly1

Label

Display Options