Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
color rows with almost same amount which appear more than twice with CF 6
- RAJESH SHAH
-
- Replies
- 6
- Views
- 996
6
-
-
-
-
Format a cell based on information in another worksheet
- DSessions
-
- Replies
- 0
- Views
- 266
-
-
-
-
Color code bar chart data bars based on a y- axis criteria dynamically 1
- CapG
-
- Replies
- 1
- Views
- 731
1
-
-
-
-
Gathering name of products which have a same discount percentage 10
- Q2Be
-
- Replies
- 10
- Views
- 1k
10
-
-
-
-
Formula to calculate COGS value using different prices based on qty available in different locations 1
- jpetraityte
-
- Replies
- 1
- Views
- 948
1
-
-
-
-
AND statement using multiple VLOOKUP criteria 3
- stilton
-
- Replies
- 3
- Views
- 390
3
-
-
-
-
Calculating year to date sum based on category 1
- John9411
-
- Replies
- 1
- Views
- 237
1
-
-
-
-
COUNTIFS Formula Not Counting "1/0/1900" Date 1
- JAMIEPACHOMSKI
-
- Replies
- 1
- Views
- 341
1
-
-
-
-
Slow Procces
- Pedro003
-
- Replies
- 0
- Views
- 177
-
-
-
-
Wilcard for vlookup
- Pedro003
-
- Replies
- 0
- Views
- 261
-
-
-
-
VlookUp Crawls 3
- asdf_99
-
- Replies
- 3
- Views
- 340
3
-
-
-
-
Test to columns help please 4
- Elso1959
-
- Replies
- 4
- Views
- 296
4
-
-
-
-
Formula to apply conditional formatting to highlight specific cells based the cell to the left
- CapG
-
- Replies
- 0
- Views
- 431
-
-
-
-
Count overlapping time periods with condition
- Daphilo
-
- Replies
- 0
- Views
- 346
-
-
-
-
Using SUBTOTAL formula within an IF formula 2
- davec0864
-
- Replies
- 2
- Views
- 365
2
-
-
-
-
Help Extracting Data From String 2
- gjwilson1216
-
- Replies
- 2
- Views
- 361
2
-
-
-
-
Vlookup across multiple worksheets and list sheet names 1
- onexc
-
- Replies
- 1
- Views
- 352
1
-
-
-
-
Add text to formula 2
- idrees ms
-
- Replies
- 2
- Views
- 306
2
-
-
-
-
Return cell value from closed WB using variable file path[s] 1
- Sleeplol
-
- Replies
- 1
- Views
- 290
1
-
-
-
-
Identify weekend that has the max number of occurrences 5
- SansSuit
-
- Replies
- 5
- Views
- 389
5
-