I have a calculation which is roughly "=count(if(A1:A100=F5,B1:B100)" where
F5 is a set value, column A is a list of values and column B is a list of
dates. I need the calculation to count the number of dates, but if the date
is duplicated I need the calculation to recognise its value only once.
Bookmarks