Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Hacking cross workbook references, how to connect local references

      • MDBJ
      • MDBJ
    2. Replies
      0
      Views
      121
    1. generating named data based on values

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

      • James324
    2. Replies
      0
      Views
      123
    1. Return Column Header of Last Occurence of Specified Value

      • pmgibs
    2. Replies
      0
      Views
      124
    1. index and match from several workbooks

      • Pikepro92
    2. Replies
      0
      Views
      126
    1. Data Validation-Multiple Criteria

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

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

      • Golfnut1
    2. Replies
      0
      Views
      129
    1. Extract Year part from Date and convert to text 1

      • tomchy
    2. Replies
      1
      Views
      130
      1
    3. rollis13

    1. Dates & Delay Highlighting

      • Baig1984
    2. Replies
      0
      Views
      132
    1. Item sales price filtered by Item no. and date intervall

      • PatNAVNORWAY
    2. Replies
      0
      Views
      134
    1. Deleted

      • jl2509
    2. Replies
      0
      Views
      134
    1. Search Specific Date from all Sheets with 2 criteria 2

      • ramkhans
    2. Replies
      2
      Views
      134
      2
    3. ramkhans

    1. Formula or Conditional Formatting? Cut and paste based on font color in another cell

      • sam15
    2. Replies
      0
      Views
      135
    1. Countif and indirect formula

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

      • tommeke
    2. Replies
      0
      Views
      138
    1. Formula to match multiple unique value's

      • Alphacino
      • Alphacino
    2. Replies
      0
      Views
      138
    1. Overlap by employee and date

      • chrisjdb
    2. Replies
      0
      Views
      141
    1. Range Names from another Cell 1

      • sm789
    2. Replies
      1
      Views
      142
      1
    3. KjBox

    1. Converting from Google Sheets

      • KEG
      • KEG
    2. Replies
      0
      Views
      143

Display Options