Hello,
First time poster. I am using EXECL 2007 and have one column for event description (some are duplicated, some are blank) and another column for start date. I am building an event summary at the top of the worksheet and would like to count the unique events & blanks in the event column prior to Today's date. I have tried several differnt iterations of IF, COUNT(A),COUNT(IF), and SUMPRODUCT, but I can't seem to put it all together for one solution.
Thanks.
Bookmarks