I am struggling to work out how to do the above.
Basically, if a cell in column G (Service downtime) in the attached, contains a 0, I need to change the text to read N/A. And if it contains a 1, I need to change it to a 1.
The amount of rows that this occurs in is dynamic also.
Could someone who is more proficient, provide me with an example please?
IN PROGRESS - Test.xlsx (9.3 KB)