Got a spreadsheet its maxed for data.
I need to filter based on date, but once I have the date I then need the unique num of ID's on that date.
Manually I can auto filter, then do an advanced filter unique only copy and then count... but there must be an easier way as I would prefer just vchanging the date in the manual filter and see the numbers.
thanks!
I need to filter based on date, but once I have the date I then need the unique num of ID's on that date.
Manually I can auto filter, then do an advanced filter unique only copy and then count... but there must be an easier way as I would prefer just vchanging the date in the manual filter and see the numbers.
thanks!