If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
summarising a list of data from numerous times down to once
Hi -
The following is data I grab from my business system to tell me that I have parts in a location that still need to be counted in stock take - I spit a report that lists every location of every part - however I only want to see a list of the individual locations yet to be counted Using the following data (but a much longer list) A 1 09B02 2 09B04 3 07C06 4 03G09 5 09B02 6 03D02 7 09B02 8 07C06 9 09B02 I am trying to summarise (say on "Sheet 2") all the different locations that need to be counted - so like this 09B02 (shown only once even though it appears 3 other times) 09B04 07C06 (shown only once even though shown 1 other time) 03G09 03D02 |
#2
|
|||
|
|||
summarising a list of data from numerous times down to once
You can do this easily with the advanced filter. See this:
http://contextures.com/xladvfilter01.html#FilterUR Note that if you want the results to appear on a different sheet start the process from that sheet. -- Biff Microsoft Excel MVP "Dubbo" wrote in message ... Hi - The following is data I grab from my business system to tell me that I have parts in a location that still need to be counted in stock take - I spit a report that lists every location of every part - however I only want to see a list of the individual locations yet to be counted Using the following data (but a much longer list) A 1 09B02 2 09B04 3 07C06 4 03G09 5 09B02 6 03D02 7 09B02 8 07C06 9 09B02 I am trying to summarise (say on "Sheet 2") all the different locations that need to be counted - so like this 09B02 (shown only once even though it appears 3 other times) 09B04 07C06 (shown only once even though shown 1 other time) 03G09 03D02 |
Thread Tools | |
Display Modes | |
|
|