| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
RETURN THE LAST FILLED CELL VALUE
Thanks alot Mr. Dibben your Formula Help is perfect. and I have find the
solution with this. Now kindly explain me this formula, that what logic you use. i will be highly thankful to you. adeel Gord Dibben wrote: Jay Try this formula to get last filled cell(numeric or text) in column A =LOOKUP(2,1/(A1:A65535<""),A1:A65535) Gord Dibben MS Excel MVP Use a formula like the following array formula: [quoted text clipped - 12 lines] How is your formula supposed to work? I can't figure out the logic. Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200707/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to colour a cell green if another cell is filled with text | Excel Discussion (Misc queries) | |||
| Set cell to record date when adjacent cell is filled AND NOT RESET | Excel Worksheet Functions | |||
| Paste into a filled cell | Excel Discussion (Misc queries) | |||
| Excell - How do I "force" cell to be filled or return error mge. | Excel Worksheet Functions | |||
| Return number of cells filled | New Users to Excel | |||
Threaded Mode
