View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
apandbp apandbp is offline
external usenet poster
 
Posts: 1
Default All data disappears when using autofilter


This one has me truly beat. I have a long list of numbers, and I need
to filter the ones out that have a zero as the second digit from the
left. I have been using auto filtercustom and tried using wild cards,
and have had no success. I have included some sample data below. You
can also find a copy of the actual xls sheet at
www.ideaharvesters.com/testxls.xls

Account
00616946
03745254
03745254
10043826
13635685
20071601
20560611
20560611
20560611
23474810
30437875


--
apandbp
------------------------------------------------------------------------
apandbp's Profile: http://www.thecodecage.com/forumz/member.php?userid=550
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=118775