LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 634
Default All data disappears when using autofilter

Of course if you read the rest of the replies you will realise that he does
not actually have the data he thinks he has, so no wildcard is going to help
as it cannot find what is not actually there to begin with, so hence the use
of the TEXT function to actually give him what he already thought he had,
after which any of his normal filtering methods should now work.


"basilio" wrote in message
...
to me wild cards worked perfectly
just enter your data as text and then <in filter try :
" equals " ?0*

hole will help

--
Basilio



 
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:45 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"