| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a different find and replace?
I am working on a VERY LONG spreadsheet. The only problem is when i populate
data (living document), it is all done manually. Is there a way to Find something in column A if TRUE type "x" in column G. Much like find and replace but not for ONE cell at a time. I need to look for varialble in column 'A' and if it matches input goes in column G. thanks for any help. I am starting to think Excel can't do this. Thanks again. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a different find and replace?
Maybe something like this.
In column G, say G1: =IF(A1="variable","x","") Copy down as far as needed. If this is not what you need, then please elaborate on your data and the desired results. Regards, Paul -- "Tom" wrote in message ... I am working on a VERY LONG spreadsheet. The only problem is when i populate data (living document), it is all done manually. Is there a way to Find something in column A if TRUE type "x" in column G. Much like find and replace but not for ONE cell at a time. I need to look for varialble in column 'A' and if it matches input goes in column G. thanks for any help. I am starting to think Excel can't do this. Thanks again. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a different find and replace?
in G1:
=If(a1=true,"x","") Replace true with your test Is this what you want? "Tom" wrote: I am working on a VERY LONG spreadsheet. The only problem is when i populate data (living document), it is all done manually. Is there a way to Find something in column A if TRUE type "x" in column G. Much like find and replace but not for ONE cell at a time. I need to look for varialble in column 'A' and if it matches input goes in column G. thanks for any help. I am starting to think Excel can't do this. Thanks again. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Find and Replace/Look up | Excel Discussion (Misc queries) | |||
| Find and replace all | Excel Discussion (Misc queries) | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Linear Mode
