Hi,,
I need to count a date in a cell, but I just want to count it as a one if there is a same date in a cell.
Is there any formula to fix it.
Thanks,
I already attachh the example.
Hi,,
I need to count a date in a cell, but I just want to count it as a one if there is a same date in a cell.
Is there any formula to fix it.
Thanks,
I already attachh the example.
May be:
![]()
=SUMPRODUCT(--1/COUNTIF(A3:A24,A3:A24))
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks