| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about count ONLY different Texts in a range.
I want a formula that can count only text that are different but only one of similar texts, example: -nsk are 2 but the formula must count 1, -nsb is 1 then the formula must count 1, -nst is 3 the formula must count 1, -nst-5222 is 1 the formula must count 1 a total of 4. Count = 4 A-X00-1XR-NSK A-X00-1XR-NSK A-X00-1XR-NSB A-X00-1XR-NST A-X00-1XR-NST A-X00-1XR-NST A-X00-1XR-NST-5222 also, if I use filter ommiting -5222 then the result must be 3 please help, and thanks in advanced. -- Lorenzo DÃ*az Cad Technician |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count how many times different texts repeat in a column? | New Users to Excel | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Concatenation 2 Texts | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Threaded Mode
