I have been tasked with organising data by my boss.
I am not 100% sure on how I will achieve it using excel, if someone can point me to what function I should be using. That would be great.
I have 5 sites and each site has varied number of products coming in on different dates beginning of May. I have the dates of arrival, the product ID and which site.
I have been tasked to use Excel to make it so my boss is able to go into the sheet and filter by dates/month, site, product ID and see on a calendar.
Not sure what I should use.