Home |
Search |
Today's Posts |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce duplicates to 1 with a count of how many before
On Saturday, February 22, 2014 7:52:14 AM UTC-8, Claus Busch wrote:
Hi Howard, Am Sat, 22 Feb 2014 07:44:14 -0800 (PST) schrieb L. Howard: This would be great for a sheet 2 result, really it is the same as a sheet 1 isn't it? the result is the same as in sheet1. Please have a look: https://skydrive.live.com/#cid=9378A...121822A3%21326 for "UniqueValues" There are 3 macros. The two you know and another one to keep all values from A if in B is text. Regards Claus B. -- Hi Claus, I do believe I got it figured out. Test_CB2 doesn't like Option Base 1 All seems to be working fine now. Not sure if Test_CB3 is needed, but I will indeed hang on to it. Thanks Claus, your magic wand works once again. Nice indeed. Regards, Howard |
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 |