Joined: Jun 21, 2003 Posts: 173 Location: Selmer, Tennessee
Posted: Wed Sep 16, 2009 5:51 am Post subject:
Best way to reverse their order would be to number the rows, then sort on those numbers in reverse order. Finally, hide or delete the column holding the numbers you added.
Note: The TRANSPOSE() function won't work for this. That function converts the columns into rows, i.e., it makes the column array go to a row array. _________________ Jim Plante
MacOS X 10.6.34, MacBook 2GHz C2Duo, 2gb, Neo 3.1.1 p 1
Best way to reverse their order would be to number the rows, then sort on those numbers in reverse order. Finally, hide or delete the column holding the numbers you added.
Note (for the benefit of Google, or anyone else not familiar with the trick) that to number the rows, select a column (or the cells in that column that match the rows you want), and choose Edit: Fill…: Series. Enter your start, end, and increment values, and *poof*, Neo has numbered your rows.
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Joined: Jun 21, 2003 Posts: 173 Location: Selmer, Tennessee
Posted: Wed Sep 16, 2009 11:51 am Post subject:
To continue Smokey's tip:
Alternatively, you can enter "1" in the top cell, grab the lower right corner, and drag to the bottom. Neo will number the cells sequentially. This will work for short lists, but for longer ones use Smokey's method. Dragging clear to the bottom of a 1000-row spreadsheet is, well
....a drag. _________________ Jim Plante
MacOS X 10.6.34, MacBook 2GHz C2Duo, 2gb, Neo 3.1.1 p 1
Last edited by Jim on Wed Sep 16, 2009 12:05 pm; edited 1 time in total
To continue Smokey's tip:
Alternatively, you can enter "!" in the top cell, grab the lower right corner, and drag to the bottom. Neo will number the cells sequentially.
Ooh, nifty tip! However, it only works for me with an actual number in the top cell.
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Joined: Jun 21, 2003 Posts: 173 Location: Selmer, Tennessee
Posted: Wed Sep 16, 2009 12:07 pm Post subject:
Doggone typos. I corrected it.
BTW, try entering "Tuesday" in that top cell, and drag it down. It'll increment any ordered list you have stored, and will do dates (by day) as well. Enter "1/30/09" at the top and drag down.
And it'll do the same thing dragging across.
To see the lists available, check Tools->options... and choose Calc::Sort lists. _________________ Jim Plante
MacOS X 10.6.34, MacBook 2GHz C2Duo, 2gb, Neo 3.1.1 p 1
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum