On Jul 26, 2:39 pm, "tomek gomek" wrote:
A2:A8 = names
B2:B* = values
C2 =IF(B2=$D$1;A2;"") and copy down

in cell D1 write number which you want

is this what you want?

tomek

Uzytkownik "OTS" napisal w wiadomoscinews:1185427519.335146.98570@r34g2000hsd .googlegroups.com...



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.- Hide quoted text -

- Show quoted text -

hi thanks for the reply. it's not exactly what i need. you see, my
list of names goes on for very long. what i'd like is to choose a
number, then have all the corresponding names appear by themselves. so
if the first relevant name is in A3, then the next relevant name is in
A450, when i choose their number, A3 will appear in say C1, then A450
in C2, the next relevant one in C3 and so on.