Re: $$Excel-Macros$$ Reverse a series of number in excel

2013-12-01 Thread Sam Mathai Chacko
By reverse, do you mean to reverse the position of the values, irrespective of whether larger or smaller, or do you want to sort in the opposite direction? If sort, why don't you just use Sort method? If you want to simply reverse the values using formula, use =INDEX($*A$1*:$A$4,ROWS($*A1*:$A$4))

Re: $$Excel-Macros$$ Reverse a series of number in excel

2013-12-01 Thread Nishant Sharma
1 4 2 3 3 2 4 1 On Sun, Dec 1, 2013 at 8:34 PM, ashish koul wrote: > can u share sample file ? > > On Sun, Dec 1, 2013 at 7:54 PM, Nishant Sharma > wrote: > >> how to do this using formula... >> >> >> On Sat, Nov 30, 2013 at 11:30 PM, ashish koul wrote: >> >>> no ... >>> >>> >>> On Sat, Nov 30

Re: $$Excel-Macros$$ Reverse a series of number in excel

2013-12-01 Thread ashish koul
can u share sample file ? On Sun, Dec 1, 2013 at 7:54 PM, Nishant Sharma wrote: > how to do this using formula... > > > On Sat, Nov 30, 2013 at 11:30 PM, ashish koul wrote: > >> no ... >> >> >> On Sat, Nov 30, 2013 at 6:01 PM, Nishant Sharma < >> sharma.nishan...@gmail.com> wrote: >> >>> Hi, >>>

Re: $$Excel-Macros$$ Reverse a series of number in excel

2013-12-01 Thread Nishant Sharma
how to do this using formula... On Sat, Nov 30, 2013 at 11:30 PM, ashish koul wrote: > no ... > > > On Sat, Nov 30, 2013 at 6:01 PM, Nishant Sharma < > sharma.nishan...@gmail.com> wrote: > >> Hi, >> >> Please help me in reversing numbers in excel. >> >> I did thru macro but cant undo it, can w

Re: $$Excel-Macros$$ Reverse a series of number in excel

2013-11-30 Thread ashish koul
no ... On Sat, Nov 30, 2013 at 6:01 PM, Nishant Sharma wrote: > Hi, > > Please help me in reversing numbers in excel. > > I did thru macro but cant undo it, can we undo a runned macro sheet?? > > Thanks > Nishant > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’