Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Dynamic Named Ranges with Intermittent Blanks 3

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

    1. Sum of Calculation in single Cell 4

      • GIRISHBISHT
    2. Replies
      4
      Views
      1k
      4
    3. pike

    1. IF statement to find a value 2

      • SaraO
    2. Replies
      2
      Views
      805
      2
    3. SaraO

    1. Excel Formula Sum of Minimum Values 10

      • GIRISHBISHT
    2. Replies
      10
      Views
      1.8k
      10
    3. pike

    1. Formula to display "Credit" 2

      • SaraO
    2. Replies
      2
      Views
      784
      2
    3. SaraO

    1. Formula: Test for overlapping number ranges 3

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

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

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

    1. Formula Query dependent on outputs of others 4

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

    1. Modified vlookup returning multiple values 2

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

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

      • AntoAnto
    2. Replies
      2
      Views
      727
      2
    3. AntoAnto

    1. Validating for Weekday Date OR Text 2

      • jzehr
    2. Replies
      2
      Views
      762
      2
    3. jzehr

    1. Auto Fill Down Number List 11

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

    1. discount codes 1

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

    1. Give new List including duplicates ignoring zeros 3

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

    1. Randomize an order 2

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

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

      • Delta729
    2. Replies
      2
      Views
      1.9k
      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
      995
      1
    3. Ger Plante

    1. Using IF, AND, OR 3

    2. Replies
      3
      Views
      1.1k
      3
    3. skywriter

Display Options