Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Conditional formatting with 2 criteria of 2 columns. 2

      • mrbuttons
    2. Replies
      2
      Views
      166
      2
    3. Pecoflyer

    1. Dynamic linking with multiple spreadsheets

      • stilton
    2. Replies
      0
      Views
      166
    1. Deleted

      • jl2509
    2. Replies
      0
      Views
      165
    1. Dates & Delay Highlighting

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

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

      • modernpsyche
    2. Replies
      0
      Views
      162
    1. index and match from several workbooks

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

      • Awesomun
    2. Replies
      0
      Views
      158
    1. generating named data based on values

      • abz2786
    2. Replies
      0
      Views
      157
    1. SUM with OFFSET | Fix #REF if Starting Date isn't 1st of Month 4

      • ruppk825
    2. Replies
      4
      Views
      152
      4
    3. Pecoflyer

    1. Teammates can’t match up in 3 consecutive days

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

      • Xani
      • Xani
    2. Replies
      0
      Views
      151
    1. Retrieving Table Header for a Value 1

      • KnowNoVba
    2. Replies
      1
      Views
      150
      1
    3. Pecoflyer

    1. Multi-Parts Log Calculation

      • corkant
    2. Replies
      0
      Views
      149
    1. xlookup by all words in a string

      • jbristow
    2. Replies
      0
      Views
      148
    1. Excel Formula Help 3

      • tdm99
    2. Replies
      3
      Views
      147
      3
    3. alansidman

    1. Structure Reference weird 4

      • pantakos
    2. Replies
      4
      Views
      143
      4
    3. pantakos

    1. - Excel match record from different position of row

      • phooirv
    2. Replies
      0
      Views
      143
    1. Built-in password-protection souricng workbook

      • lil123
    2. Replies
      0
      Views
      140
    1. Validation Between 2 Sheets

      • mzukowsk
    2. Replies
      0
      Views
      140

Label

Display Options