| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting text entries
I have a list of text entries. I would like to pick up only entries which are
represented more than once and have a count of them also. How do I do this? Kindly help. Thank you very much. -- SreeCha |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting text entries
In a helper column:
=COUNTIF(A:A,A1) Copy down as needed. Then autofilter for all values greater than 1. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "SreeCha" wrote: I have a list of text entries. I would like to pick up only entries which are represented more than once and have a count of them also. How do I do this? Kindly help. Thank you very much. -- SreeCha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting entries | Excel Worksheet Functions | |||
| Counting number of row entries | Excel Discussion (Misc queries) | |||
| Counting unique text entries in a filtered list... | Excel Worksheet Functions | |||
| Counting Unique text entries in a sheet with a condition | Excel Worksheet Functions | |||
| Counting Entries | Excel Worksheet Functions | |||
Linear Mode
