finding all cells that match a certain value
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 wiadomosci
ups.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.
|