Hi
From the set of data below:
Name Dept Age
Henry 501 28
Stan 201 19
Mary 101 22
Larry 301 29
Lynn 201 22
Harry 401 21
Joe 101 23
Lynn 301 30
I am looking to search for "Lynn" in the first column and return the entire row.
The ideal outcome would be:
Name Dept Age
Lynn 201 22
Lynn 301 30
On a separate worksheet
Any help would be appreciated
thanks
Bookmarks