Re: $$Excel-Macros$$ Array If
Hi Hanumant,
Try it: =IF(A1:A14=a,1,0)
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:
Hi Friends,
I want to use IF condition like i used below but its no working.
I used below formula.
={IF($A$8:$A$14=a,1,)}
f d s d f g a .
.
.
and so on
this is my data which is random.
i want to write if any of the row in above data has a then write 1 else
0. if condition will come only once not for all the rows.
i dont wanna use macro nor OR as data can be large.
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
With Regards
Ankur Saraswat
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ How to send Lotus Notes e-mail using Excel VBA ?
Hi Friends, Read here -- http://www.excelitems.com/2011/01/send-lotus-notes-email-vba-excel.html A must read for Lotus Notes and VBA users :) -- Excel VBA Interview Questionshttp://www.excelitems.com/2010/12/excel-vba-interview-questions.html Collection of Excel VBA Macroshttp://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html VLOOKUPhttp://www.excelitems.com/2009/03/how-to-use-vlookup-function.html OFFSEThttp://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html#more ARRAY formulashttp://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html -- Excel 2003 Style Menu in Excel 2007http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html Custom Number Formathttp://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html SUMIFShttp://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html CONTACT a TRAINERhttp://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavsto.html -- Thanks Regards -- Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com Facebook http://www.facebook.com/eXceLiTems Twitterhttp://www.twitter.com/eXceLiTems LinkedIn http://in.linkedin.com/in/ashishjain08 LiveJournalhttp://livejournal.excelitems.com/ Digg http://digg.com/excelitems Delicioushttp://www.delicious.com/save?new=1url=http%3A%2F%2Fwww.excelitems.com%2Ftitle=MS%20Excel%20VBA%20%26%20VSTO%20Macros%2C%20Functions%2C%20Tutorials%20%26%20Downloadstype=BOOKMARKjump=http://www.delicious.com%2Fmountintkey=Nyn3Hc9oMaEzmGO_Fg_jkAwe1hI-copyuser=mountintvia=mountintcopytags=eXceLitems+Office+Microsoft+Functions+Formulas+VBA+VSTO+Excel2010+Excel2007+excel2003+Excel+Bookmarks_Menu+eXceLiTems.com Subscribe to Emailhttp://feedburner.google.com/fb/a/mailverify?uri=excelitems -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ UDF as trigger
hello people there is a limitation of UDF(User Defined Function) that they cant change the value of cell except the one they called in...so i created a sub...now i want to trigger this sub using UDF,but i cant...sop please suggest me solution. Thanks Regards Akhilesh Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to add Icon sets
HI, See the attachment Regards ROHAN On Tue, Jan 18, 2011 at 11:58 AM, San Pat myitems2...@gmail.com wrote: Hi Group, I am trying to add icon sets in excel 2007. I want to add a up arrow in the cell for the value 0, down arrow for the value 0 and horizontal line (neutral) for value =0. I tried to implement the above by using the standard formula but could not do it. Please advise how it can be done. Do I need to use VBA code for this? Regards, San -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Value_with_Icon_ROHAN.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Replace
Hi Shashank Find the attachment. Regards Thamu On Tue, Jan 18, 2011 at 12:10 PM, shashank bhosle catchshashankbho...@yahoo.co.in wrote: HI All I want to replace some content that are in formula. Thanks and Regards Shashank -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
Hi Team, I got the Point _ But one more Question is in my Data Sheet their is Two Phone numbers are saved in F6 when it results in Main Data sheet its shows the Question mark between the ph no, I want to ask is their any way to arreng the same like F6. i.e one under one? Regards *Jocky* On Tue, Jan 18, 2011 at 11:07 AM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hi Jocky, The reason you are getting #NA error because your criteria for * table_array* * * (*This is the table of data that VLOOKUP searches to find the information you are after.*) is wrong. Your range should start from column B and not A because the value you want to find in the B column of the table. And I think this is the only mistake u have made in the formula Some links :- http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel http://www.techonthenet.com/excel/formulas/vlookup.php I think this help u out Regards, Manoj Kumar On Mon, Jan 17, 2011 at 8:40 PM, jocky Beta jocky6...@gmail.com wrote: Hi Manoj, Thanks for the Information, But when i individually insert range_lookup value 0 it shows #NA value in contact person, Hence i request you to please give me the Step by step details from starting to do the Same(from how to make drag drop list to Last one) Looking foreword for your co-operation. *Please Help me for the above Query!!! * * * * * *Thanks * *Jocky * On Mon, Jan 17, 2011 at 1:03 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Attached for ur reference Regards, Manoj Kumar On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta jocky6...@gmail.comwrote: Hi, I made a Excel sheet with help of V lookup using the Data validation, but my formula shows unknown error. hence pls explain me the step by step procedure for the same. Regards Jocky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Data Validation - No Repitation of data avoid blank
There are no formula or data validation in file!! Best Regards, Amit Desai Assistant Manager, GKS Direct +91 22 6672 9855 Mobile +91 9867232534 mailto:vinod.das...@bdoindia.co.in amit.de...@bdoindia.co.in BDO Consulting Pvt. Ltd. 701, Leela Business Park, Andheri Kurla Road, Andheri (E), Mumbai - 400 059. INDIA Office +91 22 6672 Fax +91 22 6672 9777 http://www.bdoindia.co.in/ www.bdoindia.co.in cid:image003.jpg@01CA83EB.7BB89CD0 BDO Consulting Private Limited, a private limited company incorporated in India, is a member of BDO International Limited, a UK company limited by guarantee, and forms part of the international BDO network of independent member firms. BDO is the brand name for the BDO network and for each of the BDO Member Firms. This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you received this communication in error, please notify BDO immediately and permanently delete or destroy all copies of the original message and attachments. Whilst this e-mail message has been swept by anti-virus software, the recipient is solely responsible for ensuring that any e-mail or attachment the recipient receives, is virus free. The sender disclaims liabilities for any damages the recipient suffers as a consequence of receiving any virus through this mail. From: Manoj kumar [mailto:manoj.vishwakarma...@gmail.com] Sent: Tuesday, January 18, 2011 5:31 PM To: excel-macros@googlegroups.com; amit.de...@bdoindia.co.in Subject: Re: $$Excel-Macros$$ Data Validation - No Repitation of data avoid blank see if this helps you... Regards, Manoj Kumar On Tue, Jan 18, 2011 at 1:03 AM, amit.de...@bdoindia.co.in wrote: Dear Masters, I have one issue.. I am creating one file wants to use data validation with list (giving name to a range of vendor). My data sheet contains few columns. Column A - Vendor name, B - service type. As one vendor may provide I have 2 or more options in column B against same vendors. Thus my list or say name range covers Vendor name more than once. I want to avoid this in data Validation. I want to see Vendor's name only once not more than that (as like filter). Also I do not want to see any blank cell as an option in data validation cells. Kindly reply. Best Regards, Amit Desai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel image001.jpg
Re: $$Excel-Macros$$ Data Validation - No Repitation of data avoid blank
see if this helps you... Regards, Manoj Kumar On Tue, Jan 18, 2011 at 1:03 AM, amit.de...@bdoindia.co.in wrote: Dear Masters, I have one issue.. I am creating one file wants to use data validation with list (giving name to a range of vendor). My data sheet contains few columns. Column A - Vendor name, B - service type. As one vendor may provide I have 2 or more options in column B against same vendors. Thus my list or say name range covers Vendor name more than once. I want to avoid this in data Validation. I want to see Vendor's name only once not more than that (as like filter). Also I do not want to see any blank cell as an option in data validation cells. Kindly reply. Best Regards, Amit Desai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel GG_Datavalidation for dupes and Blank cells_Manoj.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ good evening all experts can u solve my problem
Thanks Ashish it's working good On Jan 17, 10:37 pm, ashish koul koul.ash...@gmail.com wrote: goto control panel - reginal settings - select time and click on customise - click on time tab and choose H:mm option On Mon, Jan 17, 2011 at 8:21 PM, renuka chari jva.ch...@gmail.com wrote: Date Time 04/15/2009 06:02:35 04/14/2009 16:46:49 04/14/2009 16:46:49 04/14/2009 16:46:49 04/14/2009 16:46:48 04/14/2009 23:58:34 i need this kind of format in internally, formula bar have this kind of format only i dont need am or pm in internallcell formula in formula bar how to change this kind of format i know date format in format cells option but internally formula bar having am/pm but i dont need internally also how to change can u help me any one thanks in advance -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Array If
Thanks Ashish
From: ashish koul koul.ash...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tue, 18 January, 2011 10:53:44 AM
Subject: Re: $$Excel-Macros$$ Array If
TYPE THIS IN B1 =IF(COUNTIF(A1:A1000,hanumant )=1,true,false)
On Tue, Jan 18, 2011 at 9:48 AM, hanumant shinde hanumant_5...@yahoo.co.in
wrote:
Hi Srinivasan,
Thanks for the reply.
there is no sample data . i just wanna know hw can i know if the specifi value
(lets say hanumant) is present in specific range or not (lets say A1:A1000).
so i can say i wanna check IF hanumant is present in A1:A1000 range. but i
dont wanna type any formula in all cells from A1 to A1000. its jus i ll type 1
formula in B1 and i ll get True or False in B1.
From: Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com
To: hanumant_5...@yahoo.co.in; excel-macros@googlegroups.com
Sent: Mon, 17 January, 2011 9:10:49 AM
Subject: Re: $$Excel-Macros$$ Array If
Hi hanumant,
You are checking absolute ranges(A8:A14) with a single value a. Which is not
possible.
Please narrate your requirement as well as send with sample data.
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde hanumant_5...@yahoo.co.in
wrote:
Hi Friends,
I want to use IF condition like i used below but its no working.
I used below formula.
={IF($A$8:$A$14=a,1,)}
f
d
s
d
f
g
a .
.
.
and so on
this is my data which is random.
i want to write if any of the row in above data has a then write 1 else 0.
if
condition will come only once not for all the rows.
i dont wanna use macro nor OR as data can be large.
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Srinivasan Ethirajalu,
+919677042736
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Regards
Ashish Koul
akoul.blogspot.com
akoul.wordpress.com
My Linkedin Profile
PBefore printing, think about the environment.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Query
Hi Aamir, Have a look at the attached. Regards - Dave. Date: Tue, 18 Jan 2011 23:28:27 +0500 Subject: Re: $$Excel-Macros$$ Query From: aamirshahza...@gmail.com To: excel-macros@googlegroups.com Thanks for reply, now attached sheet is very clear. Aamir Shahzad On Tue, Jan 18, 2011 at 10:10 AM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps you On Tue, Jan 18, 2011 at 10:36 AM, Dave Bonallack davebonall...@hotmail.com wrote: Sorry Aamir, Can't understand the question. If your worksheet had a cell with the desired answer in it (entered manually) this may help me understand your request. Regards - Dave. From: aamirshahza...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Date: Mon, 17 Jan 2011 23:31:49 +0500 Dear experts, How to resolved attached query, can anybody tell formula not macro. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel QUERY(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Fwd: need help
sorry ashish, the file is not working when i click on update it opens a pop up says read only, notify cancel... Regards, On Tue, Jan 18, 2011 at 8:56 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment On Tue, Jan 18, 2011 at 12:20 PM, lucky singh lucky60...@gmail.comwrote: Hello, Guys Need your help urgently please Regrads -- Forwarded message -- From: lucky singh lucky60...@gmail.com Date: Tue, Jan 18, 2011 at 10:51 AM Subject: need help To: excel-macros@googlegroups.com Hi Guys need your help, I have 25 agenst overall I have to record listen to 12 calls per agent, While rating a call i'll put scores in sheet one automatically it should get updated in sheet 3 i.e. summary sheet all the scores shuld get accumulated... Thanx in advance Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
