Re: $$Excel-Macros$$ Pivot Answer

2013-08-04 Thread KATHIRVELAN N
Friends please help on this request On Sun, Aug 4, 2013 at 1:46 PM, KATHIRVELAN N wrote: > Dear Friends, > > Help me to get the answers like pivot option. > > Thanks, > Kathirvelan > > -- > 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 of

Re: $$Excel-Macros$$ Pivot Answer

2013-08-04 Thread ashish koul
are the names unique ? or will one person have multiple status on diff dates? On Sun, Aug 4, 2013 at 7:59 PM, KATHIRVELAN N wrote: > Friends please help on this request > > > On Sun, Aug 4, 2013 at 1:46 PM, KATHIRVELAN N wrote: > >> Dear Friends, >> >> Help me to get the answers like pivot o

Re: $$Excel-Macros$$ Pivot Answer

2013-08-04 Thread KATHIRVELAN N
Dear Ashish, Thanks for the reply. The names will be unique. Thanks On Sun, Aug 4, 2013 at 9:25 PM, ashish koul wrote: > are the names unique ? or will one person have multiple status on diff > dates? > > > > > On Sun, Aug 4, 2013 at 7:59 PM, KATHIRVELAN N wrote: > >> Friends please help on th

Re: $$Excel-Macros$$ Pivot Answer

2013-08-05 Thread KATHIRVELAN N
Dear Friends, Please help me to get this answer. Thanks, Kathir On Mon, Aug 5, 2013 at 11:31 AM, KATHIRVELAN N wrote: > Dear Ashish, > > Thanks for the reply. The names will be unique. > > Thanks > > On Sun, Aug 4, 2013 at 9:25 PM, ashish koul wrote: > >> are the names unique ? or will one pe

Re: $$Excel-Macros$$ Pivot Answer

2013-08-05 Thread P.VIJAYKUMAR
Respected Kathirvelan, What exactly is ur requirement.For example, To sort the data or to get the approved or not approved status on a particular date etc.if your reuiqrement is not clear then members will not be able to help you. Regards, Vijaykumar On Mon, Aug 5, 2013 at 2:21 PM, KATHIRVELAN

Re: $$Excel-Macros$$ Pivot Answer

2013-08-05 Thread P.VIJAYKUMAR
Respected Kathirvelan, Pivot table sigma values box should contain only numerical data and not text data.you can use a normal table instead and use Vlookup or the INDEX and MATCH functions to get the desired results. Regards, Vijaykumar On Mon, Aug 5, 2013 at 3:01 PM, P.VIJAYKUMAR wrote: > Re

Re: $$Excel-Macros$$ Pivot Answer

2013-08-05 Thread P.VIJAYKUMAR
Respected Kathirvelan, Please check the following link for your solution. http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba/ Regards, Vijaykumar On Mon, Aug 5, 2013 at 3:11 PM, P.VIJAYKUMAR wrote: > Respected Kathirvelan, > > Pivot table sigma values box sho

Re: $$Excel-Macros$$ Pivot Answer

2013-08-08 Thread KATHIRVELAN N
Friends Please help me. This will save manual work and save time. On Wed, Aug 7, 2013 at 10:26 PM, Bé Trần Văn wrote: > No you do not mind that right? > > 2013/8/7 KATHIRVELAN N > >> Dear Friends, >> >> Please find my requirement details. >> >> 1. I'll have latest dump in the dumb sheet >> 2. I

Re: $$Excel-Macros$$ Pivot Answer

2013-08-08 Thread P.VIJAYKUMAR
Respected Kathirvelan, Please check the following link for your solution. http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba/ Regards, Vijaykumar On Fri, Aug 9, 2013 at 11:29 AM, KATHIRVELAN N wrote: > Friends Please help me. > > This will save manual work and