Search data and return latest status based on date & time
Hi There,
I am trying to wrote an expression/formula to return whether a part is in the cabinet or not. My spreadsheet has 3 columns, 1 containing a part number, 1 stating whether it is in or out of the cabinet and the last one . However, the same part can be booked in and out more then one time. Is there a way I can tweak the vlookup function to look for the part number and return the latest occurrence of the part status?