Excel help: Advanced Find & Replace

[Inconsequential]

Delete please!

 

[Gregg2]

How do I get excel to find each incorrect line (regardless of the row number after the X) to the correct formula along with the correct row number?

That sentence structure is confusing. Are you using copy and paste to put the formula in several cells, but it's changing the X2 to X3, X4, etc.? 'Cause that's what it does when I do that.

 

[Inconsequential]

That sentence structure is confusing. Are you using copy and paste to put the formula in several cells, but it's changing the X2 to X3, X4, etc.? 'Cause that's what it does when I do that.

Sorry, i've done it manually, so it doesn't matter anymore lol

 

[Gregg2]

Yeah, it it's what I described, that's what I do also.