Dear Experts,
Is there any formula to count excel text & number except repeating? for example-
Column A
Karim
Rahim
Azad
Reaz
Rahim
Rahat
Azad
Here count value is 7 (counta(A1:A7) but I want to count 5 because "Azad & Rahim" is repeated. Pls help me if you know which formula count it except repeat cell value.
Advance thank you
Emran
Hi,
=SUMPRODUCT(1/COUNTIF(A1:A7,A1:A7))
Regards
hi Emran. try:
=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))
do change your profile for your MS Off Version if you have upgraded. helps us give you newer & more efficient formulas
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
if your data is in A2:A8 (first row with header) use:
=SUMPRODUCT(1/COUNTIF(A2:A8,A2:A8))
PS. where sdfds is :-P
A simple way is this. In B1 and copy down,use this.
Formula:
=COUNTIF($A$1:A1,A1)
Hide this column.
Then use this.
Formula:=COUNTIF(B1:B7,1)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks