| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatic display of last 2 entries in tHe column to specified cel
what is the formula for automatically displaying the last 2 entries in
columns C and D to columns A and B. But, if the last 2 entries are the same, only the 2nd last will be displayed. to illustrate: 1st scenario: A B C D 5 10.50 20 10.50 10 11.00 15 11.00 5 10.50 10 11.00 2nd scenario: A B C D 5 10.50 20 10.50 15 10.500 5 10.50 5 10.50 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM: Display automatic | New Users to Excel | |||
| add multiple entries and display on another sheet | Excel Discussion (Misc queries) | |||
| Formula to display last few entries | Excel Worksheet Functions | |||
| How to display selected table entries from another worksheet? | Excel Worksheet Functions | |||
| Automatic changes in cell entries | Excel Discussion (Misc queries) | |||
![mike CBA[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
