G
gcmontgomery30
I need to write a fomula that will give me the data in column C (quantity
received) after finding the most current date in column B (date received).
Example: if the product was Test, I would need to end up with the quantity
received of 25,00
PRODUCT DATE RCVD QTY. RCVD
TEST 01/24/08 10,000
HELP 12/18/07 40,000
HELP 02/12/08 3,000
TEST 02/12/08 25,000
Any assistance with this formula would be greatly appreciated. Thanks.
HELP 02/12/08 3,000
received) after finding the most current date in column B (date received).
Example: if the product was Test, I would need to end up with the quantity
received of 25,00
PRODUCT DATE RCVD QTY. RCVD
TEST 01/24/08 10,000
HELP 12/18/07 40,000
HELP 02/12/08 3,000
TEST 02/12/08 25,000
Any assistance with this formula would be greatly appreciated. Thanks.
HELP 02/12/08 3,000