Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Validation List values from 3 columns based on INDEX MATCH of value offset from cell 3

      • t.palinkas
    2. Replies
      3
      Views
      477
      3
    3. t.palinkas

    1. Validation List using a Table 3

      • mar050703
    2. Replies
      3
      Views
      234
      3
    3. royUK

    1. Validation Between 2 Sheets

      • mzukowsk
    2. Replies
      0
      Views
      84
    1. Validating for Weekday Date OR Text 2

      • jzehr
    2. Replies
      2
      Views
      683
      2
    3. jzehr

    1. Vacation entitlement calculation 3

      • myexcelstar
    2. Replies
      3
      Views
      366
      3
    3. gijsmo

    1. V and H Lookups On Dynamic Data 8

      • abba92
    2. Replies
      8
      Views
      738
      8
    3. markdininn

    1. Using wildcard in conditional formula not working 3

      • Billyrj
    2. Replies
      3
      Views
      659
      3
    3. royUK

    1. Using TODAY function in a VLOOKUP formula 3

      • Shezmo1
    2. Replies
      3
      Views
      239
      3
    3. Carim

    1. Using sumproduct to sum values associated with years 8

      • riskier4ra
    2. Replies
      8
      Views
      756
      8
    3. Tom.Jones

    1. Using sumif on different columns without getting a double/triple sum up 3

      • thenoobishamateur
    2. Replies
      3
      Views
      361
      3
    3. thenoobishamateur

    1. Using of VLOOKUP and ISNUMBER 8

      • onexc
    2. Replies
      8
      Views
      4.1k
      8
    3. KjBox

    1. using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2

      • alz1
      • alz1
    2. Replies
      2
      Views
      255
      2
    3. alz1

    1. Using INDIRECT in the Formula That Defines a Graph's Data Range 10

      • OldFella
    2. Replies
      10
      Views
      3.9k
      10
    3. Carim

    1. Using index and match in the right way 2

      • MihaiBanciu
    2. Replies
      2
      Views
      258
      2
    3. Niraj

    1. Using IF, AND, OR 3

    2. Replies
      3
      Views
      977
      3
    3. skywriter

    1. Using dropdowns to copy cells from one worksheet to corresponding cells of another worksheet and add new rows if needed. 4

      • CNeedsHelp
    2. Replies
      4
      Views
      356
      4
    3. royUK

    1. Using Cell Content As Input to a Structured Reference 2

      • thefatstig
    2. Replies
      2
      Views
      246
      2
    3. pike

    1. Using Address() in a logical test 3

      • OceanRoaming
    2. Replies
      3
      Views
      506
      3
    3. OceanRoaming

    1. Using a value from a cell inside a formula 8

      • yogeshtalks
    2. Replies
      8
      Views
      1.5k
      8
    3. NBVC

    1. using a formula to find number of days prior to a lost time occuring 8

      • Ryan017
    2. Replies
      8
      Views
      496
      8
    3. Ryan017

Display Options