Satya,

Autofilter will only show you the first 1000 unique records in your
list. To find the job # over 1000, click on the arrow, select Custom
and your criteria would be equals and the job number over 1000 you are
looking for. That will display only that item in the list.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=490691