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

$$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

$$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 --

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.

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 --

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

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),

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

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

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

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

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