Find & replace a value in an unknown cell location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You have replies at your thread in .excel.
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace a cell value of unknown location 6
Conditional SUBTOTAL in XL210 Table 7
Getting Text data using the Data - Subtotal feature 1
description of count in subtotal 1
Subtotals every "X" number of rows 3
Calculate visible cells only? 3
Multiple formulas in subtotal 2
Subtotals - show all columns? 2

Back
Top