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
- 794
1
-
-
-
-
Looking Up Closest Match Between Two Columns and Within That Row 1
- abba92
-
- Replies
- 1
- Views
- 632
1
-
-
-
-
V and H Lookups On Dynamic Data 8
- abba92
-
- Replies
- 8
- Views
- 1.2k
8
-
-
-
-
compile error expected variable or procedure not module 2
- abdiwahab
-
- Replies
- 2
- Views
- 3.3k
2
-
-
-
-
Pull text string between characters 2
- ablalarom
-
- Replies
- 2
- Views
- 357
2
-
-
-
-
Formula to show rental payments due on monthly, quarterly and annual basis 2
- abs_brum
-
- Replies
- 2
- Views
- 635
2
-
-
-
-
generating named data based on values
- abz2786
-
- Replies
- 0
- Views
- 158
-
-
-
-
Counting number of occurrences of cell with alphanumeric characters in a range 3
- acat
-
- Replies
- 3
- Views
- 1.1k
3
-
-
-
-
Replace a row number with a dynamic cell value 3
- acat
-
- Replies
- 3
- Views
- 2.4k
3
-
-
-
-
Address of cell in a range where value is < 0 8
- acat
-
- Replies
- 8
- Views
- 1.7k
8
-
-
-
-
# of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s 19
- AcctgController
-
- Replies
- 19
- Views
- 1.7k
19
-
-
-
-
Drop Down Menu with Two Possible Prefilled Scenarios 1
- actinogen
-
- Replies
- 1
- Views
- 761
1
-
-
-
-
Auto Summing a Column with the hash key from Data in Rows 2
- ad91
-
- Replies
- 2
- Views
- 299
2
-
-
-
-
sum if and subtotal not working 2
- adam80
-
- Replies
- 2
- Views
- 533
2
-
-
-
-
Formula to display numbers only 8
- Adel Althahbah
-
- Replies
- 8
- Views
- 328
8
-
-
-
-
Countif and indirect formula
- AdkinsP
-
- Replies
- 0
- Views
- 173
-
-
-
-
Excel inventory tracking and fair allocation
- adylim
-
- Replies
- 0
- Views
- 215
-
-
-
-
lognormal graph 1
- aeonstorm
-
- Replies
- 1
- Views
- 2.6k
1
-
-
-
-
Employee Breakdown By Half Hour On Rotating 6 Week Schedule (Includes Training Day) 1
- AFerg85
-
- Replies
- 1
- Views
- 748
1
-
-
-
-
Counting Unique Rows (FREQUENCY) 6
- AFord66
-
- Replies
- 6
- Views
- 1.3k
6
-