Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Formula: Test for overlapping number ranges 3

      • jdawson422
    2. Replies
      3
      Views
      2.4k
      3
    3. p45cal

    1. Allocate points from 0-100 based on value 3

      • morsoe
    2. Replies
      3
      Views
      1.1k
      3
    3. crushdrinker06

    1. Formula Query dependent on outputs of others 4

      • HOC
      • HOC
    2. Replies
      4
      Views
      1k
      4
    3. HOC

    1. Modified vlookup returning multiple values 2

      • COGICPENNY
    2. Replies
      2
      Views
      773
      2
    3. NBVC

    1. Pick and display the right number using different match criterias. 2

      • AntoAnto
    2. Replies
      2
      Views
      690
      2
    3. AntoAnto

    1. Validating for Weekday Date OR Text 2

      • jzehr
    2. Replies
      2
      Views
      735
      2
    3. jzehr

    1. Auto Fill Down Number List 11

      • luarbiasa
    2. Replies
      11
      Views
      1.9k
      11
    3. GIRISHBISHT

    1. discount codes 1

      • whatisVBA
    2. Replies
      1
      Views
      710
      1
    3. Grimes0332

    1. Give new List including duplicates ignoring zeros 3

      • juriemagic
    2. Replies
      3
      Views
      1.1k
      3
    3. FDibbins

    1. Randomize an order 2

      • tommade
    2. Replies
      2
      Views
      939
      2
    3. crushdrinker06

    1. Determine if "Active" if hire and term date are within cells range 2

      • Delta729
    2. Replies
      2
      Views
      1.8k
      2
    3. Delta729

    1. Can A Vlookup W/Search Function Work On A Substring of Text? 6

      • MexicoGuy
    2. Replies
      6
      Views
      1.8k
      6
    3. FDibbins

    1. Count frequency of exact text string. Exact text and character count need to match 1

      • herbiefish
    2. Replies
      1
      Views
      1.4k
      1
    3. Ger Plante

    1. Countif with Index and Match 1

      • A3Eigelaar
    2. Replies
      1
      Views
      939
      1
    3. Ger Plante

    1. Using IF, AND, OR 3

    2. Replies
      3
      Views
      1k
      3
    3. skywriter

    1. Find the max value if the value is not struck through 5

      • hmsiegel
    2. Replies
      5
      Views
      1.5k
      5
    3. skywriter

    1. Lookup Multiple Values in a column with the 1 lookup 1

      • rjw415
    2. Replies
      1
      Views
      976
      1
    3. Ger Plante

    1. Subtract a set value from a cell on a specific day and replace cell value 2

      • ExcelDumDum
    2. Replies
      2
      Views
      848
      2
    3. ExcelDumDum

    1. Archery scorecard for Top 4 Female scores then the Top 8 scores 6

      • shinobi09
    2. Replies
      6
      Views
      1.8k
      6
    3. Grimes0332

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

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

Display Options