Hi,
A have a list with different clients with their orders effective date and the items they purchased. Each client is in the file at least 2-3 times.
Column A = client ID
Column B = order effective date
Column C = item
Based on this data, I need to have in another sheet unique client IDs, each with their second to last order.
What formula can help with this task?
Thank you for your help.
Regards.
A have a list with different clients with their orders effective date and the items they purchased. Each client is in the file at least 2-3 times.
Column A = client ID
Column B = order effective date
Column C = item
Based on this data, I need to have in another sheet unique client IDs, each with their second to last order.
What formula can help with this task?
Thank you for your help.
Regards.