Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Sort Unique Problem
I am having problems with a recorded macro:
Raw Data on Sheet 1: C 3 424a356 4 424a356 5 424a356 6 424b650 7 424b650 8 401b000 9 401b000 10 407b000 Copy and Sorted by Unique Value on Sheet 2: A 2 424a356 3 424a356 4 424b650 5 401b100 6 407b000 Even though I request unique values, it continues to copy the top two values which are the same. It has something to do with a header, maybe? Is there some code that could get me around this problem? Your help is greatly appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Sort Unique | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
how do I find and sort unique values from a column | Excel Worksheet Functions | |||
How to Sort by Count the Max nos of Unique text values in Pivot Ta | Excel Discussion (Misc queries) | |||
How do I sort a column a unique number? | Excel Worksheet Functions |