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.