Hi there,

I've got a spreadsheet that has numbers in on particular row (row 21) from E21 to BD21. What I want to do is write something which will START at BD21, check to see if the value is 0, if it is, move left (BC21) and so on until it finds a value which is not zero (ie 100). If a non-zero value is found, then take this value and put it in cell BG21.

Can someone help please?

- John