| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete values in each row leaving only last value ?
I have a table A B C D E F G H 1| 5 12 14 7 2| 45 1 77 3| 8 74 12 99 47 4| 4 5| 1 12 In result I want to get last value from each row (in column A) A B C D E F ... 1| 7 2|77 3|47 4| 4 5|12 -- Oleg ------------------------------------------------------------------------ Oleg's Profile: http://www.excelforum.com/member.php...fo&userid=4004 View this thread: http://www.excelforum.com/showthread...hreadid=521183 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to delete values in each row leaving only last value ?
I put this formula in I2:
=LOOKUP(2,1/(A2:H2<""),A2:H2) And dragged down Then I converted that column to values: edit|copy edit|paste special|values and deleted columns A:H Oleg wrote: I have a table A B C D E F G H 1| 5 12 14 7 2| 45 1 77 3| 8 74 12 99 47 4| 4 5| 1 12 In result I want to get last value from each row (in column A) A B C D E F ... 1| 7 2|77 3|47 4| 4 5|12 -- Oleg ------------------------------------------------------------------------ Oleg's Profile: http://www.excelforum.com/member.php...fo&userid=4004 View this thread: http://www.excelforum.com/showthread...hreadid=521183 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete duplicated values in each row ??? | Excel Discussion (Misc queries) | |||
| Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
| How to delete values of a cell if it is found in another coloumn | Excel Worksheet Functions | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
| Macro do delete values in cells | Excel Discussion (Misc queries) | |||
Linear Mode
