I want, if A2=0 then Goto next cell and again check and so on even value 0>1 if value 0>1 then type the value cell.

[+923428055502]

Below is data i want to do that if cell B2<0 then skip cell and goto B3<0 again skip even value >0 if value >0 then cell B1= this cell refernce

Data	1​	2​	3​	4​	5​	6​	7​	8​	9​	10​
	0	0	0	0	1	0	0	2	0	0

 

[vletm]

+923428055502
Please, reread Forum Rules from

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

especially How to get the Best Results at Chandoo.org