Hi Experts
I have excel data in column *B*. In some cells there is data *#N/A*
--> I want to Replace *#N/A* , with data in *next cell.*
--> If *#N/A* is in more than 1 cells (continuous) , then Replace them
with *next
valid data*.
--> If there is no Valid data in any next cell, then Replace them
Hi Experts
I have excel data in column *B*. In some cells there is data *#N/A*
--> I want to Replace *#N/A* , with data in *next cell.*
--> If *#N/A* is in more than 1 cells (continuous) , then Replace them
with *next
valid data*.
--> If there is no Valid data in any next cell, then Replace them