| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get the last number from the row
Hi guys, Need piece of advice. I have to get the last number from the row that is more than 0. Sounds a little complicated but actually it is for example: CEll A1 - 10 CEll A2 - 0 CEll A3 - 15 CEll A5 - 0 In Cell A5 I should have 15. Does somebody have any idea how to get it? Thanks a lot in advance, Irina. -- Irina ------------------------------------------------------------------------ Irina's Profile: http://www.excelforum.com/member.php...fo&userid=8685 View this thread: http://www.excelforum.com/showthread...hreadid=528257 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| Change number format from text to number? | New Users to Excel | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
