I have a file with several tabs. On my "Dashboard" tab, I have a listing of assets with a unique identifier in column A. In column C, I want to put a formula that will go to the "Hour Meter Reading" tab, look at the array (where there are multiple listings of each asset number for each time the meter was checked on the part). I want it to look in the array (column A is the asset ID, and column K is the date and L is the time), and pull out the most recent date/time <K and L> for that asset, which, again, is listed multiple times, as it has multiple meter readings.
Help?
Help?