Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Variable Cell Reference based on Path 9

      • xlbrian
    2. Replies
      9
      Views
      1.1k
      9
    3. Carim

    1. vanguardcp

      Thread was deleted by rory: spam ().
    1. value within 3 of other cells on the row 3

      • cspgsl
    2. Replies
      3
      Views
      568
      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
      635
      3
    3. t.palinkas

    1. Validation List using a Table 3

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

    1. Validation Between 2 Sheets

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

      • jzehr
    2. Replies
      2
      Views
      827
      2
    3. jzehr

    1. Vacation entitlement calculation 3

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

    1. V and H Lookups On Dynamic Data 8

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

    1. Using wildcard in conditional formula not working 3

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

    1. Using TODAY function in a VLOOKUP formula 3

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

    1. Using sumproduct to sum values associated with years 8

      • riskier4ra
    2. Replies
      8
      Views
      1.1k
      8
    3. Tom.Jones

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

      • thenoobishamateur
    2. Replies
      3
      Views
      585
      3
    3. thenoobishamateur

    1. Using of VLOOKUP and ISNUMBER 8

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

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

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

    1. Using index and match in the right way 2

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

    1. Using IF, AND, OR 3

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

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

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

Display Options