Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Replace a row number with a dynamic cell value 3

      • acat
      • acat
    3. Replies
      3
      Views
      2.4k
      3

    4. Carim

    2. Counting number of occurrences of cell with alphanumeric characters in a range 3

      • acat
    3. Replies
      3
      Views
      1.1k
      3

    4. acat

    2. generating named data based on values

      • abz2786
    3. Replies
      0
      Views
      164

    2. Formula to show rental payments due on monthly, quarterly and annual basis 2

      • abs_brum
    3. Replies
      2
      Views
      642
      2

    4. abs_brum

    2. Pull text string between characters 2

      • ablalarom
    3. Replies
      2
      Views
      368
      2

    4. NBVC

    2. compile error expected variable or procedure not module 2

      • abdiwahab
    3. Replies
      2
      Views
      3.4k
      2

    4. royUK

    2. V and H Lookups On Dynamic Data 8

      • abba92
    3. Replies
      8
      Views
      1.2k
      8

    4. markdininn

    2. Looking Up Closest Match Between Two Columns and Within That Row 1

      • abba92
    3. Replies
      1
      Views
      635
      1

    4. Luke M

    2. Lookup Multiple Criteria in a Table and Return Header 1

      • abba92
    3. Replies
      1
      Views
      802
      1

    4. abba92

    2. Conditional formatting formula to highlight alternate groupings of duplicate dates 1

      • abaker77
    3. Replies
      1
      Views
      764
      1

    4. mibdhan

    2. If list A has an item from list B create list C 2

      • aamarb
    3. Replies
      2
      Views
      634
      2

    4. aamarb

    2. Quartile formula error 3

      • aalexander
    3. Replies
      3
      Views
      947
      3

    4. joeu2004

    2. Countif with Index and Match 1

      • A3Eigelaar
    3. Replies
      1
      Views
      1.3k
      1

    4. Ger Plante

    2. Sum from two Tables based on From-To Date criteria 2

      • 7absinth
    3. Replies
      2
      Views
      765
      2

    4. 7absinth

    2. Multiple Functions for One Cell? 1

      • 5percenter
    3. Replies
      1
      Views
      642
      1

    4. alansidman

    2. formula to compare a complete row to find "yes" "no" or blank 9

      • 57Frog
    3. Replies
      9
      Views
      1.3k
      9

    4. AliGW

    2. is it possible to use an inputted cell value as the number of the starting row in a range? 2

      • 3butts
    3. Replies
      2
      Views
      706
      2

    4. 3butts

    2. How to use the values in 2 cells as the range in a lookup 1

      • 3butts
    3. Replies
      1
      Views
      356
      1

    4. Logit

    2. IF AND OR statement 4

      • 3ball
    3. Replies
      4
      Views
      800
      4

    4. Trebor76

    2. Calculating the total commission value from a sliding scale 10

      • 3008300363
    3. Replies
      10
      Views
      1.6k
      10

    4. KjBox

Label

Display Options