Hi all,
Needing to have a formula that will automatically insert the 2nd last date occurrence.
Based on a table with column A being the Failed Delivery date, column B listing the relevant store code and column C being the column pulling the 2nd last date for when store last failed delivery was.
But not savy and after 2 days of searching and trying I cannot make it work at all.
Would really appreciate help.
Many thanks
Needing to have a formula that will automatically insert the 2nd last date occurrence.
Based on a table with column A being the Failed Delivery date, column B listing the relevant store code and column C being the column pulling the 2nd last date for when store last failed delivery was.
But not savy and after 2 days of searching and trying I cannot make it work at all.
Would really appreciate help.
Many thanks