Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF Criteria | Excel Discussion (Misc queries) | |||
In Excel 2000, can I change the direction of the move selection a. | Excel Discussion (Misc queries) | |||
SELECTION() | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
formula that meets two criteria and sums? | Excel Discussion (Misc queries) |