Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. SUM but only the last instance / occurrence if there are duplicates

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

      • Golfnut1
    2. Replies
      0
      Views
      129
    1. Converting from Google Sheets

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

      • tommeke
    2. Replies
      0
      Views
      137
    1. Return Column Header of Last Occurence of Specified Value

      • pmgibs
    2. Replies
      0
      Views
      124
    1. Data Validation-Multiple Criteria

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

      • unknown_brother
    2. Replies
      0
      Views
      167
    1. Conditional Formating. Copy across a row

      • Stephen Bennett
    2. Replies
      0
      Views
      159
    1. Matching Text and Transposing

      • kramer100
    2. Replies
      0
      Views
      158
    1. Matching Text as lookup

      • kramer100
    2. Replies
      0
      Views
      146
    1. Pairs of numbers last out by date

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

      • modernpsyche
    2. Replies
      0
      Views
      128
    1. Countif, Index, Match Indirect

      • Kumar Chandra
    2. Replies
      0
      Views
      166
    1. A math calc from different sources with neat blank cells

      • legin52
    2. Replies
      0
      Views
      151
    1. Looping through multiple data validation lists

      • waimea
    2. Replies
      0
      Views
      347
    1. Index & Match on Multiple Criteria

      • HelenZav
    2. Replies
      0
      Views
      168
    1. Dragging down a formula based on ranges

      • 1003064
    2. Replies
      0
      Views
      158
    1. Deleted

      • jl2509
    2. Replies
      0
      Views
      132
    1. Variable to excel formula

      • NewbieError
    2. Replies
      0
      Views
      181
    1. Copy-paste-values from a formula results in an apostrophe

      • arrkwill
    2. Replies
      0
      Views
      311

Display Options