Use rightmost non-empty cell i address in a row.

**Gabor** · 01-18-2018, 11:15 AM

Guys, in D2 I'd like to compare a target figure of C2 with the rightmost figure entered into the range E2:P2.
How do I pick the rightmost non-empty cell address into my comparison formula?
Thanks

**JohnTopley** · 01-18-2018, 11:39 AM

Try

=LOOKUP(2,1/($E$2:$P$2<>""),$E$2:$P$2)

to get right-most value

**Jonmo1** · 01-18-2018, 11:43 AM

If the values are numbers, you can use

=LOOKUP(9.99999999999999E+307,$E$2:$P$2)

Use rightmost non-empty cell i address in a row.

LinkBack

Thread Tools

Rate This Thread

Display

Use rightmost non-empty cell i address in a row.

Re: Use rightmost non-empty cell i address in a row.

Re: Use rightmost non-empty cell i address in a row.

Thread Information

Users Browsing this Thread

Similar Threads

Rightmost Data in a Cell Range

Contents of Rightmost Cell

look for the rightmost cell with data

how to delete the 4 rightmost digits from a cell

Formula ? Return value from rightmost non-blank cell in a row of

Formula ? Return value from rightmost non-blank cell in a row of

Formula ? Return value from rightmost non-blank cell in a row of

Bookmarks

Bookmarks

Posting Permissions