$$Excel-Macros$$ Re: E Book on Excel.

Dear Hari, Plz send the advance book of excel along with the VBA and MACROS using excel. regards, Kamal Gulati E-mail:kamalgula...@gmail.com On Sat, May 9, 2009 at 9:57 AM, hari kumar wrote: > Hi Prateek, > > FYI. > This book covers basics. if need more details or advanced, let me know. >

$$Excel-Macros$$ Re: Run a macro on Enter?

trick question...don't know how to trigger action on ENTER...hmm.waiting for info as well:) On Thu, May 7, 2009 at 9:58 PM, Doug wrote: > > I've got an Excel spreadsheet that I'm going to use a wedge program > with to capture data from an instrument and parse it into the sheet. I > would like t

$$Excel-Macros$$ Re: E Book on Excel.

Dear Hari, It would be great if u could pass on advance module of this excel E book. Regards, Manish Lalwani On Sat, May 9, 2009 at 9:57 AM, hari kumar wrote: > Hi Prateek, > > FYI. > This book covers basics. if need more details or advanced, let me know. > > Regards > Hari Kumar > > On Fri, Ma

$$Excel-Macros$$ Re: pls help- i need to get the column name in the fields

Hi, I wrote this formula for ur purpose. =IF(RANK($A2,$A2:$D2,1)=F$1,$A$1,IF(RANK($B2,$A2:$D2,1)=F$1,$B$1,IF(RANK($C2,$A2:$D2,1)=F$1,$C$1,$D$1))) See the attached sheet for reference. Let me know if this helps. On Sat, May 9, 2009 at 8:53 PM, subs wrote: > > ca1 ca2 ca3 ca4 > > > 12 123 1 2

$$Excel-Macros$$ Re: single password for excel

Can anyone explain a bit principle and ways of BREAKING passwords? On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati wrote: > Plz help me to crack the password for MS - Word. > Thanks and regards, > > Kamal Gulati > > > > > On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte > wrote: > >> Install Ultim

$$Excel-Macros$$ Re: Average's

Considering, if you want the average of the top 7 sales and the lowest 7 sales For highest 7 =AVERAGE(LARGE($A$2:$A$11,1),LARGE($A$2:$A$11,2),LARGE($A$2:$A$11,3),LARGE($A$2:$A$11,4),LARGE($A$2:$A$11,5),LARGE($A$2:$A$11,6),LARGE($A$2:$A$11,7)) For lowest 7 =AVERAGE(SMALL($A$2:$A$11,1),SMALL($A$2:$

$$Excel-Macros$$ Re: Need help

Addressing the group On Sat, May 9, 2009 at 11:35 PM, shariq khan wrote: > Hi Harmeet, > > > Actually I got your ID from macro group and saw some of your macro codes, > they was really very good. > > I need your help , > > I want 2 merge the 100 excel files placed in a folder (this module is >

$$Excel-Macros$$ Re: Consolidation of sheets

below is the code Dim ownf, raws, cc, cno As String Sub findd() Application.DisplayAlerts = False Application.ScreenUpdating = False Dim i As Integer ownf = ActiveWorkbook.Name 'cno = Range("b2").Value 'cc = Range("b3").Value With Application.FileSearch .LookIn = R

$$Excel-Macros$$ Re: Average's

Hi Sabby, Sorry for the delay in responce. Could you please attach a sample sheet so that it is easy to understand the organization of the data in your worksheets. Regards, Andy On Fri, May 8, 2009 at 4:38 PM, Sabbycat wrote: > > hi Aindril > > as i am trying to calculate the lowest average sa

$$Excel-Macros$$ pls help- i need to get the column name in the fields

ca1 ca2 ca3 ca4 12 123 1 23 7 8 9 5 4 6 7 6 i have tthe above exel data with coln names as ca1,ca2,ca3 etc . i need the result like ca1 ca2 ca3 ca4 rank1 rank2 rank 3 12 123 1 23 ca3 ca4 ca1 7 8 9 5 ca4 ca1 ca2 4 6 7 6 ca1 c

$$Excel-Macros$$ Re: E Book on Excel.

Dear Hari, Please send the advanced excel ebook. Thanks Manoj Date: Fri, 8 May 2009 21:27:26 -0700 Subject: $$Excel-Macros$$ Re: E Book on Excel. From: prekkeh...@gmail.com To: excel-macros@googlegroups.com Hi Prateek, FYI. This book covers basics. if need more details or advanc

$$Excel-Macros$$ Re: E Book on Excel.

Hi Hari, Can you please email me the more detailed / advanced version. Thanks and regards, Joseph On Sat, May 9, 2009 at 9:57 AM, hari kumar wrote: > Hi Prateek, > > FYI. > This book covers basics. if need more details or advanced, let me know. > > Regards > Hari Kumar > > On Fri, May 8, 2009