How can I sort out data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carmen - 20 Apr 2007 13:50 GMT

I have done an auto filter. Then, I cannot find some information in the drop
down box, although it is there. The info. has been sorted out AtoZ. But the
box only shows the information starting with A and B. However, I have input
many words starting with other letters. And some of the words have
disappeared. How can I fix that, please?.

Thanks a lot.

Reply to this Message

Dave Peterson - 20 Apr 2007 14:10 GMT

And you're sure you applied the data|Filter|autofilter to all the rows in your
range?

If you're sure, then maybe this is the problem:
http://contextures.com/xlautofilter02.html#Limits
(from Debra Dalgleish's site)

She includes some work-arounds, too.

> I have done an auto filter. Then, I cannot find some information in the drop
> down box, although it is there. The info. has been sorted out AtoZ. But the
[quoted text clipped - 3 lines]
>
> Thanks a lot.

Signature

Dave Peterson

Reply to this Message

carmen - 20 Apr 2007 16:10 GMT

Thank you very much for your help, Dave.

> And you're sure you applied the data|Filter|autofilter to all the rows in your
> range?
[quoted text clipped - 12 lines]
> >
> > Thanks a lot.

Reply to this Message