Looking up values that are repeated in a column

  • Thread starter Thread starter KC2006
  • Start date Start date
K

KC2006

I am trying lookup data in a table that is repeated numerous times in
column. I want to get the total for that data. For example, Col A i
Proj Name, Col B is cost center, Col C is amount billed, Col D is Mont
billed, and Col E is employee. I want to be able to look up all tha
was billed to Project A for Cost Center 1234 in January...etc. etc..
 
Hi!

Use the Autofilter.

Select a cell in your data range
Goto Data>Filter>AutoFilter

From each drop down select the criteria to filter that column on.

It's real easy!

This could also be done with formulas but it's a whole lot more complicated.

Biff
 
That works for me to see it on the current sheet. What if I hav
another sheet I want the data returned to??? Sort of like doing
VLOOKUP, but returning the sum of the lookups
 
Like I said, it can be done with formulas but it's complicated.

How many rows of data are there? If there are 1000's of rows, using formulas
isn't very efficient.

Biff
 
Hold on there just a second!

I think I may have misunderstood what you want.

You just want the total sum of amounts?

Biff
 
Yes, just the total. For example, if I have 10 employees (10 rows of
data) from cost center 1234 book their time to Project A I want the
total time booked to that project for each month.
 
Back
Top