sort list
I have a list with item repeated more than once:
item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
sort list
Hi
Your easiest option to achieve this would be to use Advanced Filter - Select your range (ie A1:A100 or whatever) and go DataFilterAdvanced Filter. In the dialog that opens, select "Copy To Another Location", check "Unique Records Only", and seletc a destination for your unique records (eg B1). Hope this helps! Richard On 30 Jan, 09:21, massi wrote: I have a list with item repeated more than once: item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
sort list
Use data-Filter-AdvanceFilter ,
Give the destination range and check unique records -- Thanks Xcelion "massi" wrote: I have a list with item repeated more than once: item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
sort list
Hi
One way Insert a row above your data. Type in a Header e.g. List Mark the block of data including header, then DataFilterAdvanced FilterCopy to choose your next columnclick Unique items -- Regards Roger Govier "massi" wrote in message ... I have a list with item repeated more than once: item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
sort list
perfect.
thanks a lot to both of you! "RichardSchollar" wrote: Hi Your easiest option to achieve this would be to use Advanced Filter - Select your range (ie A1:A100 or whatever) and go DataFilterAdvanced Filter. In the dialog that opens, select "Copy To Another Location", check "Unique Records Only", and seletc a destination for your unique records (eg B1). Hope this helps! Richard On 30 Jan, 09:21, massi wrote: I have a list with item repeated more than once: item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
sort list
if i don't include the header the first item is repeated twice. am i doing
something wrong? "Roger Govier" wrote: Hi One way Insert a row above your data. Type in a Header e.g. List Mark the block of data including header, then DataFilterAdvanced FilterCopy to choose your next columnclick Unique items -- Regards Roger Govier "massi" wrote in message ... I have a list with item repeated more than once: item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
sort list
No, that's what happens if the list does not have a header.
Put a header in, even if you delete the row after you have carried out the Advanced Filter. -- Regards Roger Govier "massi" wrote in message ... if i don't include the header the first item is repeated twice. am i doing something wrong? "Roger Govier" wrote: Hi One way Insert a row above your data. Type in a Header e.g. List Mark the block of data including header, then DataFilterAdvanced FilterCopy to choose your next columnclick Unique items -- Regards Roger Govier "massi" wrote in message ... I have a list with item repeated more than once: item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
sort list
ok.
will do thanks "Roger Govier" wrote: No, that's what happens if the list does not have a header. Put a header in, even if you delete the row after you have carried out the Advanced Filter. -- Regards Roger Govier "massi" wrote in message ... if i don't include the header the first item is repeated twice. am i doing something wrong? "Roger Govier" wrote: Hi One way Insert a row above your data. Type in a Header e.g. List Mark the block of data including header, then DataFilterAdvanced FilterCopy to choose your next columnclick Unique items -- Regards Roger Govier "massi" wrote in message ... I have a list with item repeated more than once: item A item A item B item B item B item C item C in the next column i would like to list all the items once only item A item B item C how can i do that? rgds |
All times are GMT +1. The time now is 01:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com