Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Filtering Array If statement Criteria Help 3

      • lize
    3. Replies
      3
      Views
      734
      3

    4. NBVC

    2. SUMPRODUCT over dynamic range - No VBA 1

      • al4xms
    3. Replies
      1
      Views
      890
      1

    4. AliGW

    2. Indexing a list in order, based on multiple criteria 11

      • her.rockstar
    3. Replies
      11
      Views
      1.7k
      11

    4. NBVC

    2. Conditional Formatting for a Range 7

      • onexc
    3. Replies
      7
      Views
      1k
      7

    4. onexc

    2. Sum based on three criteria, using two named ranges 4

      • GlassGal
    3. Replies
      4
      Views
      598
      4

    4. GlassGal

    2. Calculate number using index/match based on two criteria 2

      • her.rockstar
    3. Replies
      2
      Views
      791
      2

    4. her.rockstar

    2. Count ifs last 4 or 5 results 15

      • thomascrown
    3. Replies
      15
      Views
      1.8k
      15

    4. NBVC

    2. Predict next occurrence in digital string 0 or 1 2

      • Emphatic
    3. Replies
      2
      Views
      523
      2

    4. Emphatic

    2. Excel 2013 Create link in each cell that will find the correct cell on another sheet 2

      • MicheleA
    3. Replies
      2
      Views
      633
      2

    4. deckerace

    2. Formula find max value for multiple if thens.. between: ">" or "<" and a "," 11

      • davex
    3. Replies
      11
      Views
      2.4k
      11

    4. KjBox

    2. Datevalue Problems 1

      • zeninc
    3. Replies
      1
      Views
      532
      1

    4. Ger Plante

    2. Return date of the largest invoice for a salesperson - index match max ... ifs? 1

      • imthebus
    3. Replies
      1
      Views
      413
      1

    4. Carim

    2. formula for scale 3

      • Marie A.
    3. Replies
      3
      Views
      690
      3

    4. alansidman

    2. Dropdown to populate up to 10 cells at once 1

      • vladc
    3. Replies
      1
      Views
      395
      1

    4. KjBox

    2. Sliding scale in formula for multiple groups 5

      • Marie A.
    3. Replies
      5
      Views
      875
      5

    4. Marie A.

    2. Converting Columns to Rows 9

      • mattenborough
    3. Replies
      9
      Views
      1.6k
      9

    4. mattenborough

    2. 2 groups conditional formating 4

      • kennethbrandon
    3. Replies
      4
      Views
      970
      4

    4. kennethbrandon

    2. Formula showing in cell 3

      • mcgee1505
    3. Replies
      3
      Views
      668
      3

    4. AliGW

    2. Trying to extract data meeting 3 conditions 8

      • Amitouj
    3. Replies
      8
      Views
      1k
      8

    4. alansidman

    2. Hide duplicate running total values. 11

      • Skylane60
    3. Replies
      11
      Views
      2.9k
      11

    4. Skylane60

Label

Display Options