i have sheet with many rows... and in other sheet i need to have list of all rows from data, which has one column the same...
data is like this:
name alphanumeric code town street ...
Adam sjdf30393 London Green st ...
Adam sjdf30365 Oxford Great st.
Ian asdf1201 Ascot Race st...
Dan dfasdf2010 Redding Ring st
Ian asdf1200 Ascot Bridge st
Result should have one cell where you have drop down menu with names and then under it should be list of all rows which contain name from that cell
ex. Adam
all data:
Adam sjdf30393 London Green st ...
Adam sjdf30365 Oxford Great st.
I dont know how to make it search and list all relevant rows, when there are not numeric data.
Thank you.
Bookmarks