Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. INCREMENT NUMERICAL STRING BY 1 17

      • Garth Lean
    2. Replies
      17
      Views
      1.6k
      17
    3. MandyRead

    1. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    2. Replies
      3
      Views
      1.6k
      3
    3. AliGW

    1. Match a value against a date and enter the matched value 41

      • khanaran
    2. Replies
      41
      Views
      1.6k
      41
    3. Carim

    1. Finding the Median for certain dates from a list of data 12

      • moyad612013
    2. Replies
      12
      Views
      1.6k
      12
    3. NBVC

    1. YTD using dynamic spilled array 11

      • MatthewHart
    2. Replies
      11
      Views
      1.6k
      11
    3. AliGW

    1. Find the max value if the value is not struck through 5

      • hmsiegel
    2. Replies
      5
      Views
      1.6k
      5
    3. skywriter

    1. IF forumla to check if a value falls between two numbers 1

      • GG88
    2. Replies
      1
      Views
      1.6k
      1
    3. NBVC

    1. Sumproduct with blank criteria 7

      • DaneMark
    2. Replies
      7
      Views
      1.5k
      7
    3. XOR LX

    1. Sum non-consecutive/contiguous cells by Month and Year 5

      • tac_79
    2. Replies
      5
      Views
      1.5k
      5
    3. tac_79

    1. Double counting in SUMPRODUCT formula 11

      • Luis Ah-Hoy Jr.
    2. Replies
      11
      Views
      1.5k
      11
    3. Luis Ah-Hoy Jr.

    1. Highlight largest value cell in range based on other columns 15

      • paul789
    2. Replies
      15
      Views
      1.5k
      15
    3. AliGW

    1. alert levels 12

      • zohar
    2. Replies
      12
      Views
      1.5k
      12
    3. zohar

    1. Nested IF Statement Alternative 8

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

    1. FORECAST, in single cell, from 4 sheets? 10

      • B.W.B.
    2. Replies
      10
      Views
      1.5k
      10
    3. B.W.B.

    1. Count Unique values with multiple criteria 4

      • mdnuts
    2. Replies
      4
      Views
      1.4k
      4
    3. mdnuts

    1. excel dynamic hyperlink to web address is not dynamic at all using HYPERLINK function 8

      • CptnKirk
    2. Replies
      8
      Views
      1.4k
      8
    3. Carim

    1. Set cell value using based on cell length 6

      • JohnJonathan
    2. Replies
      6
      Views
      1.4k
      6
    3. bosco_yip

    1. Calculate time if greater than specific time in excel? 16

      • Xani
      • Xani
    2. Replies
      16
      Views
      1.4k
      16
    3. Xani

    1. sorting and presenting top values only once 22

      • nircom
    2. Replies
      22
      Views
      1.4k
      22
    3. Carim

    1. Balance carried forward 2

      • Aussiebuilder
    2. Replies
      2
      Views
      1.4k
      2
    3. KjBox

Display Options