Count dates without repetition

[KALATRASH81]

Good morning:
I have in column B list of dates, each one represent a lecture I did for the same topic, I need to know automatically in certain cell how many lecture (dates) without repetition.
please check the attachment

Thanks

[bebo021999]

May be:
=SUMPRODUCT(1/COUNTIF(Print_Area,Print_Area))

[KALATRASH81]

still did not work

[daddylonglegs]

I get 6 using bebo's suggested formula, isn't that the correct answer?

[elayaz]

Hello,

If you are looking for 4 as your answer, then take a look at the attached sheet

[KALATRASH81]

It will work for the whole sheet, I have more than one column, I need it for each column alone or 2 columns together
thanks

[elayaz]

Sorry, I couldn't get you. Is that attached sheet working for you..?
If yes, then similar approach of adding a helper column and count if will work for any number of columns.

Please post the sample file with more data..

[KALATRASH81]

It will work for the whole sheet, I have more than one column, I need it for each column alone or 2 columns together
thanks

[KALATRASH81]

please check the attachment Database 2, I hope its clear what I need.

[elayaz]

Hello,

Please see if the attached file helps.

[daddylonglegs]

You can use a revised version of bebo's suggestion which doesn't need helper columns, try this formula in B13 copied across

=SUMPRODUCT((B1:B12<>"")/COUNTIF(B1:B12,B1:B12&""))

[KALATRASH81]

Thanks a lot
SOLVED