Re: $$Excel-Macros$$ Calculating An Average Score from Multiple Tabs

assuming your data (one column range) are in A1:A100 and there are some 0 (blank / zero) value in these column.. try this *Array Formula* =MIN(IF(A1:A100<>0,A1:A100)) On Wed, Mar 30, 2011 at 3:39 AM, John A. Smith wrote: > Thank you very much. It works great. One other question please; I

$$Excel-Macros$$ Useful Link ( Excel, Access, Word, Powerpoint ) VBA

Hi all To learn advance access, excel ,word, powerpoint, outlook VBA coding , open the weblink given below http://www.mvps.org/links.html#VisualBasic -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com *akoul*.wordpress.com My Link

Re: $$Excel-Macros$$ How to send mail with excel

Try these links http://www.rondebruin.nl/mail/folder3/mail4.htm http://www.rondebruin.nl/mail/add-in.htm > > > > > On Tue, Mar 29, 2011 at 8:02 PM, shariq khan wrote: > >> Can any one help me? >> >> >> >> I looking for code to send an email from excel to the number of users, few >> in TO and some

Re: $$Excel-Macros$$ How to send mail with excel

try this addin see if it helps http://www.rondebruin.nl/mail/add-in.htm On Tue, Mar 29, 2011 at 8:02 PM, shariq khan wrote: > Can any one help me? > > > > I looking for code to send an email from excel to the number of users, few > in TO and some are on CC. > > > > I also need to add the bel

Re: $$Excel-Macros$$ Need formula to determine if combination is valid

try this see if it helps IF(VLOOKUP(A2,Sheet1!A:B,2,0)=Sheet2!B2,"Valid","Not Valid") On Wed, Mar 30, 2011 at 4:16 AM, None wrote: > Hi all. Attached is a workbook that contains 2 sheets. The first is the > list that the 2nd sheet will refer to. I'd like a formula in col C on sheet > 2 that

Re: $$Excel-Macros$$ Chart formatting

select the chart and run the macro hope it solves your problem Sub frtchart() Dim x As Chart Set x = ActiveChart x.ChartArea.Format.Line.Visible = msoFalse x.PlotArea.Format.Line.Visible = msoFalse x.Axes(xlValue, xlPrimary).HasMajorGridlines = False x.Axes(xlValue, xlPrimary).HasMinorGridlin

$$Excel-Macros$$ Need formula to determine if combination is valid

Hi all.  Attached is a workbook that contains 2 sheets.  The first is the list that the 2nd sheet will refer to.  I'd like a formula in col C on sheet 2 that looks up each combination and determines if the combination is valid.  Does anyone have any ideas? Thanks. Nadine -- --

Re: $$Excel-Macros$$ Calculating An Average Score from Multiple Tabs

Thank you very much. It works great. One other question please; I have a column with all formula's and I am looking for the smallest number in it by using =MIN(range). I get 0 (zero) because the formula is =IF(DY9="GONE","",D9). DY9 is an automatic status column that shows "GONE" if a ship date

$$Excel-Macros$$ Re: Calculating An Average Score from Multiple Tabs

Try this =IF(ISERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'! B10)),"",AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!B10)) On Mar 29, 7:52 pm, "John A. Smith" wrote: > I have like tabs from different departments and need to summarize an average > score by day.  But if there were no scores in a p

Re: $$Excel-Macros$$ multi- excel requrired

Hi Sajid, Share the workbook and after typing and pressing enter press Cntrl+S to get reflected in both the workbooks. *How to Share A Workbook?* Microsoft Office Excel 2003 and earlier versions of Excel 1. On the *Tools* menu, click *Share Workbook*, and then click the * Editing* tab. 2

Re: $$Excel-Macros$$ Calculating An Average Score from Multiple Tabs

Hi John, change the formula to IFERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!B10),"") Regards Umesh On Tue, Mar 29, 2011 at 8:22 PM, John A. Smith wrote: > I have like tabs from different departments and need to summarize an > average score by day. But if there were no scores in a partic

$$Excel-Macros$$ Calculating An Average Score from Multiple Tabs

I have like tabs from different departments and need to summarize an average score by day. But if there were no scores in a particular day, I get #DIV/0!. Please help with the formula that eliminates it. I tries an IFERROR in front of the AVERAGE but got a blank cell. Thank you. John --

$$Excel-Macros$$ How to send mail with excel

Can any one help me? I looking for code to send an email from excel to the number of users, few in TO and some are on CC. I also need to add the below table in the body of the mail looks like the below example _ Hi,

$$Excel-Macros$$ for the membership

Dear I want to join your groups so plz suggest me how its possible on this mail id. Regards Manoj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/

$$Excel-Macros$$ how can i add this groups

Dear Member, Can you tell me how can i add this groups of excel and VBA macros can you tell me Regards Manoj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://t

$$Excel-Macros$$ multi- excel requrired

Hi Expert, I have two pc with lan connection. I want to type in excel file that text should display in second pc when i press enter key. If it's possible then give me tips.. Thanks & Regards, Sajid Memon -- -- Some

$$Excel-Macros$$ Auto Refresh data in excel

Hi Expert, Some of my excel sheet has linked with Internet which requires live auto updation, by default I can do 1 min refresh... Could you help me with any VB code where I can do it on live basis and at background excel update the data. Thanks & Regards, Anil Bhange IP - 512320 -- ---

$$Excel-Macros$$ Chart formatting

Hi Expert, I wanted the help in charts with VB programming... I wanted to format the waterfall chart with some repeated steps.. I have given the Normal charts and formatted chart for your examples and also given the steps need to perform... Please give me the VBA code for this. Regards,An

$$Excel-Macros$$ Re: Rolling 4 Quarter Cummulative Revenue

Dear Akash, Pls attach the sample file. So we can help you better. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ Formula reqd

thanks a lot for ur help.. With Regards, Akshay Banglore +919916512599 On Tue, Mar 29, 2011 at 10:35 AM, mrinal saha wrote: > Hope, this serves the purpose. See attachment > > regards, > Mrinal > > On Mon, Mar 28, 2011 at 11:35 PM, Akshay wrote: > >> Dear Experts, >> >> Plz help me by