Since the request to "know almost instantly" is almost 12 hours old, I
suspect the need is past. However, if that is not true, check out the
MAX function.
--
Regards,
Tushar Mehta www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions