Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. generating named data based on values

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

      • abs_brum
    2. Replies
      2
      Views
      668
      2
    3. abs_brum

    1. Pull text string between characters 2

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

    1. compile error expected variable or procedure not module 2

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

    1. V and H Lookups On Dynamic Data 8

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

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

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

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

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

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

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

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

      • aamarb
    2. Replies
      2
      Views
      656
      2
    3. aamarb

    1. Quartile formula error 3

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

    1. Countif with Index and Match 1

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

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

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

    1. Multiple Functions for One Cell? 1

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

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

      • 57Frog
    2. Replies
      9
      Views
      1.4k
      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
      731
      2
    3. 3butts

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

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

    1. IF AND OR statement 4

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

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

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

    1. countif using input cell as range depth 5

      • 1legin
    2. Replies
      5
      Views
      926
      5
    3. 1legin

    1. Pairs of numbers last out by date

      • 1legin
    2. Replies
      0
      Views
      239

Label

Display Options