Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Gathering name of products which have a same discount percentage 10
- Q2Be
-
- Replies
- 10
- Views
- 1k
10
-
-
-
-
color rows with almost same amount which appear more than twice with CF 6
- RAJESH SHAH
-
- Replies
- 6
- Views
- 966
6
-
-
-
-
IF Functions and tolerances. 3
- Shezmo1
-
- Replies
- 3
- Views
- 318
3
-
-
-
-
Collate data from last x days based on todays date 7
- DezB
-
- Replies
- 7
- Views
- 479
7
-
-
-
-
Color code bar chart data bars based on a y- axis criteria dynamically 1
- CapG
-
- Replies
- 1
- Views
- 712
1
-
-
-
-
Format a cell based on information in another worksheet
- DSessions
-
- Replies
- 0
- Views
- 251
-
-
-
-
Formula to calculate COGS value using different prices based on qty available in different locations 1
- jpetraityte
-
- Replies
- 1
- Views
- 933
1
-
-
-
-
index Match not producing proper results 9
- Billyrj
-
- Replies
- 9
- Views
- 1.5k
9
-
-
-
-
AND statement using multiple VLOOKUP criteria 3
- stilton
-
- Replies
- 3
- Views
- 333
3
-
-
-
-
Max value lookup 3
- Raha
-
- Replies
- 3
- Views
- 433
3
-
-
-
-
VlookUp Crawls 3
- asdf_99
-
- Replies
- 3
- Views
- 309
3
-
-
-
-
Calculating year to date sum based on category 1
- John9411
-
- Replies
- 1
- Views
- 214
1
-
-
-
-
COUNTIFS Formula Not Counting "1/0/1900" Date 1
- JAMIEPACHOMSKI
-
- Replies
- 1
- Views
- 298
1
-
-
-
-
Slow Procces
- Pedro003
-
- Replies
- 0
- Views
- 156
-
-
-
-
Wilcard for vlookup
- Pedro003
-
- Replies
- 0
- Views
- 225
-
-
-
-
Test to columns help please 4
- Elso1959
-
- Replies
- 4
- Views
- 256
4
-
-
-
-
Formula to apply conditional formatting to highlight specific cells based the cell to the left
- CapG
-
- Replies
- 0
- Views
- 419
-
-
-
-
Count overlapping time periods with condition
- Daphilo
-
- Replies
- 0
- Views
- 319
-
-
-
-
automatic static date 1
- Pedro003
-
- Replies
- 1
- Views
- 303
1
-
-
-
-
Using SUBTOTAL formula within an IF formula 2
- davec0864
-
- Replies
- 2
- Views
- 313
2
-