Excel Magic Trick 942: Lookup Last Shipment Date For Customer, Sorted & Not Sorted Date Column
66.2 هزار بار بازدید -
12 سال پیش
-
Download Excel Start File:
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download workbook: http://people.highline.edu/mgirvin/Ex...
Lookup Last Shipment Date For Customer:
1. Sorted Date Column using LOOKUP function and array operation
2. Not Sorted Date Column using LOOKUP function and complex array operation with two criteria: "Product Match" and "Last Date"
"When we enter product, then I should give the last shipment rate and the last shipment date."
Download workbook: http://people.highline.edu/mgirvin/Ex...
Lookup Last Shipment Date For Customer:
1. Sorted Date Column using LOOKUP function and array operation
2. Not Sorted Date Column using LOOKUP function and complex array operation with two criteria: "Product Match" and "Last Date"
"When we enter product, then I should give the last shipment rate and the last shipment date."
12 سال پیش
در تاریخ 1391/04/16 منتشر شده
است.
66,218
بـار بازدید شده