$$Excel-Macros$$ Re: Getting top 50 ranks from a pivot table

2009-09-30 Thread Dilip Pandey
Dear Tiwari, To learn VBA, you can either refer to google search or go through following links, which are there in the email footer of every email marked to the "Group", Same is reproduced below. Morevover, there are books uploaded in the "Files" section at the home page of the Group. =

$$Excel-Macros$$ Re: Getting top 50 ranks from a pivot table

2009-09-29 Thread Jai Deo Tiwari
Hi All, I am new for VBA.But i am working as developer in Java Tech. Please suggest me how to learn VBA ? -- Regards, Jai Deo Tiwari, Rewire Information Systems Indiranagar, Bangalore - 38 Mob # 09620346991 . Notice: The information contained in this e-mail message and/or attachments to it

$$Excel-Macros$$ Re: Getting top 50 ranks from a pivot table

2009-09-29 Thread Dilip Pandey
Hi Prashanth, If the pivot table shows that data in column G, then you can use the following formula:- =LARGE(G:G,COUNTA($G$1:G1)) Note:- Drag it to 50 times down. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062