Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Vlook up an amount for an item and deduct it from that row - issue is that items repeat multiple times - need to take into account the amount already deducted from the same item in the above rows 1

      • jpetraityte
    2. Replies
      1
      Views
      395
      1
    3. Estevaoba

    1. Vlook up 5

      • jpetraityte
    2. Replies
      5
      Views
      942
      5
    3. jpetraityte

    1. Vertical lookup when the range changes. 8

      • JoDor
    2. Replies
      8
      Views
      1.5k
      8
    3. JoDor

    1. VBA to insert IF formula to convert dates to DD/MM/YYYY 8

      • Rovi
      • Rovi
    2. Replies
      8
      Views
      2.3k
      8
    3. Rovi

    1. VBA Code Modification 11

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

    1. Variable to excel formula

      • NewbieError
    2. Replies
      0
      Views
      251
    1. Variable Holidays in Networkdays function 1

      • RSquirrel
    2. Replies
      1
      Views
      111
      1
    3. Pecoflyer

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

      • bob22
    2. Replies
      5
      Views
      1.8k
      5
    3. Carim

    1. Variable Cell Reference based on Path 9

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

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

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

    1. Validation List using a Table 3

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

    1. Validation Between 2 Sheets

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

      • jzehr
    2. Replies
      2
      Views
      931
      2
    3. jzehr

    1. Vacation entitlement calculation 3

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

    1. V and H Lookups On Dynamic Data 8

      • abba92
    2. Replies
      8
      Views
      1.1k
      8
    3. markdininn

    1. Using wildcard in conditional formula not working 3

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

    1. Using TODAY function in a VLOOKUP formula 3

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

    1. Using sumproduct to sum values associated with years 8

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

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

      • thenoobishamateur
    2. Replies
      3
      Views
      696
      3
    3. thenoobishamateur

Label

Display Options