|
Return Rows whose cell satisy a condition from other Work Sheet
Guys,
I need help in resolving this.
I have a work sheet which is as follows:
Name Location Value
ABCD abcd1234 0
DEFG abdc1243 1
GHIJ abcd1324 1
In another Worksheet, I just want to display the rows which have the value cell to be "1" alone.
No human intervention of filtering needs to be done in teh whole process.
Would appreciate any suggestions either in a Formula or any other means
ANTRIX
Last edited by antrix; 07-04-2009 at 04:37 PM.
|