Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

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

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

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

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

    1. V and H Lookups On Dynamic Data 8

      • abba92
    2. Replies
      8
      Views
      739
      8
    3. markdininn

    1. compile error expected variable or procedure not module 2

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

    1. Pull text string between characters 2

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

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

      • abs_brum
    2. Replies
      2
      Views
      444
      2
    3. abs_brum

    1. generating named data based on values

      • abz2786
    2. Replies
      0
      Views
      85
    1. Counting number of occurrences of cell with alphanumeric characters in a range 3

      • acat
    2. Replies
      3
      Views
      443
      3
    3. acat

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

      • acat
      • acat
    2. Replies
      3
      Views
      728
      3
    3. Carim

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

      • acat
    2. Replies
      8
      Views
      885
      8
    3. acat

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

      • AcctgController
    2. Replies
      19
      Views
      734
      19
    3. George-1947

    1. Drop Down Menu with Two Possible Prefilled Scenarios 1

      • actinogen
    2. Replies
      1
      Views
      609
      1
    3. actinogen

    1. sum if and subtotal not working 2

      • adam80
    2. Replies
      2
      Views
      272
      2
    3. iwrk4dedpr

    1. Countif and indirect formula

      • AdkinsP
    2. Replies
      0
      Views
      102
    1. lognormal graph 1

      • aeonstorm
    2. Replies
      1
      Views
      1.4k
      1
    3. jl2509

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

      • AFerg85
    2. Replies
      1
      Views
      564
      1
    3. MrRedli

    1. Counting Unique Rows (FREQUENCY) 6

      • AFord66
    2. Replies
      6
      Views
      885
      6
    3. sktneer

    1. Single thread or multi thread formula 5

      • agog1
    2. Replies
      5
      Views
      752
      5
    3. NBVC

    1. Increment Alphanumeric cell values based on a range of alphanumeric cell values 3

      • aijazamg
    2. Replies
      3
      Views
      947
      3
    3. AliGW

Display Options