Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Help with shifting table columns 1

      • flashkid10
    3. Replies
      1
      Views
      565
      1

    4. Luke M

    2. Calculate days between 2 dates 3

      • angelic1
    3. Replies
      3
      Views
      2.8k
      3

    4. S O

    2. Quartile formula error 3

      • aalexander
    3. Replies
      3
      Views
      920
      3

    4. joeu2004

    2. Looking Up Closest Match Between Two Columns and Within That Row 1

      • abba92
    3. Replies
      1
      Views
      621
      1

    4. Luke M

    2. Only if a time is larger than a different time so how larger it is. 1

      • meggiej
    3. Replies
      1
      Views
      541
      1

    4. alansidman

    2. Lookup Multiple Criteria in a Table and Return Header 1

      • abba92
    3. Replies
      1
      Views
      780
      1

    4. abba92

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

      • B.W.B.
    3. Replies
      10
      Views
      1.9k
      10

    4. B.W.B.

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

      • GG88
    3. Replies
      1
      Views
      1.7k
      1

    4. NBVC

    2. displaying values from a number of worksheets 2

      • alibaba
    3. Replies
      2
      Views
      818
      2

    4. alibaba

    2. Displaying value according to selected data 1

      • alibaba
    3. Replies
      1
      Views
      562
      1

    4. skywriter

    2. Return the last number in a range that is not in a coloured cell 3

      • vanhunk
    3. Replies
      3
      Views
      877
      3

    4. vanhunk

    2. Find Max number value from text-number cell? 20

      • B.W.B.
    3. Replies
      20
      Views
      3.7k
      20

    4. XOR LX

    2. Date string conversion 6

      • waldis
    3. Replies
      6
      Views
      1.1k
      6

    4. skywriter

    2. Help Needed with If Statement, 5

      • Frederus
    3. Replies
      5
      Views
      1.1k
      5

    4. Infomage

    2. pick items from a list and total them 2

      • rnomis
    3. Replies
      2
      Views
      656
      2

    4. rnomis

    2. Nested array formula for a SUMPRODUCT operation 3

      • Zapillo
    3. Replies
      3
      Views
      951
      3

    4. NBVC

    2. Position code to be extract based on multiple criteria 3

      • ajaypal.sp
    3. Replies
      3
      Views
      967
      3

    4. cytop

    2. Multiple Functions for One Cell? 1

      • 5percenter
    3. Replies
      1
      Views
      623
      1

    4. alansidman

    2. find row number of all cells that contain substring 2

      • flashkid10
    3. Replies
      2
      Views
      743
      2

    4. flashkid10

    2. Sumif with Offset 2

      • jvalente
    3. Replies
      2
      Views
      2.2k
      2

    4. jvalente

Label

Display Options