Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Address of cell in a range where value is < 0 8

      • acat
    2. Replies
      8
      Views
      1.6k
      8
    3. acat

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

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

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

      • acat
    2. Replies
      3
      Views
      953
      3
    3. acat

    1. generating named data based on values

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

      • abs_brum
    2. Replies
      2
      Views
      597
      2
    3. abs_brum

    1. Pull text string between characters 2

      • ablalarom
    2. Replies
      2
      Views
      335
      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
      607
      1
    3. Luke M

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

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

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

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

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

      • aamarb
    2. Replies
      2
      Views
      583
      2
    3. aamarb

    1. Quartile formula error 3

      • aalexander
    2. Replies
      3
      Views
      908
      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
      714
      2
    3. 7absinth

    1. Multiple Functions for One Cell? 1

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

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

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

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

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

    1. IF AND OR statement 4

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

Label

Display Options