Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • acat
      • acat
    2. Replies
      3
      Views
      2.2k
      3
    3. Carim

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

      • acat
    2. Replies
      3
      Views
      1k
      3
    3. acat

    1. generating named data based on values

      • abz2786
    2. Replies
      0
      Views
      157
    1. Formula to show rental payments due on monthly, quarterly and annual basis 2

      • abs_brum
    2. Replies
      2
      Views
      616
      2
    3. abs_brum

    1. Pull text string between characters 2

      • ablalarom
    2. Replies
      2
      Views
      345
      2
    3. NBVC

    1. compile error expected variable or procedure not module 2

      • abdiwahab
    2. Replies
      2
      Views
      3.3k
      2
    3. royUK

    1. V and H Lookups On Dynamic Data 8

      • abba92
    2. Replies
      8
      Views
      1.1k
      8
    3. markdininn

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

      • abba92
    2. Replies
      1
      Views
      621
      1
    3. Luke M

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

      • abba92
    2. Replies
      1
      Views
      780
      1
    3. abba92

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

      • abaker77
    2. Replies
      1
      Views
      708
      1
    3. mibdhan

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

      • aamarb
    2. Replies
      2
      Views
      600
      2
    3. aamarb

    1. Quartile formula error 3

      • aalexander
    2. Replies
      3
      Views
      920
      3
    3. joeu2004

    1. Countif with Index and Match 1

      • A3Eigelaar
    2. Replies
      1
      Views
      1.3k
      1
    3. Ger Plante

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

      • 7absinth
    2. Replies
      2
      Views
      738
      2
    3. 7absinth

    1. Multiple Functions for One Cell? 1

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

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

      • 57Frog
    2. Replies
      9
      Views
      1.3k
      9
    3. AliGW

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

      • 3butts
    2. Replies
      2
      Views
      683
      2
    3. 3butts

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

      • 3butts
    2. Replies
      1
      Views
      341
      1
    3. Logit

    1. IF AND OR statement 4

      • 3ball
    2. Replies
      4
      Views
      756
      4
    3. Trebor76

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

      • 3008300363
    2. Replies
      10
      Views
      1.6k
      10
    3. KjBox

Label

Display Options