| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Last 10 rows in reverse row order.
Thanks for letting me know, Sam.
I thought that had to be the reason for it not working for you. -- Regards Roger Govier "Sam via OfficeKB.com" <u4102@uwe wrote in message news:7ff9f922df4c4@uwe... Hi Roger, You found my problem, I've got data below the dynamic range. I forgot about it. Sorry! Cheers, Sam Roger Govier wrote: Sam This has me baffled I copied the data in exactly as posted, using the "visual aide" column as well, which was in Column C If your column C contains 1 header in row 1 and only your numeric data in the remainder of column C, and if there is no data in column C below your Dynamic range Data, then COUNT($C:$C) should return the same value as ROWS(Data) In all other respects the formulae are identical. -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reverse name order from Last, First to First Last in Exc | Excel Discussion (Misc queries) | |||
| SPELL IN REVERSE ORDER | Excel Worksheet Functions | |||
| reverse order | Excel Discussion (Misc queries) | |||
| How to reverse order of rows and columns | Excel Discussion (Misc queries) | |||
| sort in reverse order | Excel Discussion (Misc queries) | |||
![Roger Govier[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
