Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

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

      • abba92
    3. Replies
      1
      Views
      822
      1

    4. abba92

    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
      884
      2

    4. alibaba

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

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

    4. B.W.B.

    2. Displaying value according to selected data 1

      • alibaba
    3. Replies
      1
      Views
      610
      1

    4. skywriter

    2. Lookup Values in any column 8

      • excelnotit
    3. Replies
      8
      Views
      1.9k
      8

    4. azumi

    2. Date string conversion 6

      • waldis
    3. Replies
      6
      Views
      1.2k
      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
      714
      2

    4. rnomis

    2. Nested array formula for a SUMPRODUCT operation 3

      • Zapillo
    3. Replies
      3
      Views
      1k
      3

    4. NBVC

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

      • ajaypal.sp
    3. Replies
      3
      Views
      1k
      3

    4. cytop

    2. Multiple Functions for One Cell? 1

      • 5percenter
    3. Replies
      1
      Views
      658
      1

    4. alansidman

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

      • flashkid10
    3. Replies
      2
      Views
      820
      2

    4. flashkid10

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

      • vanhunk
    3. Replies
      3
      Views
      928
      3

    4. vanhunk

    2. Sumif with Offset 2

      • jvalente
    3. Replies
      2
      Views
      2.3k
      2

    4. jvalente

    2. MATCHing a date within a range of dates 3

      • Andante
    3. Replies
      3
      Views
      830
      3

    4. NBVC

    2. Counting Unique Rows (FREQUENCY) 6

      • AFord66
    3. Replies
      6
      Views
      1.3k
      6

    4. sktneer

    2. Pulling list from 3 source lists 1

      • dech
    3. Replies
      1
      Views
      541
      1

    4. NBVC

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

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

    4. XOR LX

    2. How to use OFFSET with HLOOKUP 3

      • fstupot
    3. Replies
      3
      Views
      816
      3

    4. cytop

Label

Display Options