Max Alejandro Molina
Member
Hello excel Ninjas,
I want to be able to drag down the array formula and get the biggest date (if dates next to each other are the same I want excel to get the one to the very right side) from the biggest purchase order number related with distribution center and item info from the columns: A and B, I have included an example I did manuallyof what i want this to end up looking like.
Thank you all so much!
I want to be able to drag down the array formula and get the biggest date (if dates next to each other are the same I want excel to get the one to the very right side) from the biggest purchase order number related with distribution center and item info from the columns: A and B, I have included an example I did manuallyof what i want this to end up looking like.
Thank you all so much!