Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search and replace
I have three things in three columns, A, B,c.
The first is a letternumber combination, i.e. a-1 a-1 a-1 b-1 b-1 b-1 The second is the object in question for a-1, so: test1, test2, test3 which is repeated for b-1. Some tests are positive, and designated by a 1 for + and a 0 for negative in column C. However, if there is a positive for any test, i need all of the test results to be displayed (the results are in column D). Right now, with some help, i can get excel to read the information and output all results that have a 1 on a second sheet. How could i get excel to see which results are positive and the output all results (the column D numbers) to a sheet. Maybe a vllokup of the values on column d that replaces the 0 in sheet one with a 1? thanks, Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace using wildcards | Excel Discussion (Misc queries) | |||
macro to search and replace with offset | Excel Discussion (Misc queries) | |||
search & replace | Excel Worksheet Functions | |||
search & replace | Excel Worksheet Functions | |||
search & replace | Excel Worksheet Functions |