extract 1 of each item

[widman]

I get spreadsheets that have items repeated on 3 or 4 different lines that I
need to sum to find the real total. No problem with sumif

But how can I make a list of the items without them being repeated?

 

[BobT]

Assuming you are using XL 97, 2000 or XP, you can use Subtotals. Simply
highlight the data and from the DATA menu choose Subtotals. Assuming your
data is sorted, you can get a distinct list of combinations with their
totals. This will also allow you to expand/collapse the list.

Other options you could try:

-Pivot Tables of your data
-Using the Query tool and creating a basic SELECT DISTINCT... query.

Bob Tulk
MOUS (97/XP)

 

[Tim879]

try highlighting the data you want to filter then using Data-> Filter -

Advanced Filter

then select Unique Rows in order to find only the unqiue rows of data.

 

[widman]

I have beenusing subtotals, but it is a pain, having to then extract the
product codes from the text string, etc.
I can't seem to find Query... office XP
And I can't get advance filtering to work. Must be a trick to it.