Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 14th 05, 06:54 AM
Graham Haughs
 
Posts: n/a
Default Wildcard Selection Criteria

I have a database in excel where one of the fields is a "Comments"
section where there are text strings. When this particular record has
been dealt with an asterix * is put in front of the comments string.
What I want to do is select out those records which have no asterix in
front of the comments. I can sort the database by the comments field in
descending order and they all finish up at the bottom but what I would
ideally like to do is filter them out but so far I cannot seem to be
able to set up the selection criteria which would work. This basically
would be to select all these records where the comments does not begin
with *. Any suggestions very welcome.


Kind Regards
Graham Haughs
Turriff, Scotland

  #3   Report Post  
Old January 14th 05, 07:49 AM
Graham Haughs
 
Posts: n/a
Default

Thanks Nick, that works perfectly on my data. I have no idae how you
arrived at that but the important thing is it works.

Thanks
Graham


Nick Hodge wrote:
Graham

Only tried this on very limited data but in autofiltercustom enter

'Does not begin with' ~*

Reply
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
SUMIF Criteria Brent Martin Excel Discussion (Misc queries) 6 January 7th 05 05:17 AM
In Excel 2000, can I change the direction of the move selection a. GTP Excel Discussion (Misc queries) 2 January 7th 05 01:20 AM
SELECTION() Thrava Excel Discussion (Misc queries) 2 January 2nd 05 01:33 AM
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 10:12 PM
formula that meets two criteria and sums? C Cooper Midland Excel Discussion (Misc queries) 2 December 14th 04 02:49 PM


All times are GMT +1. The time now is 02:34 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017