Quatro/Excel Formula

N

Niki

I have a Quatropro formula @LASTCELLVALUE(name:$B$5...$B$87) which pulls the
last values in a column from a sheet to a summary spreadsheet. I have been
unable to find an equivalent Excel formula.

Any suggestions, Thanks!
 
B

Bernie Deitrick

Niki,

=LOOKUP(2,1/(ISNUMBER(Sheet1!B5:B87)+ISTEXT(Sheet1!B5:B87)),Sheet1!B5:B87)

HTH,
Bernie
MS Excel MVP
 
N

Niki

Thank you Bernie!

Have a great weekend.

Bernie Deitrick said:
Niki,

=LOOKUP(2,1/(ISNUMBER(Sheet1!B5:B87)+ISTEXT(Sheet1!B5:B87)),Sheet1!B5:B87)

HTH,
Bernie
MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quatro to Excel formula 6
Dealing with the error: unable to filter on excel hc home school 0
Autonumber field in Excel that behaves the same as Access 0
Range headings 0
Dumb question alert! What program to use? 0
Grouping Names in Mail Merge 0
Copy addition formula of non-consecutive horizontal cells 2
Mail Merge Help 1

Top