Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    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. Excel 2013 Create link in each cell that will find the correct cell on another sheet 2

      • MicheleA
    3. Replies
      2
      Views
      639
      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
      537
      1

    4. Ger Plante

    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
      887
      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
      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

    2. VLOOKUP LEFT from LEN COUNT IN SEPARATE TABLE LIST 1

      • taylorpa5
    3. Replies
      1
      Views
      606
      1

    4. alansidman

    2. nested if statements #N/A 2

      • irenesboy
    3. Replies
      2
      Views
      510
      2

    4. irenesboy

    2. Pulling date from different sheet and seeing if it equals or falls between est. dates 3

      • LJones79
    3. Replies
      3
      Views
      675
      3

    4. NBVC

    2. Exact same formula different results. 28

      • her.rockstar
    3. Replies
      28
      Views
      3.9k
      28

    4. NBVC

    2. MODE MATCH Formula (for most common occurance) not considering entire range 13

      • wittonline
    3. Replies
      13
      Views
      1.8k
      13

    4. wittonline

Label

Display Options