Hi Ashish,
See if this example workbook from Debra Dalgleish and Dave Peterson helps
you out:
http://contextures.com/exceldataentryupdateform.html
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Bhalara
Sent: Friday, March 16, 2012 6:07
Hello!
I'm positive I'm overlooking the simple solution, but I need a formula that
returns a true/false yes/no value (or something like that) after
checking if a cell's value is contained in a given list. In other words,
Q: Is Cell A (Widget) contained in list B Stock Items? A: Yes/no,
=IFERROR(MATCH(E6,G6:G12,0)0,FALSE)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Scruffy Huffy
Sent: Mar/Sat/2012 05:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ An EASY One: I Need a formula that checks if a
value is part of a list.
Perfect...Thanks much!
On Saturday, March 17, 2012 8:16:33 AM UTC-4, Rajan_Verma wrote:
=IFERROR(MATCH(E6,G6:G12,0)0,FALSE)
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Scruffy Huffy
*Sent:* Mar/Sat/2012 05:29
*To:*
What we have here is “a failure to look in the help index”
excel 101
=LOOKUP(E6,G5:G12)
=MATCH(E6,G5:G12)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Scruffy Huffy
Sent: Saturday, March 17, 2012 6:59 AM
To: excel-macros@googlegroups.com
Subject:
Hi All,
Im using the following code for sending mails automatically via
outlook. The problem here is in outlook 2003 the attached images are
displaying properly in the body of the mail. But in outlook 2007
instead of image i am getting red cross symbol. i tried lot for this.
But nothing is
Aamir,
Thx for both gr8 people. ( Norain / Aamir )
Rgds,
Iqbal Shaikh
On 17 March 2012 10:10, Aamir Shahzad aamirshahza...@gmail.com wrote:
Another soluction
Aamir Shahzad
On Fri, Mar 16, 2012 at 11:44 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
On Fri, Mar 16, 2012 at
Select the three columns starting from the 8th Row, and Column F, and use
this conditional
=AND(ISNUMBER(F8),SUM($F8:$H8)2)
Regards
Sam Mathai Chacko
On Sat, Mar 17, 2012 at 11:52 AM, Pravin Kumar pravin.si...@gmail.comwrote:
Hi folk
I want to add validation for cell (3 cell) with two
Please Use this:
Public Function AddCommentMap( _
Optional sAddress As String, _
Optional sAddress2 As String, _
Optional lZoom As Long = 12, _
Optional lHeight As Long = 512, _
Optional lWidth As Long = 512, _
Optional bVisible As Boolean = False, _
Optional sText = )
'Add or
Thanks
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sam Mathai Chacko samde...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 17 Mar 2012 22:34:31
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ TWO
Hi Aju,
I didn't open your file, but I think you should be aqble to do the
following.
Create a sub in a standard module, such as:
Sub ShowForm ()
FormName.Show
End Sub
Then in your OnAction event, specify the above procedure.
Asa
-Original Message-
From:
Don,
You would think...I don't like the onboard help, but I did Google it and
looked for sometime by myself. In retrospect, there's no one function
that works.
Neither the LOOKUP or the MATCH give the result I needed. Rajan's
adaptation is simple and does what I need. I just thought there
Good Day Asa
Are you able to assist with this for me. Would be greatly appreciately.
Thanks
Charlie
On Wed, Mar 14, 2012 at 9:45 AM, Cab Boose swch...@gmail.com wrote:
Hi Asa
At the moment the H1 setting makes no difference. The sheet works like
normal with the setting at activate or
13 matches
Mail list logo