D
Don
I have a worksheet listing batch shipment information by qty and date. There
are 12,000 rows. The same batch can/will be shipped on multiple dates, or the
same date.
Supporting worksheet
A B C
1 Batch Qty Date
2 1111 12 1-1
3 1111 10 1-1
4 3333 5 1-1
5 2222 10 1-5
6 1111 4 1-5
7 3333 13 1-8
8 2222 5 1-8
I can use VLOOKUP to return the First date each batch was shipped.
What can I use to return the Last date found in the worksheet for each batch
shipped?
Primary worksheet
A B C
1 Batch First Date Last Date
2 1111 1-1 ????
3 2222 1-5 ????
4 3333 1-1 ????
are 12,000 rows. The same batch can/will be shipped on multiple dates, or the
same date.
Supporting worksheet
A B C
1 Batch Qty Date
2 1111 12 1-1
3 1111 10 1-1
4 3333 5 1-1
5 2222 10 1-5
6 1111 4 1-5
7 3333 13 1-8
8 2222 5 1-8
I can use VLOOKUP to return the First date each batch was shipped.
What can I use to return the Last date found in the worksheet for each batch
shipped?
Primary worksheet
A B C
1 Batch First Date Last Date
2 1111 1-1 ????
3 2222 1-5 ????
4 3333 1-1 ????