Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Pull Most Recent Date in data set with recurrent entries

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

      • MDBJ
      • MDBJ
    2. Replies
      0
      Views
      175
    1. SUMPRODUCT on 1 column and criteria on another columns

      • richardd8x
    2. Replies
      0
      Views
      223
    1. Excel Concatenating for a Fixed Position Text file

      • slick225
    2. Replies
      0
      Views
      287
    1. IF statement with available resources

      • Olaura
    2. Replies
      0
      Views
      391
    1. index and match from several workbooks

      • Pikepro92
    2. Replies
      0
      Views
      164
    1. - Excel match record from different position of row

      • phooirv
    2. Replies
      0
      Views
      148
    1. Random Number based on Customer ID

      • kramer100
    2. Replies
      0
      Views
      232
    1. Built-in password-protection souricng workbook

      • lil123
    2. Replies
      0
      Views
      142
    1. Linest Function for data in rows

      • socrateshog
    2. Replies
      0
      Views
      263
    1. Excel Staff Rota

      • simont485
    2. Replies
      0
      Views
      240
    1. How to show if two labors having conflict dates of leave?

      • Xani
      • Xani
    2. Replies
      0
      Views
      143
    1. How to show if two labors having conflict dates of leave?

      • Xani
      • Xani
    2. Replies
      0
      Views
      161
    1. Formatting problem

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

      • sam15
    2. Replies
      0
      Views
      182
    1. generating named data based on values

      • abz2786
    2. Replies
      0
      Views
      158
    1. Change in cell value from another cell

      • harsha6989
    2. Replies
      0
      Views
      245
    1. Need help with the lab test result cloese to 24 hours

      • alex_a
    2. Replies
      0
      Views
      230
    1. preserving data when using IF statements to compare cells then do a vlookup

      • Shezmo1
    2. Replies
      0
      Views
      255
    1. Countif and indirect formula

      • AdkinsP
    2. Replies
      0
      Views
      173

Label

Display Options