Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract 1 of each item
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract 1 of each item
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) "widman" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract 1 of each item
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. On Jun 4, 7:21 pm, widman wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract 1 of each item
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. "Tim879" wrote: 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. On Jun 4, 7:21 pm, widman wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Extract each item in the list | Excel Worksheet Functions | |||
Extract each item in the list | Excel Worksheet Functions | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |