Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Improving long nested long HLookup formulas 1

      • mexiro
    3. Replies
      1
      Views
      544
      1

    4. mexiro

    2. Converting Columns to Rows 9

      • mattenborough
    3. Replies
      9
      Views
      1.7k
      9

    4. mattenborough

    2. SUMPRODUCT over dynamic range - No VBA 1

      • al4xms
    3. Replies
      1
      Views
      901
      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. Sum based on three criteria, using two named ranges 4

      • GlassGal
    3. Replies
      4
      Views
      604
      4

    4. GlassGal

    2. Conditional Formatting for a Range 7

      • onexc
    3. Replies
      7
      Views
      1k
      7

    4. onexc

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

      • her.rockstar
    3. Replies
      2
      Views
      798
      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
      524
      2

    4. Emphatic

    2. Datevalue Problems 1

      • zeninc
    3. Replies
      1
      Views
      537
      1

    4. Ger Plante

    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. MODE MATCH Formula (for most common occurance) not considering entire range 13

      • wittonline
    3. Replies
      13
      Views
      1.8k
      13

    4. wittonline

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

      • imthebus
    3. Replies
      1
      Views
      415
      1

    4. Carim

    2. formula for scale 3

      • Marie A.
    3. Replies
      3
      Views
      698
      3

    4. alansidman

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

      • vladc
    3. Replies
      1
      Views
      397
      1

    4. KjBox

    2. Sliding scale in formula for multiple groups 5

      • Marie A.
    3. Replies
      5
      Views
      888
      5

    4. Marie A.

    2. 2 groups conditional formating 4

      • kennethbrandon
    3. Replies
      4
      Views
      982
      4

    4. kennethbrandon

    2. Formula showing in cell 3

      • mcgee1505
    3. Replies
      3
      Views
      675
      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
      3k
      11

    4. Skylane60

Label

Display Options