Hi,
I've been searching for hours trying to find a solution to my problem even though it seems fairly simple. I apologise if it is and I'm being dumb!
I would like to count the amount of unique values (order numbers) in a table that correlates with a specific date. For example, how many unique orders were made on 07/06/20. Each order may have multiple lines so a simple COUNT function wouldn't work. I have attached an example set of data. I have found lots of tutorials with SUMPRODUCT and 1/COUNTIF, which works apart from it gives a #DIV/0! error when you expand the range beyond the data. As this is an order list, I am adding tens of lines of data everyday and would like the formula to have a range of A2:A5000 or higher so it automatically updates whenever I add new orders to the main list.
I have a seperate sheet with all of the dates in column A and would like the number of unique order numbers in column B. Help please!
Bookmarks