Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

    1. Multiple Functions for One Cell? 1

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

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

      • flashkid10
    2. Replies
      2
      Views
      544
      2
    3. flashkid10

    1. Sumif with Offset 2

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

    1. Searching the Substring with the Largest side value 6

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

    1. MATCHing a date within a range of dates 3

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

    1. Counting Unique Rows (FREQUENCY) 6

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

    1. Pulling list from 3 source lists 1

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

    1. How to use OFFSET with HLOOKUP 3

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

    1. Formula to replace contents of a cell 8

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

    1. Finding a DATE in a range of TEXT 4

      • tkaz4
    2. Replies
      4
      Views
      865
      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
      446
      1
    3. cytop

    1. Dynamic Named Ranges with Intermittent Blanks 3

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

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

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

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

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

    1. Dynamic Range -start with specific cell content 1

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

    1. Speed of Formulas 4

      • JoshF7
    2. Replies
      4
      Views
      844
      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.3k
      7
    3. XOR LX

Display Options