Hi,
I have a table on which I want to apply a formula that changes values but I want some of them to change while those unaffected by the formula remains the same as I don't want "FALSE" or empty space to replace the previous data of the cell.
More precisely looking at the table below we have
Column A Column B
Bugatti Vehicle
Bugatti Vehicle
Bugatti Vehicle
Kawasaki Bike
Kawasaki Bike
Bugatti Vehicle
Now I want all the "Vehicle" to change to "car" in column B for every "Bugatti" in column A. But I don't want the "Bike" to be changed to "False" or empty space.
(Consider the table very big where you can't just separately select all cells including "Bike" as it would consume hours/days)
Bookmarks