Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Dynamic Named Ranges with Intermittent Blanks 3

      • dtp81390
    2. Replies
      3
      Views
      1.7k
      3
    3. royUK

    1. Multiple IFs AND OR 1

      • creative_abhi
    2. Replies
      1
      Views
      587
      1
    3. cytop

    1. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    2. Replies
      12
      Views
      2.4k
      12
    3. B.W.B.

    1. Finding a DATE in a range of TEXT 4

      • tkaz4
    2. Replies
      4
      Views
      1.1k
      4
    3. curbside

    1. Formula to replace contents of a cell 8

      • ansridhar
    2. Replies
      8
      Views
      1.7k
      8
    3. ansridhar

    1. How to use OFFSET with HLOOKUP 3

      • fstupot
    2. Replies
      3
      Views
      763
      3
    3. cytop

    1. Pulling list from 3 source lists 1

      • dech
    2. Replies
      1
      Views
      499
      1
    3. NBVC

    1. Counting Unique Rows (FREQUENCY) 6

      • AFord66
    2. Replies
      6
      Views
      1.2k
      6
    3. sktneer

    1. MATCHing a date within a range of dates 3

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

    1. Searching the Substring with the Largest side value 6

      • flashkid10
    2. Replies
      6
      Views
      1.2k
      6
    3. flashkid10

    1. Sumif with Offset 2

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

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

      • flashkid10
    2. Replies
      2
      Views
      735
      2
    3. flashkid10

    1. Multiple Functions for One Cell? 1

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

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

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

    1. Nested array formula for a SUMPRODUCT operation 3

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

    1. pick items from a list and total them 2

      • rnomis
    2. Replies
      2
      Views
      644
      2
    3. rnomis

    1. Help Needed with If Statement, 5

      • Frederus
    2. Replies
      5
      Views
      1.1k
      5
    3. Infomage

    1. Date string conversion 6

      • waldis
    2. Replies
      6
      Views
      1.1k
      6
    3. skywriter

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

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

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

      • vanhunk
    2. Replies
      3
      Views
      870
      3
    3. vanhunk

Label

Display Options