Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an formula to reverse the order of a number sequence?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an formula to reverse the order of a number sequence?
I've seen it done but I cannot mentally resurrect the formula right now.
This is a simple way to do it but it has a kludgy stipulation. =INDEX($A$1:$A$10,COUNT(A1:A10)) Enter this in say, C1, and copy it down to C10. The numbers in A1:A10 will appear reversed IF the cells A11:A20 are all empty. That's the stipulation - a range of equal length below the numbers must remain empty. Perhaps I've inspired someone to provide a better answer... -- Jim " wrote in message ... | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an formula to reverse the order of a number sequence?
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an formula to reverse the order of a number sequence?
Jim
Without the stipulation that A11:A20 are empty. =INDEX($A$1:$A$10,10-(ROW(A1)-1)) Enter in C1 and copy down to C10 Gord Dibben MS Excel MVP On Wed, 1 Nov 2006 08:12:50 -0500, "Jim Rech" wrote: I've seen it done but I cannot mentally resurrect the formula right now. This is a simple way to do it but it has a kludgy stipulation. =INDEX($A$1:$A$10,COUNT(A1:A10)) Enter this in say, C1, and copy it down to C10. The numbers in A1:A10 will appear reversed IF the cells A11:A20 are all empty. That's the stipulation - a range of equal length below the numbers must remain empty. Perhaps I've inspired someone to provide a better answer... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Need a formula to create an order number | Excel Worksheet Functions | |||
Generate Auto Order Number | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |