Gord - Thanks for the link

You can have many thousands of entries in the column but you just
won't get more
than 1000 to show in the drop-down list.

That's what I meant when I said "no more than 1000 different entries." I
guess it wasn't clear. Oh, well.

- David

Gord Dibben wrote:
David

There is not a 1000 entry limit to a column of data to autofilter.

You can have many thousands of entries in the column but you just won't get more
than 1000 to show in the drop-down list.

See Debra Dalgleish's site for workarounds to the 1000 entry drop-down limit.

http://www.contextures.on.ca/xlautofilter02.html#Limits


Gord Dibben MS Excel MVP

On Mon, 30 Jul 2007 02:41:32 GMT, David Hilberg wrote:

If you have no more than 1000 different entries in your remarks column,
you can use autofilter. Would that be sufficient to your purposes?

- David

OTS wrote:
ok i have some data arranged as such, the first column is filled with
names and the column next to it is a remarks column, filled with say,
numbers from 1-10. what i want is to have a third column, whereby
let's say i choose the number 8, all the names with a number 8 next to
them will appear in the third column. can anyone help?

thanks.