| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Sort Unique
I have a list of item numbers in column C on Sheet 1. There are multiple
item numbers that are the same. In fact, the first two and sometimes more are the exact same item number. My Summary Sheet (Sheet 2) is used to calculate a quantity using a SUMIF statement dependent on the item number. Well, I tried using a macro to copy and sort the unique values from column C on sheet 1 to my Summary Sheet, but it continues to copy the top two values which are the exact same. When this happens, it is messing up my summary sheet. What is the best way to fix this? I appreciate your help. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| copy only unique values | Excel Worksheet Functions | |||
| How do I sort a column a unique number? | Excel Worksheet Functions | |||
Threaded Mode
