Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • abba92
    2. Replies
      1
      Views
      502
      1
    3. Luke M

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

      • meggiej
    2. Replies
      1
      Views
      448
      1
    3. alansidman

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

      • abba92
    2. Replies
      1
      Views
      617
      1
    3. abba92

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

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

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

      • GG88
    2. Replies
      1
      Views
      1.6k
      1
    3. NBVC

    1. displaying values from a number of worksheets 2

      • alibaba
    2. Replies
      2
      Views
      644
      2
    3. alibaba

    1. Displaying value according to selected data 1

      • alibaba
    2. Replies
      1
      Views
      437
      1
    3. skywriter

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

      • vanhunk
    2. Replies
      3
      Views
      679
      3
    3. vanhunk

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

      • B.W.B.
    2. Replies
      20
      Views
      2.5k
      20
    3. XOR LX

    1. Date string conversion 6

      • waldis
    2. Replies
      6
      Views
      897
      6
    3. skywriter

    1. Help Needed with If Statement, 5

      • Frederus
    2. Replies
      5
      Views
      774
      5
    3. Infomage

    1. pick items from a list and total them 2

      • rnomis
    2. Replies
      2
      Views
      499
      2
    3. rnomis

    1. Nested array formula for a SUMPRODUCT operation 3

      • Zapillo
    2. Replies
      3
      Views
      738
      3
    3. NBVC

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

      • ajaypal.sp
    2. Replies
      3
      Views
      735
      3
    3. cytop

    1. Multiple Functions for One Cell? 1

      • 5percenter
    2. Replies
      1
      Views
      495
      1
    3. alansidman

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

      • flashkid10
    2. Replies
      2
      Views
      561
      2
    3. flashkid10

    1. Sumif with Offset 2

      • jvalente
    2. Replies
      2
      Views
      1.8k
      2
    3. jvalente

    1. Searching the Substring with the Largest side value 6

      • flashkid10
    2. Replies
      6
      Views
      917
      6
    3. flashkid10

    1. MATCHing a date within a range of dates 3

      • Andante
    2. Replies
      3
      Views
      591
      3
    3. NBVC

    1. Counting Unique Rows (FREQUENCY) 6

      • AFord66
    2. Replies
      6
      Views
      939
      6
    3. sktneer

Display Options