Explanation

[JACOBB9900]

Hello,

Can someone help me understand this array formula. I found it online. It returns the value in the last occupied cell in a row but I would like to understand how the middle section works. My understanding is that ($T14:$HK14<>"") is FALSE, so what does dividing 1 by FALSE work. If that's what's going on. Also, only cells T14 to FJ14 have data. Cells FK14 to HK14 are empty. See formula below.

=LOOKUP(2,1/($T14:$HK14<>""),$T14:$HK14)

Thank you.

 

[Marcelo Branco]

Take a look at
https://www.mrexcel.com/forum/excel...alue-unsorted-data-post492425.html#post492425

Excellent explanation provided by Aladin Akyurek

M.

 

[Fluff]

This part
($T14:$HK14<>"")

will give an array of TRUE or FALSE responses depending on whether the cells are empty.
when you divide 1 by that array the True becomes 1 & the False becomes 0 so you endup with an array of 1,1,#div0 , #div0
The best way to figure out what a formula is doing, is the use the Evaluate Formula option on the formulas tab. That way you can see exactly what is happening.