Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & replace a value in an unknown cell location
Is there a function I can use to find a text string in a particular column -
say in column (H) for string 'Mytotal' to be replaced by 'Subtotal' when the cell location of 'Mytotal' is unknown only the column is known? And also is there a function that can find a certain value in a column then delete the row below the found value? e.g in column (H) find 'Subtotal' then delete the row below the occurance of 'Subtotal'. Help is much appreciated with this one? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & replace a value in an unknown cell location
You can use MATCH to find where "Mytotal" is located, assuming you know
either the row or the column. I think you'll need VBA to do what you want however. "mellowe" wrote in message ... Is there a function I can use to find a text string in a particular column - say in column (H) for string 'Mytotal' to be replaced by 'Subtotal' when the cell location of 'Mytotal' is unknown only the column is known? And also is there a function that can find a certain value in a column then delete the row below the found value? e.g in column (H) find 'Subtotal' then delete the row below the occurance of 'Subtotal'. Help is much appreciated with this one? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & replace a value in an unknown cell location
You have replies at your thread in .excel.
mellowe wrote: Is there a function I can use to find a text string in a particular column - say in column (H) for string 'Mytotal' to be replaced by 'Subtotal' when the cell location of 'Mytotal' is unknown only the column is known? And also is there a function that can find a certain value in a column then delete the row below the found value? e.g in column (H) find 'Subtotal' then delete the row below the occurance of 'Subtotal'. Help is much appreciated with this one? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace does not work in a linked cell | Excel Discussion (Misc queries) | |||
Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
find replace ??* | Excel Worksheet Functions |