Extract Values from a Column

B

Brandt

I have a worksheet used to track time spent on various jobs. One column is for the JOB # while others are for descriptions, etc. I would like to have formulas or possible a macro (if necessary) to sum the time spent on different jobs. For example, say (for simplicity) that each row is equal to 1 unit of time. Then in this row I put 342 for JOB # 342. After the entire day I have worked on say 5 different jobs. I would like to have a cell that says "Total time spent on Job # 342" and then next to it a formula that would look at the column and count all the values that are equal to 342. Additionally, is there a way to look at that column and have it tell me the number of unique entries and what they are (say 342, 339, 351, etc)

Thanks for any help

Brandt
 
M

mzehr

Hi Brandt
Sounds like the thing you want to use is a pivot table.
It will summarize all of your data, and give you all the
unique values in the column
See the following web sites for an excellent intro into
setting up and using pivot tables:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm
http://www.contextures.com/xlPivot02.html
-----Original Message-----
I have a worksheet used to track time spent on various
Click to expand...
jobs. One column is for the JOB # while others are for
descriptions, etc. I would like to have formulas or
possible a macro (if necessary) to sum the time spent on
different jobs. For example, say (for simplicity) that
each row is equal to 1 unit of time. Then in this row I
put 342 for JOB # 342. After the entire day I have worked
on say 5 different jobs. I would like to have a cell that
says "Total time spent on Job # 342" and then next to it a
formula that would look at the column and count all the
values that are equal to 342. Additionally, is there a
way to look at that column and have it tell me the number
of unique entries and what they are (say 342, 339, 351,
etc)?
 
Top