The reference to A9 because the sheet is laid out as follows:
From our buisness system I have puilled service history by unit and then sorted it by unit number. Within that data there are about 50 unit numbers that may have 10 work orders against each one. So, using conditional formatting, I have all of the duplicate data hidden (make, model, s/n) with the exception of the first record. Each individual service work order is displayed though so everything appears grouped by unit number. From the service data, I need to calculate the usage based on highest and lowest meter readings on each unit and show it with the general data as usage. For this reason, I have to first identify all of the readings against an individual unit, check to find the lowest number and if it is zero, then find the second lowest number. If it were one unit the previous formula would work, but because there is multiple criterion, i am fumbling with this formula.
I tried to include a copy of the sheet hoping that seeing it will make more sense but I am having trouble getting the sheet into my post. I think I am just struggling with everything today!
Hopefully this makes some sense and I look forward to ANY help!!!