Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Lookup Multiple Criteria in a Table and Return Header 1
- abba92
-
- Replies
- 1
- Views
- 754
1
-
-
-
-
Looking Up Closest Match Between Two Columns and Within That Row 1
- abba92
-
- Replies
- 1
- Views
- 603
1
-
-
-
-
V and H Lookups On Dynamic Data 8
- abba92
-
- Replies
- 8
- Views
- 1.1k
8
-
-
-
-
compile error expected variable or procedure not module 2
- abdiwahab
-
- Replies
- 2
- Views
- 3.2k
2
-
-
-
-
Pull text string between characters 2
- ablalarom
-
- Replies
- 2
- Views
- 335
2
-
-
-
-
Formula to show rental payments due on monthly, quarterly and annual basis 2
- abs_brum
-
- Replies
- 2
- Views
- 591
2
-
-
-
-
generating named data based on values
- abz2786
-
- Replies
- 0
- Views
- 150
-
-
-
-
Counting number of occurrences of cell with alphanumeric characters in a range 3
- acat
-
- Replies
- 3
- Views
- 930
3
-
-
-
-
Replace a row number with a dynamic cell value 3
- acat
-
- Replies
- 3
- Views
- 2.1k
3
-
-
-
-
Address of cell in a range where value is < 0 8
- acat
-
- Replies
- 8
- Views
- 1.6k
8
-
-
-
-
# of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s 19
- AcctgController
-
- Replies
- 19
- Views
- 1.6k
19
-
-
-
-
Drop Down Menu with Two Possible Prefilled Scenarios 1
- actinogen
-
- Replies
- 1
- Views
- 727
1
-
-
-
-
Auto Summing a Column with the hash key from Data in Rows 2
- ad91
-
- Replies
- 2
- Views
- 188
2
-
-
-
-
sum if and subtotal not working 2
- adam80
-
- Replies
- 2
- Views
- 477
2
-
-
-
-
Countif and indirect formula
- AdkinsP
-
- Replies
- 0
- Views
- 163
-
-
-
-
Excel inventory tracking and fair allocation
- adylim
-
- Replies
- 0
- Views
- 173
-
-
-
-
lognormal graph 1
- aeonstorm
-
- Replies
- 1
- Views
- 2.5k
1
-
-
-
-
Employee Breakdown By Half Hour On Rotating 6 Week Schedule (Includes Training Day) 1
- AFerg85
-
- Replies
- 1
- Views
- 713
1
-
-
-
-
Counting Unique Rows (FREQUENCY) 6
- AFord66
-
- Replies
- 6
- Views
- 1.2k
6
-
-
-
-
Single thread or multi thread formula 5
- agog1
-
- Replies
- 5
- Views
- 1.2k
5
-