Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default Unique filtering to another sheet ?

I having difficulty with unigue filtering. Probably because it's too close to
tommorrow.

I have a range of numbers in a column. There may be up to a hundred rows.
I want to copy only the unique numbers to another column on another tab.
Is that possible ?

599
478
478
478
478
982
982
785
894

Thanks,

Steve

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default Unique filtering to another sheet ?

Try Advanced Filter


"Steve" wrote:

I having difficulty with unigue filtering. Probably because it's too close to
tommorrow.

I have a range of numbers in a column. There may be up to a hundred rows.
I want to copy only the unique numbers to another column on another tab.
Is that possible ?

599
478
478
478
478
982
982
785
894

Thanks,

Steve

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Unique filtering to another sheet ?

I want to copy only the unique numbers to
another column on another tab.


Let's assume the data to filter is on sheet1 and you want the data extracted
to sheet2 starting in cell A1.

Navigate to sheet2 cell A1 *then* start the filter process.

DataFilterAdvanced filter

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
I having difficulty with unigue filtering. Probably because it's too close
to
tommorrow.

I have a range of numbers in a column. There may be up to a hundred rows.
I want to copy only the unique numbers to another column on another tab.
Is that possible ?

599
478
478
478
478
982
982
785
894

Thanks,

Steve



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default Unique filtering to another sheet ?

Thank you. That was it. I was starting on sheet A.

Thanks again,

Steve

"T. Valko" wrote:

I want to copy only the unique numbers to
another column on another tab.


Let's assume the data to filter is on sheet1 and you want the data extracted
to sheet2 starting in cell A1.

Navigate to sheet2 cell A1 *then* start the filter process.

DataFilterAdvanced filter

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
I having difficulty with unigue filtering. Probably because it's too close
to
tommorrow.

I have a range of numbers in a column. There may be up to a hundred rows.
I want to copy only the unique numbers to another column on another tab.
Is that possible ?

599
478
478
478
478
982
982
785
894

Thanks,

Steve



.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Unique filtering to another sheet ?

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Thank you. That was it. I was starting on sheet A.

Thanks again,

Steve

"T. Valko" wrote:

I want to copy only the unique numbers to
another column on another tab.


Let's assume the data to filter is on sheet1 and you want the data
extracted
to sheet2 starting in cell A1.

Navigate to sheet2 cell A1 *then* start the filter process.

DataFilterAdvanced filter

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
I having difficulty with unigue filtering. Probably because it's too
close
to
tommorrow.

I have a range of numbers in a column. There may be up to a hundred
rows.
I want to copy only the unique numbers to another column on another
tab.
Is that possible ?

599
478
478
478
478
982
982
785
894

Thanks,

Steve



.



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
Filtering for Unique Records captculver Excel Discussion (Misc queries) 3 March 31st 08 04:42 PM
Macro/VBA for filtering unique entries and pasting in another sheet [email protected] Excel Discussion (Misc queries) 1 December 3rd 07 02:50 PM
Filtering Unique Customers vijaydsk1970 Excel Worksheet Functions 1 August 22nd 07 03:08 PM
filtering unique data kuansheng Excel Worksheet Functions 5 May 4th 06 01:50 AM
filtering for unique records KG Excel Discussion (Misc queries) 7 August 13th 05 06:07 PM


All times are GMT +1. The time now is 01:50 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"