What about with vba. Autofilter doesn't automatically change the values. If I
have over 500 values then that solution won't work.

"Barb Reinhardt" wrote:

Without VBA, I'd probably do this with autofilter. Select the value for B
that you want and the value for C that you want and change as needed.


"NOOBY92" wrote:

Hi, I know that using find (ctrl+f) you can choose a certain value in a cell
and replace it. I was wondering if you could do this for 2 or more cells. For
example, can you tell excel to search for all instances in which a cell in
collumn B has a certain value (for example x) and the cell to the right of it
has another certain value (for example y) so that every time a cell in
collumn B has a value of x and the cell to the right of it (in collumn c) has
a value of Y, excel will replace Y with another value (for example z).