Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Formula to apply conditional formatting to highlight specific cells based the cell to the left

      • CapG
      • CapG
    2. Replies
      0
      Views
      394
    1. Count overlapping time periods with condition

      • Daphilo
    2. Replies
      0
      Views
      285
    1. Vlookup across multiple worksheets and list sheet names

      • onexc
    2. Replies
      0
      Views
      137
    1. Index formula while working with different workbooks

      • onexc
    2. Replies
      0
      Views
      167
    1. Extract data based on multiple dropdowns

      • cherrithota
    2. Replies
      0
      Views
      107
    1. xlookup by all words in a string

      • jbristow
    2. Replies
      0
      Views
      146
    1. Can you use IF, COUNTIF & OR Together

      • BlakeReuben
    2. Replies
      0
      Views
      201
    1. Dynamic linking with multiple spreadsheets

      • stilton
    2. Replies
      0
      Views
      166
    1. Excel inventory tracking and fair allocation

      • adylim
    2. Replies
      0
      Views
      194
    1. Reverse engineer output of SUMPRODUCT equation

      • hyperdreamz
    2. Replies
      0
      Views
      224
    1. Sla Hours Between Two Dates

      • tr1face
    2. Replies
      0
      Views
      445
    1. Count Consecutive Days Worked by an employee

      • osuhail
    2. Replies
      0
      Views
      273
    1. Multi-Parts Log Calculation

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

      • AOrsborn
    2. Replies
      0
      Views
      168
    1. Please help to make organized data after selection of drop drop box

      • postingart003
    2. Replies
      0
      Views
      564
    1. repetition numbers in a single cell 3 times

      • Fluff13
    2. Replies
      0
      Views
      328
    1. Formula to match multiple unique value's

      • Alphacino
      • Alphacino
    2. Replies
      0
      Views
      224
    1. deleting row from table causes Ref Error on my Gantt Chart Excel file

      • netanel99
    2. Replies
      0
      Views
      262
    1. Need to Match Addresses from different sources

      • anshuljohri
    2. Replies
      0
      Views
      135
    1. Formula required

      • rajeyssh
    2. Replies
      0
      Views
      227

Label

Display Options