Help with find the last number(s) in a tabel

Folks I have a table ranged K3:P7 with numerous numbers.
I also have a table K11:L15 when K11:K15 is numbered 3,4,5,6,7 to correspond to the row numbers.
In L11:L15 I want to place the last values from each row in my K3:P7 table using the array function.What I have below, which is about to 20th version is no better than version one.

Open in new window

I'm really confused on the INDEX part here also.
Frank FreeseAsked:
Who is Participating?
barry houdiniConnect With a Mentor Commented:
In L11 use this formula copied down to L15


That will get you the last number in each row

regards, barry
Can you post the Excel?
Better than mine! Thanks for the tip Barry :)
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Frank FreeseAuthor Commented:
how you came up with this....anyway, IT WORKED!
I'll accept your answer.
Frank FreeseAuthor Commented:
thanks to the both of you
good job barry
Frank FreeseAuthor Commented:
could you briefy explain to me what this formula is saying?
barry houdiniCommented:
9.99E+307 is the biggest number you can input in a cell in Excel (equivalent to 9.99 with 305 zeroes) so when you lookup using that number as a lookup value it probably won't be found.

If LOOKUP can't find the lookup value then it matches with the last number in the lookup range (because that should be the largest in a sorted range), so it does what you want here, finds the last number.

For last text value


or for last value, number or text


regards, barry
Frank FreeseAuthor Commented:
thanks barry
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.