Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ddpen
 
Posts: n/a
Default Creating new worksheet from existing

I would like to create a worksheet with unique values (rows of data, records)
only from a worksheet which contains rows with multiple values. There is an
identifier at the beginning of each row, I only want to see each identifier
1x in the new table. Help is appreciated.
  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

See Chip Pearson's page on working with duplicates and uniques:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy

"ddpen" wrote in message
...
I would like to create a worksheet with unique values (rows of data,

records)
only from a worksheet which contains rows with multiple values. There is

an
identifier at the beginning of each row, I only want to see each

identifier
1x in the new table. Help is appreciated.



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

ddpen

Debra Dalgleish has instructions for extracting uniquw data to another
worksheet.

http://www.contextures.on.ca/xladvfi...html#ExtractWs

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 07:19:04 -0800, "ddpen"
wrote:

I would like to create a worksheet with unique values (rows of data, records)
only from a worksheet which contains rows with multiple values. There is an
identifier at the beginning of each row, I only want to see each identifier
1x in the new table. Help is appreciated.


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 To Refresh Chart Data Without Calculating The Worksheet Carl Bowman Charts and Charting in Excel 5 January 19th 05 10:28 PM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 09:45 AM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 11:12 PM
Linking items GREATER THAN O on another worksheet in the same Work Eddie Shapiro Excel Discussion (Misc queries) 4 December 1st 04 03:55 PM
Worksheet name and Backward compatibility Rich Excel Discussion (Misc queries) 3 November 30th 04 07:10 PM


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

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

About Us

"It's about Microsoft Excel"