Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Which SumProduct Sumif or VLookup?
Using XL 2003
Goal: Find those employees charging gas more than once a day. Fields - Date EmpID Amount Output: Filtered XL sheet and/or a printed list of only those employees with more than one gas purchase in a single day -OR- Conditional Formating (cell Color) for those meeting the above criteria I am not sure of the smartest approach to solve quickly. or even the formulas. There are 54,000 purchases by 6500 employees Thanks Dennis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
I've tried Sumproduct, SumIf, Vlookup and Hlookup. | Excel Worksheet Functions | |||
How to combine a vlookup with a sumif function!!! | Excel Discussion (Misc queries) | |||
SUMIF using VLOOKUP as criteria | Excel Worksheet Functions | |||
Sumif not Sumproduct | Excel Worksheet Functions |