If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to combine a vlookup with a sumif function!!! | Mark the Shark | General Discussion | 2 | April 6th, 2005 11:54 AM |
Forget SUMIF, COUNTIF and VLOOKUP | Pierre Leclerc | Worksheet Functions | 15 | November 22nd, 2004 12:34 AM |
SUMIF vs SUM(IF(..)) vs SUMPRODUCT | Harlan Grove | Worksheet Functions | 7 | July 1st, 2004 10:22 PM |
SUMIF vs SUM(IF(..)) vs SUMPRODUCT | Harlan Grove | General Discussion | 7 | July 1st, 2004 10:22 PM |
Vlookup and SumIf Problem | andyj | Worksheet Functions | 4 | October 2nd, 2003 08:24 AM |