Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Dragging down a formula based on ranges

      • 1003064
    2. Replies
      0
      Views
      86
    1. Index & Match on Multiple Criteria

      • HelenZav
    2. Replies
      0
      Views
      113
    1. Looping through multiple data validation lists

      • waimea
    2. Replies
      0
      Views
      204
    1. A math calc from different sources with neat blank cells

      • legin52
    2. Replies
      0
      Views
      90
    1. Countif, Index, Match Indirect

      • Kumar Chandra
    2. Replies
      0
      Views
      110
    1. Create multiple formulas for one cell to top 5 a summed range of values

      • modernpsyche
    2. Replies
      0
      Views
      96
    1. Pairs of numbers last out by date

      • 1legin
    2. Replies
      0
      Views
      100
    1. Matching Text as lookup

      • kramer100
    2. Replies
      0
      Views
      83
    1. Matching Text and Transposing

      • kramer100
    2. Replies
      0
      Views
      89
    1. Conditional Formating. Copy across a row

      • Stephen Bennett
    2. Replies
      0
      Views
      104
    1. Copy/create new list if value in column is partial match with criteria

      • unknown_brother
    2. Replies
      0
      Views
      103
    1. Data Validation-Multiple Criteria

      • KEG
      • KEG
    2. Replies
      0
      Views
      89
    1. Return Column Header of Last Occurence of Specified Value

      • pmgibs
    2. Replies
      0
      Views
      84
    1. Automatically make a list from filling in a variable in another sheet

      • tommeke
    2. Replies
      0
      Views
      93
    1. Converting from Google Sheets

      • KEG
      • KEG
    2. Replies
      0
      Views
      105
    1. Teammates can’t match up in 3 consecutive days

      • Golfnut1
    2. Replies
      0
      Views
      91
    1. SUM but only the last instance / occurrence if there are duplicates

      • James324
    2. Replies
      0
      Views
      85
    1. Conditional Formatting on Cells with Date and Time

      • mayurthakor13
    2. Replies
      0
      Views
      105
    1. Vlookup function copying from different workbook and different sheet names.

      • Awesomun
    2. Replies
      0
      Views
      80
    1. hep with this code

      • LynChen
    2. Replies
      0
      Views
      403

Display Options