| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce duplicates to 1 with a count of how many before
Hi Howard,
Am Sat, 22 Feb 2014 06:47:12 -0800 (PST) schrieb L. Howard: P-1 P-2 P-3 x P-5 P-6 P-7 x P-8 P-9 P-10 x P-1 P-2 P-3 x P-5 P-6 P-7 x P-8 P-9 P-10 x in your first posting you wrote you want to keep the values in A if B has text. How about your example? Do you want to keep P3 or P7 two times? Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| 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 | |||
Hybrid Mode
