Thread: How do I do count calculations ignoring duplicate values
View Single Post
  #1   Report Post  
Robin Faulkner
 
Posts: n/a
Default How do I do count calculations ignoring duplicate values
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.
Reply With QuoteReply With Quote