Rightmost Data in a Cell Range

[atwy]

Hi everyone,

I'm looking to build a vba formula that takes a cell row range (eg. A5:A25) and outputs the data of the rightmost cell with data and to ignore blanks. The range includes cells that contain either text, numbers or blanks.

Thanks in advance!

[mangesh.mehendale]

Please upload excel file with desired output ...

[NeedForExcel]

Are you restricted to VBA?

If you require a normal Excel function, you may try this -

=LOOKUP(2,1/NOT(ISBLANK(A5:A25)),A5:A25)

[atwy]

this works great thanks Dave!

[NeedForExcel]

Glad it helped!