Re: $$Excel-Macros$$ Help required - alternate sorting

2015-02-08 Thread Vaibhav Joshi
Great..Cheers! On Sun, Feb 8, 2015 at 1:20 PM, singla.kris...@gmail.com < singla.kris...@gmail.com> wrote: > Hi Vabz, > > Thank you very much That worked like wonder... > > Many thanks > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! J

Re: $$Excel-Macros$$ Help required - alternate sorting

2015-02-07 Thread singla.kris...@gmail.com
Hi Vabz, Thank you very much That worked like wonder... Many thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate t

Re: $$Excel-Macros$$ Help required - alternate sorting

2015-02-03 Thread Vaibhav Joshi
Hi, check this file.. Put formula countif in next columncopy & paste down, you can see there is Separate set of sequential numbering for Dr & Cr. Once it is ok, copy & paste value for formula column & sort data AtoZ .. Cheers!! On Tue, Feb 3, 2015 at 5:25 PM, singla.kris...@gmail.com < singla.

Re: $$Excel-Macros$$ Help required - alternate sorting

2015-02-03 Thread Pramod Singh
Send with Excel file where you want to do this. Pramod On 3 Feb 2015 17:25, "singla.kris...@gmail.com" wrote: > Hi, > > Can somebody please help me in a small macro. My sheet have a column with > some values and I want to sort them alternately. > > Current > Dr. > Cr. > Dr. > Dr. > Cr. > Cr. > C

$$Excel-Macros$$ Help required - alternate sorting

2015-02-03 Thread singla.kris...@gmail.com
Hi, Can somebody please help me in a small macro. My sheet have a column with some values and I want to sort them alternately. Current Dr. Cr. Dr. Dr. Cr. Cr. Cr. Dr. Required Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Thanks in advance Krishan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d