$$Excel-Macros$$ Counting Visible cell in Pivot

2013-11-20 Thread Chandra Shekar
Hello, How to count visible cell in pivot? Regards, Chandru -- 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 thread titl

Re: $$Excel-Macros$$ Vlookup query

2013-11-20 Thread Kartik Dale
Hi Shrinivas, PFA, Let me know if you need any changes required Regards, Cartik On Wed, Nov 20, 2013 at 5:10 PM, Shrinivas Shevde wrote: > Dear All > Please find attached query. > Is it possible to write aformula as per my requirement > > -- > Shrini > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:

Re: $$Excel-Macros$$ Vlookup query

2013-11-20 Thread Shrinivas Shevde
Can u explian more please On Wed, Nov 20, 2013 at 5:31 PM, Ravinder wrote: > Then you can use Match function to get the column number and put in yellow > colored.. > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde > *Sent

RE: $$Excel-Macros$$ Vlookup query

2013-11-20 Thread Ravinder
Then you can use Match function to get the column number and put in yellow colored.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Wednesday, November 20, 2013 5:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macr

Re: $$Excel-Macros$$ Vlookup query

2013-11-20 Thread Shrinivas Shevde
Dear Ravindra thanks for reply VLOOKUP($J5,CHOOSE({1,2,3,4},$D$4:$D$7,$C$4:$C$7,$E$4:$E$7,$B$4:$B$7),COLUMN(B$1),0) In the above formula in choose function you wrote (1,2,3,4)but I have more than 2000 records. then how to do regards Shrinivas On Wed, Nov 20, 2013 at 5:19 PM, Ravinder wrote: > pf

RE: $$Excel-Macros$$ Vlookup query

2013-11-20 Thread Ravinder
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Wednesday, November 20, 2013 5:11 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup query Dear All Please find attached query. Is it possible to write a

$$Excel-Macros$$ Vlookup query

2013-11-20 Thread Shrinivas Shevde
Dear All Please find attached query. Is it possible to write aformula as per my requirement -- Shrini -- 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 RU

$$Excel-Macros$$ Re: ExcelAutomate.blogspot.in

2013-11-20 Thread anoop kumar
Please post your questions also On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote: > > Hi webies, > > I just started blogging, please check the excel automation blog > www.excelautomate.blogspot.in... > please share your comments and more information about excel macros... >

$$Excel-Macros$$ ExcelAutomate.blogspot.in

2013-11-20 Thread anoop kumar
Hi webies, I just started blogging, please check the excel automation blog www.excelautomate.blogspot.in... please share your comments and more information about excel macros... With Thanks, Anoop.V -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:O