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 |
#2
|
|||
|
|||
How about a pivot table (see Help and come back with questions) with date in
left column and EmplID on top row with Amt COUNTED (Not summed) in the data area? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dennis" wrote in message ... 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 |
#3
|
|||
|
|||
Bernie,
Great idea. I switched the data so that I will not run out of columns. I used conditional formatting to highlight those intersections of employee and a value = 1. How can I show just those employees with a value of 2 or more in any one of 62 days? "Bernard Liengme" wrote: How about a pivot table (see Help and come back with questions) with date in left column and EmplID on top row with Amt COUNTED (Not summed) in the data area? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dennis" wrote in message ... 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 |
Reply |
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 |