software

I need to know if there is a way to automatically filter for unique records.

I am creating a workbook where one sheet has a list of projects worked
(column one) on and a task associated with the project (column two) and the
number of hours worked (column 3) on that project/task combination. The
next row may or may not have the same project name with a different task

On the second sheet, I used the sumif (if the text in the column on sheet 1
matches the text in the cell on sheet 2) function to add all hours
associated with the project.

It works great except I have to manually place the project name on each row
of the second sheet. (right now I use a data validation list to enter the
project name so I don't have to type or copy and paste it each time)

I would like to find a way to have the project name automatically entered on
the second sheet.

I first tried just using the = sign and then pointing at each cell, but it
does not avoid duplicates.

Then I found the filter for unique records which works great except I would
have to manually apply the filter each time... which I don't want to do.

Any suggestions?

--
Lila
Data / Filter / Advanced Filter
Action: Copy to another location AND
Check the Unique Records only checkbox at the bottom leftI did that, but it only does it that one time. If I change the original
list I have to run the filter again.

Is there a way to do this automatically or maybe another combination of
formulas that would do this?

Lila

quot;Buffgirl71quot; gt; wrote in message oups.com...
gt; Data / Filter / Advanced Filter
gt; Action: Copy to another location AND
gt; Check the Unique Records only checkbox at the bottom left
gt;
If you sort your data, you could use data|subtotals to get the subtotals.

Or maybe it's time to look at pivottables.

If you want to read more about pivottables...

Here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
office.microsoft.com/downloads/2000/XCrtPiv.aspx
office.microsoft.com/assistan...lconPT101.aspx

Lila wrote:
gt;
gt; I need to know if there is a way to automatically filter for unique records.
gt;
gt; I am creating a workbook where one sheet has a list of projects worked
gt; (column one) on and a task associated with the project (column two) and the
gt; number of hours worked (column 3) on that project/task combination. The
gt; next row may or may not have the same project name with a different task
gt;
gt; On the second sheet, I used the sumif (if the text in the column on sheet 1
gt; matches the text in the cell on sheet 2) function to add all hours
gt; associated with the project.
gt;
gt; It works great except I have to manually place the project name on each row
gt; of the second sheet. (right now I use a data validation list to enter the
gt; project name so I don't have to type or copy and paste it each time)
gt;
gt; I would like to find a way to have the project name automatically entered on
gt; the second sheet.
gt;
gt; I first tried just using the = sign and then pointing at each cell, but it
gt; does not avoid duplicates.
gt;
gt; Then I found the filter for unique records which works great except I would
gt; have to manually apply the filter each time... which I don't want to do.
gt;
gt; Any suggestions?
gt;
gt; --
gt; Lila

--

Dave Peterson