Summarize data within Spreadsheet

see if the attached will give you what you want? I created a small table to the right (you can move it if you want), with dates along the top and SN going down. you can extract unique SN's by copy/paste to the new column and then using Remove Duplicates (or I can give you a formula, but with 90000 rows, the arrays in that table may already slow things down)