Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • abba92
    3. Replies
      1
      Views
      754
      1

    4. abba92

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

      • abba92
    3. Replies
      1
      Views
      603
      1

    4. Luke M

    2. V and H Lookups On Dynamic Data 8

      • abba92
    3. Replies
      8
      Views
      1.1k
      8

    4. markdininn

    2. compile error expected variable or procedure not module 2

      • abdiwahab
    3. Replies
      2
      Views
      3.2k
      2

    4. royUK

    2. Pull text string between characters 2

      • ablalarom
    3. Replies
      2
      Views
      335
      2

    4. NBVC

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

      • abs_brum
    3. Replies
      2
      Views
      591
      2

    4. abs_brum

    2. generating named data based on values

      • abz2786
    3. Replies
      0
      Views
      150

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

      • acat
    3. Replies
      3
      Views
      930
      3

    4. acat

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

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

    4. Carim

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

      • acat
    3. Replies
      8
      Views
      1.6k
      8

    4. acat

    2. # of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s 19

      • AcctgController
    3. Replies
      19
      Views
      1.6k
      19

    4. George-1947

    2. Drop Down Menu with Two Possible Prefilled Scenarios 1

      • actinogen
    3. Replies
      1
      Views
      727
      1

    4. actinogen

    2. Auto Summing a Column with the hash key from Data in Rows 2

      • ad91
      • ad91
    3. Replies
      2
      Views
      188
      2

    4. ad91

    2. sum if and subtotal not working 2

      • adam80
    3. Replies
      2
      Views
      477
      2

    4. iwrk4dedpr

    2. Countif and indirect formula

      • AdkinsP
    3. Replies
      0
      Views
      163

    2. Excel inventory tracking and fair allocation

      • adylim
    3. Replies
      0
      Views
      173

    2. lognormal graph 1

      • aeonstorm
    3. Replies
      1
      Views
      2.5k
      1

    4. jl2509

    2. Employee Breakdown By Half Hour On Rotating 6 Week Schedule (Includes Training Day) 1

      • AFerg85
    3. Replies
      1
      Views
      713
      1

    4. MrRedli

    2. Counting Unique Rows (FREQUENCY) 6

      • AFord66
    3. Replies
      6
      Views
      1.2k
      6

    4. sktneer

    2. Single thread or multi thread formula 5

      • agog1
    3. Replies
      5
      Views
      1.2k
      5

    4. NBVC

Label

Display Options