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

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

$$Excel-Macros$$ How to Prevent Blank Cells from plotting in Excel Charts?

Hi Friends, Read this, if you want to avoid plotting of blank cells as zeroes. http://www.excelitems.com/2011/01/prevent-blank-cells-plot-chart.html Esp. go through the comment of Jon Peltier who has provided great insight to it. -- Excel VBA Interview Questions<

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

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

Dear Hanumant, check it: =IF(COUNTIF($A$1:$A$1000,"*hanumant*" )>=1,COUNTIF($A$1:$A$1000,"*hanumant*" ) & " Times available","Not Present") Regards Thamu On Tue, Jan 18, 2011 at 12:58 PM, Ankur Saraswat wrote: > Hi Hanumant, > > Try it: =IF(A1:A14="a",1,"0") > > > > > On Mon, Jan 17, 2011 at

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

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

$$Excel-Macros$$ Analysing VBA code

I am currently building a fairly large VBA project for Excel. I should like to run an analysis on the code. There are a number of uses for this but the most interesting to me at the moment are:- 1/ identify VARIABLES that are not used. 2/ identify code that cannot be reached. Excel/VBA does

Re: $$Excel-Macros$$ Data Validation - No Repitation of data & avoid blank

now chk... Regards, Manoj Kumar On Tue, Jan 18, 2011 at 5:36 PM, Amit Desai wrote: > There are no formula or data validation in file!! > > > > Best Regards, > > > > Amit Desai > > Assistant Manager, GKS > > Direct +91 22 6672 9855 > > Mobile +91 9867232534 > > amit.de...@bdoindia.co.in > > >

$$Excel-Macros$$ Re: How to send Lotus Notes e-mail using Excel VBA ?

Or you could just take the info direct from the manufacturer instead of second hand copied from a random blog. Here are the actual manuals from IBM in pdf format: LotusScript for Visual Basic Programmers: http://www.redbooks.ibm.com/redbooks/pdfs/sg244856.pdf COM together with Domino: http://www.

Re: $$Excel-Macros$$ Re: Concatenate Value Problem

Thanks Manoj. It’s really what I was looking for. But it is taking too much time to process the result. Is it possible to make it faster ?? My excel getting stuck/Not Responding, while I change/add the data or copy the formula in another cell.  Pls suggest. Thanks in advance. Regds, Manish Pa

Re: $$Excel-Macros$$ Fwd: need help

check the attachment On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote: > > Hello, > > Guys Need your help urgently > > please > > Regrads > > -- Forwarded message -- > From: lucky singh > Date: Tue, Jan 18, 2011 at 10:51 AM > Subject: need help > To: excel-macros@googleg

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 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 wrote: > > Date & Time > > 04/15/2009 06:02:35 >

Re: $$Excel-Macros$$ Query

Thanks for reply, now attached sheet is very clear. Aamir Shahzad On Tue, Jan 18, 2011 at 10:10 AM, ashish koul 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

Re: $$Excel-Macros$$ Array If

Thanks Ashish From: ashish koul 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

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

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 wrote: > check the attachment > > On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote: > >> >> Hello, >> >> Guys Need you