Search row from right to left for first non-zero value

**johnnyk** · 03-07-2007, 11:56 PM

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

**Paul** · 03-08-2007, 12:50 AM

John, this should work for you:

Please Login or Register  to view this content.

This will return the right-most non-zero value in the range E21:BD21. If you only want to find numbers greater than 0, simply change

If c.Value <> 0 to If c.Value > 0