Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Searching the Substring with the Largest side value 6

      • flashkid10
    3. Replies
      6
      Views
      1.2k
      6

    4. flashkid10

    2. MATCHing a date within a range of dates 3

      • Andante
    3. Replies
      3
      Views
      757
      3

    4. NBVC

    2. Counting Unique Rows (FREQUENCY) 6

      • AFord66
    3. Replies
      6
      Views
      1.2k
      6

    4. sktneer

    2. Pulling list from 3 source lists 1

      • dech
    3. Replies
      1
      Views
      506
      1

    4. NBVC

    2. How to use OFFSET with HLOOKUP 3

      • fstupot
    3. Replies
      3
      Views
      771
      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

    2. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    3. Replies
      12
      Views
      2.5k
      12

    4. B.W.B.

    2. Multiple IFs AND OR 1

      • creative_abhi
    3. Replies
      1
      Views
      590
      1

    4. cytop

    2. Dynamic Named Ranges with Intermittent Blanks 3

      • dtp81390
    3. Replies
      3
      Views
      1.7k
      3

    4. royUK

    2. How to ignore columns using offset formula? (Moving reference cell) 1

      • Nickexcel22
    3. Replies
      1
      Views
      1.1k
      1

    4. Green Crocodile

    2. Adding additional fomulas to existing links from multiple sources 2

      • diez
      • diez
    3. Replies
      2
      Views
      950
      2

    4. Green Crocodile

    2. Dynamic Range -start with specific cell content 1

      • Feedoffice1
    3. Replies
      1
      Views
      613
      1

    4. AliGW

    2. Speed of Formulas 4

      • JoshF7
    3. Replies
      4
      Views
      1.2k
      4

    4. JoshF7

    2. concatenate text and numbers 6

      • lolstre.loster
    3. Replies
      6
      Views
      1.5k
      6

    4. AliGW

    2. Sumproduct with blank criteria 7

      • DaneMark
    3. Replies
      7
      Views
      2.1k
      7

    4. XOR LX

    2. if isnumber search and iserror vlookup index match - used together. 2

      • Emile du Toit
    3. Replies
      2
      Views
      2k
      2

    4. Emile du Toit

    2. Vlookup to subtract values across worksheets 9

      • RobertJ
    3. Replies
      9
      Views
      5k
      9

    4. AliGW

    2. Sum the values in one column only unique vauels from another 2

      • vbapadawan
    3. Replies
      2
      Views
      852
      2

    4. vbapadawan

    2. COUNTIF Problem 16

      • endl3ss
    3. Replies
      16
      Views
      2.3k
      16

    4. AliGW

Label

Display Options