Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Validation Between 2 Sheets

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

      • jzehr
    2. Replies
      2
      Views
      654
      2
    3. jzehr

    1. Vacation entitlement calculation 3

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

    1. V and H Lookups On Dynamic Data 8

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

    1. Using wildcard in conditional formula not working 3

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

    1. Using TODAY function in a VLOOKUP formula 3

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

    1. Using sumproduct to sum values associated with years 8

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

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

      • thenoobishamateur
    2. Replies
      3
      Views
      306
      3
    3. thenoobishamateur

    1. Using of VLOOKUP and ISNUMBER 8

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

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

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

    1. Using index and match in the right way 2

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

    1. Using IF, AND, OR 3

    2. Replies
      3
      Views
      935
      3
    3. skywriter

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

      • CNeedsHelp
    2. Replies
      0
      Views
      16
    1. Using Cell Content As Input to a Structured Reference 2

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

    1. Using Address() in a logical test 3

      • OceanRoaming
    2. Replies
      3
      Views
      436
      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
      469
      8
    3. Ryan017

    1. using 2 multi conditional if then statements based on value of another cell 11

      • trader1588
    2. Replies
      11
      Views
      964
      11
    3. AliGW

    1. Users able to select only today's date which then remains a static value 2

      • tac_79
    2. Replies
      2
      Views
      275
      2
    3. tac_79

Display Options