Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. value within 3 of other cells on the row 3

      • cspgsl
    2. Replies
      3
      Views
      480
      3
    3. Carim

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

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

    1. Validation List using a Table 3

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

    1. Validation Between 2 Sheets

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

      • jzehr
    2. Replies
      2
      Views
      756
      2
    3. jzehr

    1. Vacation entitlement calculation 3

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

    1. V and H Lookups On Dynamic Data 8

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

    1. Using wildcard in conditional formula not working 3

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

    1. Using TODAY function in a VLOOKUP formula 3

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

    1. Using sumproduct to sum values associated with years 8

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

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

      • thenoobishamateur
    2. Replies
      3
      Views
      490
      3
    3. thenoobishamateur

    1. Using of VLOOKUP and ISNUMBER 8

      • onexc
    2. Replies
      8
      Views
      5.3k
      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
      322
      2
    3. alz1

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

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

    1. Using index and match in the right way 2

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

    1. Using IF, AND, OR 3

    2. Replies
      3
      Views
      1.1k
      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
      529
      4
    3. royUK

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

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

    1. Using Address() in a logical test 3

      • OceanRoaming
    2. Replies
      3
      Views
      658
      3
    3. OceanRoaming

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

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

Display Options