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

2011-03-30 Thread STDEV(i)
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:A1000,A1:A100)) On Wed, Mar 30, 2011 at 3:39 AM, John A. Smith johnasmit...@gmail.comwrote: Thank you very much. It works great. One

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

2011-03-30 Thread Divaker Pandey
can u send that file. Divaker On Tue, Mar 29, 2011 at 2:40 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: 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

$$Excel-Macros$$ Two different work book in one Sheet

2011-03-30 Thread manhar prajapati
Hi expert I have a software which show two diff. work sheet in one excel under different tab. If any one know that software please mail me the name. Regards Manhar Prajapati -- -- Some important links for excel

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

2011-03-30 Thread L.K. Modi
this add in is not working On Wed, Mar 30, 2011 at 10:42 AM, ashish koul koul.ash...@gmail.com wrote: 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 shariqcoo...@gmail.comwrote: Can any one help me? I looking

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

2011-03-30 Thread Kal xcel
Really useful link. Thanks Ashish Thanks a lot. On Wed, Mar 30, 2011 at 10:59 AM, ashish koul koul.ash...@gmail.com wrote: Hi all To learn advance access, excel ,word, powerpoint, outlook VBA coding , open the weblink given below http://www.mvps.org/links.html#VisualBasic --

$$Excel-Macros$$ Help : Formula Required

2011-03-30 Thread zinknax . zinkli
Hi All, I need formula to update column C, value if the time is between 7:00 AM to 9:00 PM YES else NO Find attached for the same. Column AColumn BColumn C DateTime (MST) 7:00 AM 9:00 PM 3/28/2011 6:26 AM YES IF

Re: $$Excel-Macros$$ Select numbers date wise using a formula

2011-03-30 Thread C.G.Kumar
Sir, Is it possible to select two criteria. In the given case Date and Room number and then sort by date. Regards, C.G.Kumar On Fri, Mar 25, 2011 at 8:55 PM, STDEV(i) setiyowati.d...@gmail.com wrote: 1. formula HELPER ( creating list of RowIndex ) array formula in multi cells

Re: $$Excel-Macros$$ Help : Formula Required

2011-03-30 Thread STDEV(i)
Try this formula =IF((B2=7/24)*(B2=9/24),NO,YES) On Wed, Mar 30, 2011 at 6:53 PM, zinknax.zin...@gmail.com wrote: Hi All, I need formula to update column C, value if the time is between 7:00 AM to 9:00 PM YES else NO Find attached for the same. Column AColumn BColumn C

$$Excel-Macros$$ Re: Help : Formula Required

2011-03-30 Thread JsinSk
You can use this formula, make sure to change C6 to the cell your data is located. =IF(AND(C6TIMEVALUE(07:00),C6TIMEVALUE(17:00)),NO,YES) On Mar 30, 7:53 am, zinknax.zin...@gmail.com wrote: Hi All, I need formula to update column C,  value if the time is between 7:00 AM to 9:00 PM YES else

Re: $$Excel-Macros$$ Two different work book in one Sheet

2011-03-30 Thread STDEV(i)
in excel 2003 use menu: Window New Window and then: menu Window Arrange On Wed, Mar 30, 2011 at 12:54 PM, manhar prajapati prajapati.man...@gmail.com wrote: Hi expert I have a software which show two diff. work sheet in one excel under different tab. If any one know that software

Re: $$Excel-Macros$$ Two different work book in one Sheet

2011-03-30 Thread Dilip Pandey
Hi Manhar, I am not sure about this. This must be some kind of windows arrangement. Please attach a screen shot image of that screen, if possible so that Group members can easily understand. I am sure you are not confused with extra sheets in a workbook and you must be knowing that we can add

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

2011-03-30 Thread Dilip Pandey
Hi Nadine, See the attached file where I have used the following formula to achieve the desired result. =IF(SUMPRODUCT((Sheet1!$A$2:$A$20=Sheet2!$A2)*(Sheet1!$B$2:$B$20=Sheet2!$B2)*1)=0,Not Valid,Valid) Please feel free to revert in case of any issues. Best Regards, DILIPandey On 3/30/11,

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

2011-03-30 Thread Dilip Pandey
Hi Manoj, You can subscribe to this group by following the below link:- http://groups.google.com/group/excel-macros Alternatively, you an also send your joining request to the Manager / Owner of the group (ayush jain jainayus...@gmail.com). Best Regards, DILIPandey On 3/29/11, Manoj Kumar

Re: $$Excel-Macros$$ for the membership

2011-03-30 Thread Dilip Pandey
Hi Manoj, You can subscribe to this group by following the below link:- http://groups.google.com/group/excel-macros Alternatively, you an also send your joining request to the Manager / Owner of the group (ayush jain jainayus...@gmail.com). Best Regards, DILIPandey On 3/29/11, Manoj Kumar

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

2011-03-30 Thread Dilip Pandey
Thanks Ashish...!! This is awsome site. Best Regards, DILIPandey On 3/30/11, ashish koul koul.ash...@gmail.com wrote: 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* *