Hello,
I have been trying to figure out a formula to see which materials are missing in the production for more than 1 day.
I have a 3 column report which I get sent every month - Start date, End date and Item Nr. (sheet1, columns A, B and C). I have formatted to short date columns A and B, but they do have time included as well.
In sheet2 I have created a Table :
Column A "Item Numbers" where I have removed all duplicates for Item Nr. from sheet 1
Column B - Date beginning 2021.01.01
I have been asked to try to create a report, where I can see how many unique days, an Item has been missing every month.
A missing item in production does not count as missing, if it is missing for one day (less than 24hrs).
In my previous attempt I created a column which had a number of days missing, but I could only manage to sum up the total amount of days per month. Could not find the formula to calculate unique days.
Ideally, in sheet2 cell B2 I would like to have 12 days.
Hope you can help, as I`m stuck for a couple days now
I have been trying to figure out a formula to see which materials are missing in the production for more than 1 day.
I have a 3 column report which I get sent every month - Start date, End date and Item Nr. (sheet1, columns A, B and C). I have formatted to short date columns A and B, but they do have time included as well.
In sheet2 I have created a Table :
Column A "Item Numbers" where I have removed all duplicates for Item Nr. from sheet 1
Column B - Date beginning 2021.01.01
I have been asked to try to create a report, where I can see how many unique days, an Item has been missing every month.
A missing item in production does not count as missing, if it is missing for one day (less than 24hrs).
In my previous attempt I created a column which had a number of days missing, but I could only manage to sum up the total amount of days per month. Could not find the formula to calculate unique days.
Ideally, in sheet2 cell B2 I would like to have 12 days.
Hope you can help, as I`m stuck for a couple days now