Home |
Search |
Today's Posts |
#18
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce duplicates to 1 with a count of how many before
Hi Howard,
Am Sun, 23 Feb 2014 01:19:18 -0800 (PST) schrieb L. Howard: All my testing says BINGO! if you have same values in A with and without values in B macro Test_CB doesn't give you the expected result because the value from A is only once in the array. With Test_CB2 you get the expected result but you use another sheet. You can also copy the data from A:B to C:D and run RemoveDuplicates. Then the code must be changed slightly. If you want the output in the same sheet like Sheet1 in SkyDrive workbook have another look in SkyDrive an go to Sheet4 and run Test_CB4 Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count duplicates | Excel Programming | |||
Count Duplicates | Excel Discussion (Misc queries) | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
Reduce columns and rows count? | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions |