If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|