Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Using wildcard in conditional formula not working 3

      • Billyrj
    3. Replies
      3
      Views
      990
      3

    4. royUK

    2. Using TODAY function in a VLOOKUP formula 3

      • Shezmo1
    3. Replies
      3
      Views
      515
      3

    4. Carim

    2. Using sumproduct to sum values associated with years 8

      • riskier4ra
    3. Replies
      8
      Views
      1.5k
      8

    4. Tom.Jones

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

      • thenoobishamateur
    3. Replies
      3
      Views
      777
      3

    4. thenoobishamateur

    2. Using SUBTOTAL formula within an IF formula 2

      • davec0864
    3. Replies
      2
      Views
      512
      2

    4. GlennUK

    2. Using of VLOOKUP and ISNUMBER 8

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

    4. alz1

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

      • OldFella
    3. Replies
      10
      Views
      7.5k
      10

    4. Carim

    2. Using index and match in the right way 2

      • MihaiBanciu
    3. Replies
      2
      Views
      518
      2

    4. Niraj

    2. Using IF, AND, OR 3

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

    4. skywriter

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

      • CNeedsHelp
    3. Replies
      4
      Views
      892
      4

    4. royUK

    2. Using COUNTIFS to try to count records between two dates 5

      • cthompson73
    3. Replies
      5
      Views
      499
      5

    4. royUK

    2. Using Countif to calculate totals from another excel tab 1

      • Xani
      • Xani
    3. Replies
      1
      Views
      302
      1

    4. alansidman

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

      • thefatstig
    3. Replies
      2
      Views
      498
      2

    4. pike

    2. Using Address() in a logical test 3

      • OceanRoaming
    3. Replies
      3
      Views
      1.1k
      3

    4. OceanRoaming

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

      • yogeshtalks
    3. Replies
      8
      Views
      2.2k
      8

    4. NBVC

    2. using a formula to find number of days prior to a lost time occuring 8

      • Ryan017
    3. Replies
      8
      Views
      868
      8

    4. Ryan017

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

      • trader1588
    3. Replies
      11
      Views
      1.7k
      11

    4. AliGW

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

      • tac_79
    3. Replies
      2
      Views
      545
      2

    4. tac_79

    2. use xlookup function to retrieve value within another xlookup function 1

      • paulbiddis
    3. Replies
      1
      Views
      423
      1

    4. royUK

Label

Display Options