Counting unique text/number cells from a range

  • Thread starter Thread starter sudeepd12
  • Start date Start date
S

sudeepd12

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
 
=SUMPRODUCT((H1:H1500<>"")/COUNTIF(H1:H1500,H1:H1500&""))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting unique text/number cells from a range 3
Named Range maker code 9
simple code but it doesn't look like usual vba code 2
Macro storing as a date? 11
Modify working code to expand the output. 5
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Array with many cells from a row but not in order or together 11
Multi format conditional formating 2

Back
Top