P
PCOR
I have a large spreedshett(800 lines)
I clikced on DATA>FILTER>AUTO FILTER
and the arrows shopwed up on the various col.
One of these Col is called DATE
I click in the DATE arrow and select BLANK to find all the entries that do
not have a date showing.
This works well until about line 701
The line numbers to the left all turn blue and all is well
BUT in the following lines that the col displays dates and the numbers on
the left have not changed color
I thought that once the filter was set to BLANK only the lines that are
blank under DATE would appears. This is not the case
Can any one help
Thanks
Ian
I clikced on DATA>FILTER>AUTO FILTER
and the arrows shopwed up on the various col.
One of these Col is called DATE
I click in the DATE arrow and select BLANK to find all the entries that do
not have a date showing.
This works well until about line 701
The line numbers to the left all turn blue and all is well
BUT in the following lines that the col displays dates and the numbers on
the left have not changed color
I thought that once the filter was set to BLANK only the lines that are
blank under DATE would appears. This is not the case
Can any one help
Thanks
Ian