Data Cleanup from a List with Multiple Entries

Hi, all.

I have a large database of service invoices. Since our invoice can carry multiple lines, the table in question might have multiple entries for the same invoice number. I'm trying to generate a performance metric dashboard for the service group by employee. Again, the employee can show up multiple times per invoice if he performs different work for each invoice.

I'd also like to condense the list down so there aren't any blank rows between the rows with data.

Ultimately, I need to find each individual invoice that each employee worked on and generate a list from which I can then generate an SPC chart. I'm willing to do this in a couple of stages if necessary. Primarily, I want to avoid using VB script if possible.

So, cherry pick service invoice numbers from a list when matched to an employee's name (VLOOKUP), consolidate multiple entries when that employee's name matches multiple entries of the same service invoice number, and condense the list (preferably as it's built) so there are no blank rows.

Thanks!

Sounds like this can be solved with a Pivot table, but if you can upload a spreadsheet with a sample of raw data and an example of how you would like the finished product to look (just manually key it in) I think you will have a better chance of getting exactly what you want.

prjt,

Pivot Tables. Where in the heck have you been these last months!

This looks to be exactly what I need. Thank you.

Glad to help. If that is all you need please mark your thread as solved (and Rep is always appreciated, though not mandatory ).