How can I bring back the last true value between two ranges?

This bring back the first, I now would like to bring back the last
=INDEX(E22:J22,MATCH(1,INDEX((COUNTIF($R$2:$R$17,E22:J22)>0)+0,0),0))
LVL 5
syeager305Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
see attached
Book3.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

like this:

=INDEX(E22:J22,MATCH(1,INDEX((COUNTIF($R$2:$R$17,E22:J22)>0)+0,0),1))

cheers, teylyn
0
 
syeager305Author Commented:
That what I'm already doing
112113

2
0
0
0
3

If I was looking for a true value it would be the last true value, not the first.  In this case it would be 3
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
My formula is different from yours. Have you tried it?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
It might help to see your data. This one also works in my tests

=INDEX(E22:J22,MATCH(2,INDEX((COUNTIF($R$2:$R$17,E22:J22)>0)+0,0),1))
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The formula I suggested works, as is demonstrated in the file attached in comment 36546342.
Suggest to accept that as the solution.
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.