| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting unique text/number cells from a range
Please consider a long range of text cells containing A, B, C, D.... and more. Lets say it goes from H1 to H1500 A -H1 A B F D A H D |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting unique text/number cells from a range
=SUMPRODUCT((H1:H1500<"")/COUNTIF(H1:H1500,H1:H1500&""))
-- HTH RP (remove nothere from the email address if mailing direct) "sudeepd12" wrote in message ... Please consider a long range of text cells containing A, B, C, D....Z and more. Lets say it goes from H1 to H1500 A -H1 A B F D A H D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting a number of cells with 2 range criteria | Excel Discussion (Misc queries) | |||
| Counting the number of unique values within a range | Excel Discussion (Misc queries) | |||
| Counting unique text/number cells from a range | Excel Discussion (Misc queries) | |||
| Counting unique text/number cells from a range | Excel Worksheet Functions | |||
| Formulas for...1. Counting unique cells 2. Display unique contents | Excel Programming | |||
Linear Mode
