| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quatro/Excel Formula
Thank you Bernie!
Have a great weekend. "Bernie Deitrick" wrote: Niki, =LOOKUP(2,1/(ISNUMBER(Sheet1!B5:B87)+ISTEXT(Sheet1!B5:B87)),Sh eet1!B5:B87) HTH, Bernie MS Excel MVP "Niki" wrote in message ... 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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Quatro Pro to Excel | Excel Discussion (Misc queries) | |||
| How can I get Excel 2003 to open a quatro pro file? | Excel Discussion (Misc queries) | |||
| quatro pro to excel 2003 | Excel Discussion (Misc queries) | |||
| quatro pro to excel | Excel Worksheet Functions | |||
| Can I open documents made with Quatro Pro with Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
