Excel Formulas

Questions related specifically to the use of Excel formulas.

    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
      935
      6
    3. sktneer

    1. Pulling list from 3 source lists 1

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

    1. How to use OFFSET with HLOOKUP 3

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

    1. Formula to replace contents of a cell 8

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

    1. Finding a DATE in a range of TEXT 4

      • tkaz4
    2. Replies
      4
      Views
      885
      4
    3. curbside

    1. INDEX MATCH with multiple lookup_arrays/references 12

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

    1. Multiple IFs AND OR 1

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

    1. Dynamic Named Ranges with Intermittent Blanks 3

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

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

      • Nickexcel22
    2. Replies
      1
      Views
      729
      1
    3. Green Crocodile

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

      • diez
      • diez
    2. Replies
      2
      Views
      788
      2
    3. Green Crocodile

    1. Dynamic Range -start with specific cell content 1

      • Feedoffice1
    2. Replies
      1
      Views
      509
      1
    3. AliGW

    1. Speed of Formulas 4

      • JoshF7
    2. Replies
      4
      Views
      878
      4
    3. JoshF7

    1. concatenate text and numbers 6

      • lolstre.loster
    2. Replies
      6
      Views
      1.2k
      6
    3. AliGW

    1. Sumproduct with blank criteria 7

      • DaneMark
    2. Replies
      7
      Views
      1.4k
      7
    3. XOR LX

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

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

    1. Vlookup to subtract values across worksheets 9

      • RobertJ
    2. Replies
      9
      Views
      3.6k
      9
    3. AliGW

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

      • vbapadawan
    2. Replies
      2
      Views
      646
      2
    3. vbapadawan

    1. COUNTIF Problem 16

      • endl3ss
    2. Replies
      16
      Views
      1.7k
      16
    3. AliGW

    1. Find a value in a row and column, return intersecting cell value 6

      • t33p33
    2. Replies
      6
      Views
      1.3k
      6
    3. cytop

Display Options