Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. VBA Code Modification 11

      • Excel&VBA
    3. Replies
      11
      Views
      1.3k
      11

    4. royUK

    2. Variable to excel formula

      • NewbieError
    3. Replies
      0
      Views
      226

    2. Variable columns possible in Sumproduct (vlookup) formula 5

      • bob22
    3. Replies
      5
      Views
      1.7k
      5

    4. Carim

    2. Variable Cell Reference based on Path 9

      • xlbrian
    3. Replies
      9
      Views
      1.3k
      9

    4. Carim

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

      • cspgsl
    3. Replies
      3
      Views
      651
      3

    4. Carim

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

      • t.palinkas
    3. Replies
      3
      Views
      691
      3

    4. t.palinkas

    2. Validation List using a Table 3

      • mar050703
    3. Replies
      3
      Views
      416
      3

    4. royUK

    2. Validation Between 2 Sheets

      • mzukowsk
    3. Replies
      0
      Views
      127

    2. Validating for Weekday Date OR Text 2

      • jzehr
    3. Replies
      2
      Views
      901
      2

    4. jzehr

    2. Vacation entitlement calculation 3

      • myexcelstar
    3. Replies
      3
      Views
      602
      3

    4. gijsmo

    2. V and H Lookups On Dynamic Data 8

      • abba92
    3. Replies
      8
      Views
      1.1k
      8

    4. markdininn

    2. Using wildcard in conditional formula not working 3

      • Billyrj
    3. Replies
      3
      Views
      907
      3

    4. royUK

    2. Using TODAY function in a VLOOKUP formula 3

      • Shezmo1
    3. Replies
      3
      Views
      446
      3

    4. Carim

    2. Using sumproduct to sum values associated with years 8

      • riskier4ra
    3. Replies
      8
      Views
      1.3k
      8

    4. Tom.Jones

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

      • thenoobishamateur
    3. Replies
      3
      Views
      660
      3

    4. thenoobishamateur

    2. Using of VLOOKUP and ISNUMBER 8

      • onexc
    3. Replies
      8
      Views
      8.6k
      8

    4. KjBox

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

      • alz1
      • alz1
    3. Replies
      2
      Views
      427
      2

    4. alz1

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

      • OldFella
    3. Replies
      10
      Views
      6.6k
      10

    4. Carim

    2. Using index and match in the right way 2

      • MihaiBanciu
    3. Replies
      2
      Views
      439
      2

    4. Niraj

    2. Using IF, AND, OR 3

      • npecson@schosp
    3. Replies
      3
      Views
      1.3k
      3

    4. skywriter

Label

Display Options