baggins22
12-16-2008, 05:21 PM
I have a large data set, about 15 columns and 500 rows.
I have seen this done before, just dont know how.
its a little hard to exlpain (see example below), but bassicly i would like to create a new worksheet, and have the same 15 coumn titles and i would like to be able to type in creitra in column, push a button, and have the search/retrive all the Rows of the mactching column value.
Ex.
Data Set:
----A---- B----- C
1 --Jeff-- 94---- X
2 --Mike -94---- Z
3 --Fred -34 ----Z
4 --Dan --23 ----Z
5 --Alex --33 ----Z
6 --Frank -66 ----Z
New Worksheet
--A--- B---- C
1
2
So if i where to type "94" in column B, it would return BOTH Jeff and Mikes entire rows (a-c)...or if i were to type "Z" in column C, it would return all the values except row 1
Thanks!!
I have seen this done before, just dont know how.
its a little hard to exlpain (see example below), but bassicly i would like to create a new worksheet, and have the same 15 coumn titles and i would like to be able to type in creitra in column, push a button, and have the search/retrive all the Rows of the mactching column value.
Ex.
Data Set:
----A---- B----- C
1 --Jeff-- 94---- X
2 --Mike -94---- Z
3 --Fred -34 ----Z
4 --Dan --23 ----Z
5 --Alex --33 ----Z
6 --Frank -66 ----Z
New Worksheet
--A--- B---- C
1
2
So if i where to type "94" in column B, it would return BOTH Jeff and Mikes entire rows (a-c)...or if i were to type "Z" in column C, it would return all the values except row 1
Thanks!!