| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting repeated data in a column
I have an excel document that has column A2-A6140 that list data that 3509
items are duplicated. What I am looking for is a formula that can tell me how many times an item is repeated. For example AIMAS1D AIMAS1D AIMAS2D AIMAS3D AIMAS3U AIMAS4D AIMAS4U AINAS1R AOLDB1P1 AOLDB3P1 AOLDB3P1 In Column B I need to list how many items appear twice, in column C three times, etc. Any formula, VBA, or macro would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove duplicated data repeated in a column and keep just o | Excel Worksheet Functions | |||
| Counting repeated occurances | Excel Worksheet Functions | |||
| How can i stop same data being repeated in a column | Excel Discussion (Misc queries) | |||
| How can i stop data being repeated within a column? | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
