Hi Teethless,
Thanks for yourr support bu the below formula count the letter B with date
00.00.0000.....I dont know why.

"Teethless mama" wrote:

Assuming Column F contain real Excel dates

=SUM(N(FREQUENCY(IF((rngJ="B")*(rngF0),MATCH(rngD &"",rngD&"",)),MATCH(rngD&"",rngD&"",))0))

ctrl+shift+enter, not just enter


"Mero" wrote:

Hello...I did ask the below question 3 days ago and I got answer from you.
Now I need to add something to my below question

In the below formula you gave me, we count letter B based on unique value
among duplicates in column D.
Now, I added another column F which contains dates.
I need to count letter B based on unique value in column D and that has no
date like 00.00.0000 in column F.
Please See below 3 columns, the result should be only 1 B

Hope I've explained my problem
I dont know how to thank you for this support
Awaiting your fast feedback
Mero

"Teethless mama" wrote:

=SUM(N(FREQUENCY(IF(rngJ="B",MATCH(rngD&"",rngD&"" ,)),MATCH(rngD&"",rngD&"",))0))

ctrl+shift+enter, not just enter


"Mero" wrote:

Hello, Need to know how to count the letter "B" in column J based on unique
values among duplicates in another column.

Column D Column J Column F
5020598285 A
5020598286 A
5020598287 A
5020598288 A
5020598563 A
8020249197 C
8020249198 C
8020249409 B 00.00.0000
8020249409 B 00.00.0000
8020249450 B 13.01.2009
8020249450 B 13.01.2009
5020598429 A
5020598707 A

If you have a look at records in column D, you will find that some records
are duplicated. If I count letter "B", I will get 4 but actually they are
only 2 records for letter "B" as 8020249409 and 8020249409 are duplicated.
I need a function to count letter "B" without duplication.

Hope I've explained my problem.
Your fast support is really appreciated.

Many Thanks
Mero