Hey gang,
OK, so, like, here's the thing... I need a function or set of nested functions that will allow me to know what the highest odometer reading is for a particualr vehicle.
I have a list of invoices. One VIN may have been serviced two, three, four, five times. I need to be able to enter a VIN and have a formula look through the list, find the highest odometer reading for that VIN, whether the VIN shows up once, twice, three or N times.
An example...
abcde12345F6789101 8,000
SomeOtherVINs x
abcde12345F6789101 16,000
SomeOtherVINs, x
abcde12345F6789101 24,000
So, if I entered abcde12345F6789101 in some cell, the formula(s) in the column to the right should return 24,000 until another invoice with that VIN is entered, then the formula would show whatever is the highest kms.
Can this be done? Thanks much for any help provided.
Thanks for any help you can provide.
OK, so, like, here's the thing... I need a function or set of nested functions that will allow me to know what the highest odometer reading is for a particualr vehicle.
I have a list of invoices. One VIN may have been serviced two, three, four, five times. I need to be able to enter a VIN and have a formula look through the list, find the highest odometer reading for that VIN, whether the VIN shows up once, twice, three or N times.
An example...
abcde12345F6789101 8,000
SomeOtherVINs x
abcde12345F6789101 16,000
SomeOtherVINs, x
abcde12345F6789101 24,000
So, if I entered abcde12345F6789101 in some cell, the formula(s) in the column to the right should return 24,000 until another invoice with that VIN is entered, then the formula would show whatever is the highest kms.
Can this be done? Thanks much for any help provided.
Thanks for any help you can provide.