Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Sumif with Offset 2

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

    1. MATCHing a date within a range of dates 3

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

    1. Counting Unique Rows (FREQUENCY) 6

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

    1. Pulling list from 3 source lists 1

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

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

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

    1. How to use OFFSET with HLOOKUP 3

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

    1. Formula to replace contents of a cell 8

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

    1. Searching the Substring with the Largest side value 6

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

    1. Multiple IFs AND OR 1

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

    1. Finding a DATE in a range of TEXT 4

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

    1. Dynamic Range -start with specific cell content 1

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

    1. concatenate text and numbers 6

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

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

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

    1. Speed of Formulas 4

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

    1. Vlookup to subtract values across worksheets 9

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

    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. Sum the values in one column only unique vauels from another 2

      • vbapadawan
    2. Replies
      2
      Views
      617
      2
    3. vbapadawan

    1. COUNTIF Problem 16

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

    1. percentage difference and if error leave blank 3

      • Gemma86
    2. Replies
      3
      Views
      676
      3
    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