Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Duplicates in text values
I have 19 digit text values in column A from A2 to A501.
Col A Col B 8991151420000560945 1 8991151420000560721 1 8991151420000560770 1 8991151420000560770 2 8991151420000560861 1 8991151420000560929 1 8991151420000561125 1 and so on. I need to count duplicate text for each cell to be desplayed in adjecent cell (Col B). Need help with the formula as countif is not working in this situation. Regards, Madiya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
How can I count up values in a list that includes duplicates? | Excel Discussion (Misc queries) | |||
Count Unique Values In A Filtered Row with Duplicates | Excel Discussion (Misc queries) | |||
Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |