IF statement in a given Time frame

[rockchalk33]

Hey all, need a little help with some VBA. I have an RFID reader that logs information scanned into excel and this information is logged under Column A. The reader has 4 independent tags (1, 2, 3, and 4). The reader scans an area for these tags every 6 hours. Tag 1 is constantly logged every time the reader begins logging. The rest of the tags may get read or may not.

I currently have a Do Until loop going to the last logged tag in Column A. What I need is a code to find the greatest numbered tag (4 being the greatest) logged within 10 seconds of the last logged tag in Column A. The reason for this, is that when the RFID reader begins logging it effectively sends a pulse and inputs the tags into Excel in no particular order. I am simply looking for the highest numbered tag logged from the last pulse.

Thanks,

Devin

 

[CharlesChuckieCharles]

check out the MAX or LARGE functions