Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 5
Default nique Value Macro requested

I need a macro to do the following:

1. I have a spreadsheet with 10 rows and 7 columns (70 cells
totally).

2. These cells will be filled with values (X,Y,Z etc.).

3. I need to take the unique values alone from these cells and copy it
to another sheet in the same workbook.

I've been trying so many options (Data filter, formulas etc). Can any one
please help me out?

seena




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 081029-0, 10/29/2008
Tested on: 10/30/2008 1:12:55 PM
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com



  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default nique Value Macro requested

Assuming you want the unique combinations in a set of columns, it
sounds like a job for
Data Filter Advanced Filter Copy to another location Select the
columns concerned as the source range Unique values only.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 2,344
Default nique Value Macro requested

Hi,

First try the manual way and then record the steps. Copy each of the seven
columns of 10 rows and paste them below the entries in the first column. So
if your data is in A1:G10. copy B1:B10 and paste it to cell A11. Continue
until all the data is in column A.

Select all the data in column A and choose the command Data, Filter,
Advanced Filter, choose Filter the list in Place. Make sure your range is in
the List range box, don't enter a Criteria range. Select the Unique records
only option and click OK.

Highlight the visible cells of data in column A and choose Copy. Move to
the other sheet and choose Paste.

Move back to the first sheet and highlight the data from A11 down and clear
it.

Record these steps by turning on the macro recorder - Tools, Macro, Record
new macro. When your finished turn the recorded off - Stop recorder.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Srinivasulu Bhattaram" wrote:

I need a macro to do the following:

1. I have a spreadsheet with 10 rows and 7 columns (70 cells
totally).

2. These cells will be filled with values (X,Y,Z etc.).

3. I need to take the unique values alone from these cells and copy it
to another sheet in the same workbook.

I've been trying so many options (Data filter, formulas etc). Can any one
please help me out?

seena




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 081029-0, 10/29/2008
Tested on: 10/30/2008 1:12:55 PM
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com




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
Formula help requested [email protected] Excel Worksheet Functions 5 June 25th 08 07:04 PM
sum if formula help requested Ann Excel Worksheet Functions 4 June 25th 07 10:16 PM
A challenge, Serious help requested dps9460 New Users to Excel 11 June 3rd 06 09:46 PM
Help Requested on Formula Rich Rosier Excel Worksheet Functions 4 April 2nd 06 09:07 PM
Help requested (quite long!) Lee Davison Excel Discussion (Misc queries) 7 April 13th 05 02:23 PM


All times are GMT +1. The time now is 10:34 AM.

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"