Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 30th 05, 10:15 PM
[email protected]keEail.cooo
 
Posts: n/a
Default Transfer Items to a list with no duplicates

Hi
I'm after generating a list of items from a column of data (the column is
for describing certain model/specification of items in an other column),
The list should be placed else were on the work sheet,
But I only want the list to have one occurrence of each item (no
duplicates, so I can add a value for each model and then use it for a
Vlookup in a calculation.


Thanks in advance for any help
Kev

  #2   Report Post  
Old March 30th 05, 10:30 PM
Trevor Shuttleworth
 
Posts: n/a
Default

Kev

Use Advanced Filter to select Uniqu Items and copy to another location.

Regards

Trevor


wrote in message
...
Hi
I'm after generating a list of items from a column of data (the column is
for describing certain model/specification of items in an other column),
The list should be placed else were on the work sheet,
But I only want the list to have one occurrence of each item (no
duplicates, so I can add a value for each model and then use it for a
Vlookup in a calculation.


Thanks in advance for any help
Kev





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I list items in a column with totals? andy Excel Discussion (Misc queries) 4 February 22nd 05 09:30 PM
How do I find duplicates in a list JimNC Excel Discussion (Misc queries) 1 February 6th 05 09:40 PM
Indexing items from a pick list Pank Mehta Excel Discussion (Misc queries) 1 February 3rd 05 10:29 AM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 09:32 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 08:10 PM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017