LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Disappears When Closed Shawn Excel Worksheet Functions 2 September 25th 08 03:37 PM
data label disappears when I move it Tamara Charts and Charting in Excel 0 September 5th 08 12:14 AM
Data disappears!! Holey Excel Discussion (Misc queries) 5 February 27th 08 03:52 PM
F2 error: New data disappears when hit enter Will123 Excel Worksheet Functions 1 December 1st 06 03:19 PM
cell shows all the data, click out of it, end of data disappears LINDA Excel Discussion (Misc queries) 1 September 13th 06 04:28 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"