# Find nth non-zero number in range, from right to left..

#### JonesyUK

##### Board Regular
Hi All,

Please can you suggest a formula to return the nth non-zero number in a row of data, starting from the right.

Example: the 5th non-zero number in the following string, starting from the right would be 108:

52, 40, 108, 5, 58, 0, 22

#### Fluff

##### MrExcel MVP, Moderator
Using Office 365 (it says version 2008??)

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### KP117

##### New Member
Try this at B2,
=INDEX(4:4,LARGE(IF(B4:S4=0,"",COLUMN(B4:S4)),B1))

#### JonesyUK

##### Board Regular
Try this at B2,
=INDEX(4:4,LARGE(IF(B4:S4=0,"",COLUMN(B4:S4)),B1))
Thanks, this works! Appreciate it very much...

#### Fluff

##### MrExcel MVP, Moderator
Did you try what Joe or I suggested?

#### Joe4

Did you try what Joe or I suggested?
I thought maybe our posts when invisible or something...

#### JonesyUK

##### Board Regular
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

+Fluff v2.xlsm
ABCDEFGHIJKLMNO
15
2405240108558022
358524010855811220156
41085240108558022009
Data
Cell Formulas
RangeFormula
A2:A4A2=INDEX(B2:X2,AGGREGATE(14,6,(COLUMN(B2:X2)-COLUMN(B2)+1)/(B2:X2>0),\$A\$1))
hi, thanks, this one looks like the text is corrupted....??

#### Fluff

##### MrExcel MVP, Moderator
hi, thanks, this one looks like the text is corrupted....??
In what way? It looks fine to me.

#### Dave Patton

##### Well-known Member
N.B. KP117's suggestion requires Array Enter (CSE) for versions prior to 365.

Replies
1
Views
82
Replies
10
Views
536
Replies
3
Views
216
Replies
1
Views
100
Replies
10
Views
186

1,130,407
Messages
5,641,961
Members
417,249
Latest member
serrulate

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back