Forum Discussion
Re: I could use help trying to replace data in the same cell.
I don't even know if I understand what "this" is. You have in the example
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
But I assumed that was indicative of many different individuals with different last names, first name and job titles and that on sheet2 was the same thing that there is a list of each name and replacement value. but now I don't know, is it the same name repeated?
As for the 670+ cells, fine, you have a formula that does what you need and you put those 670+ in cells A1:A670 and the formula in B1:B670 (or use dynamic arrays to apply the 1 formula to the whole set)
but like I said, it is hard to help if I don't understand what you need.
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
But I assumed that was indicative of many different individuals with different last names, first name and job titles and that on sheet2 was the same thing that there is a list of each name and replacement value. but now I don't know, is it the same name repeated?
As for the 670+ cells, fine, you have a formula that does what you need and you put those 670+ in cells A1:A670 and the formula in B1:B670 (or use dynamic arrays to apply the 1 formula to the whole set)
but like I said, it is hard to help if I don't understand what you need.
No RepliesBe the first to reply