Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. How to show if two labors having conflict dates of leave?

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

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

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

      • Golfnut1
    2. Replies
      0
      Views
      149
    1. index and match from several workbooks

      • Pikepro92
    2. Replies
      0
      Views
      149
    1. generating named data based on values

      • abz2786
    2. Replies
      0
      Views
      150
    1. Return Column Header of Last Occurence of Specified Value

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

      • modernpsyche
    2. Replies
      0
      Views
      154
    1. Return cell value from closed WB using variable file path[s] 1

      • Sleeplol
    2. Replies
      1
      Views
      155
      1
    3. GlennUK

    1. Dates & Delay Highlighting

      • Baig1984
    2. Replies
      0
      Views
      158
    1. Need help with a count formula that needs to eliminate duplicated records

      • AOrsborn
    2. Replies
      0
      Views
      158
    1. Deleted

      • jl2509
    2. Replies
      0
      Views
      159
    1. Overlap by employee and date

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

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

      • tommeke
    2. Replies
      0
      Views
      163
    1. Countif and indirect formula

      • AdkinsP
    2. Replies
      0
      Views
      163
    1. Hacking cross workbook references, how to connect local references

      • MDBJ
      • MDBJ
    2. Replies
      0
      Views
      165
    1. Formula or Conditional Formatting? Cut and paste based on font color in another cell

      • sam15
    2. Replies
      0
      Views
      165
    1. Converting from Google Sheets

      • KEG
      • KEG
    2. Replies
      0
      Views
      166
    1. Data Validation-Multiple Criteria

      • KEG
      • KEG
    2. Replies
      0
      Views
      168

Label

Display Options