Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    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
      857
      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
      590
      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.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
      692
      2

    4. rnomis

    2. Nested array formula for a SUMPRODUCT operation 3

      • Zapillo
    3. Replies
      3
      Views
      988
      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
      642
      1

    4. alansidman

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

      • flashkid10
    3. Replies
      2
      Views
      795
      2

    4. flashkid10

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

      • vanhunk
    3. Replies
      3
      Views
      902
      3

    4. vanhunk

    2. Sumif with Offset 2

      • jvalente
    3. Replies
      2
      Views
      2.2k
      2

    4. jvalente

    2. MATCHing a date within a range of dates 3

      • Andante
    3. Replies
      3
      Views
      795
      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
      525
      1

    4. NBVC

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

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

    4. XOR LX

    2. How to use OFFSET with HLOOKUP 3

      • fstupot
    3. Replies
      3
      Views
      798
      3

    4. cytop

    2. Formula to replace contents of a cell 8

      • ansridhar
    3. Replies
      8
      Views
      1.8k
      8

    4. ansridhar

Label

Display Options