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

    4. alibaba

    2. Displaying value according to selected data 1

      • alibaba
    3. Replies
      1
      Views
      579
      1

    4. skywriter

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

      • vanhunk
    3. Replies
      3
      Views
      897
      3

    4. vanhunk

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

      • B.W.B.
    3. Replies
      20
      Views
      3.8k
      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
      674
      2

    4. rnomis

    2. Nested array formula for a SUMPRODUCT operation 3

      • Zapillo
    3. Replies
      3
      Views
      973
      3

    4. NBVC

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

      • ajaypal.sp
    3. Replies
      3
      Views
      992
      3

    4. cytop

    2. Multiple Functions for One Cell? 1

      • 5percenter
    3. Replies
      1
      Views
      631
      1

    4. alansidman

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

      • flashkid10
    3. Replies
      2
      Views
      784
      2

    4. flashkid10

    2. Sumif with Offset 2

      • jvalente
    3. Replies
      2
      Views
      2.2k
      2

    4. jvalente

    2. Searching the Substring with the Largest side value 6

      • flashkid10
    3. Replies
      6
      Views
      1.3k
      6

    4. flashkid10

    2. MATCHing a date within a range of dates 3

      • Andante
    3. Replies
      3
      Views
      777
      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
      516
      1

    4. NBVC

    2. How to use OFFSET with HLOOKUP 3

      • fstupot
    3. Replies
      3
      Views
      785
      3

    4. cytop

    2. Formula to replace contents of a cell 8

      • ansridhar
    3. Replies
      8
      Views
      1.7k
      8

    4. ansridhar

    2. Finding a DATE in a range of TEXT 4

      • tkaz4
    3. Replies
      4
      Views
      1.2k
      4

    4. curbside

Label

Display Options