Friends,
Need help here urgently, I have a data values in two seperate sheet showing IN and OUTt date, time and sku's.
Issue is there are multiple IN and OUT time, date for a single sku.
I have tried several vlook up array formulas but unable to get through what is required.
I want a formula which will capture ococcurence of each repeating sku against its IN and OUT date and time, as i have to find out which sku is still "IN".
Attached sample data, help required asap.
Warm Regards,
Kashyap Rodge
Bookmarks