Hi
Please find attached the solution.
--I have applied data validation on the range D3:D9.
--Here the keyword used is soni
--If the cell contains the keyword soni it will shows an error.
--You can customise the error message according to your requirement.
--if the cell
You can use Mid and RIGHT formula to take the required data
See attached Excel for the details
With Regards,
Hitesh
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Alexander Cargill
Sent: Wednesday, August 18, 2010 5:21 PM
Hi Alex,
Please check attached sheet..I think Your Problem has been solved.
Thanks,
Noorain Ansari
E-mail Id :noorain.ans...@gmail.com
On Wed, Aug 18, 2010 at 7:50 AM, Michael Hayes m99pan...@gmail.com wrote:
Alex,
This a Text to Columns function. Select the column, use the Text to
I have Done it with formula Check it if you have any other query
Arif Mansoorali Massani
Bhavnagar
Gujarat, India
M. +91-9913382099
On Wed, Aug 18, 2010 at 8:20 PM, Michael Hayes m99pan...@gmail.com wrote:
Alex,
This a Text to Columns function. Select the column, use the Text to
Hi
I think you have forgetten to attach the sheet, or the sheet was not
inserted properly, pls resend.
Regards
Rajender Soni | 750 322 55 50
On Aug 18, 10:51 am, dinoabeer umarab...@googlemail.com wrote:
Hi excel gurus,
I need to summarize items appearing in a column. I have attached a
Hi.
i got a userform with 3 labels. and sheet5 column a down names. b down
the birthdays of each person. label1 i need everyone that has birthday
today. lable2 i need every one with birthday tomorow and finaly label3
i need all the names of people with birthday day after tomorow...
thanx!
PHILLIP
Two solutions.
1. through a function
If the data is in Column A, Use this function in column B
=MID(A1,FIND((,A1)+1,7)
2. Using Commands (Data - Text to Columns
a. Select the data
b. Go to Data - Text to Columns
c. Select Delimited Option and
Try using the formula iserror along with the If formula.
here is a sample...
=if(iserror(your formula),a,your formula)
where, a = the value you want instead of the NA.
What it will do is, check if the formula is resulting in value or
returning error, if error comes, it will give the defined out
Dear Sumit,
This code is not converting Lac values.
Please help..
Thanks,
Noorain
On Mon, Aug 9, 2010 at 1:18 PM, SUMIT VYAS svyas0...@gmail.com wrote:
1. Start Microsoft Excel.
2. Press ALT+F11 to start the Visual Basic Editor.
3. On the *Insert* menu, click *Module*.
4. Type
As dave said, there is a formula in column
Click on the formula.
Carefully copy the formula except '=' symbol
type the following in the same cell.
=iserror(FORMULA, 0, FORMULA)
Replace the FORMULA with the copied formula
Regards,
Kishan Reddy, K
On Aug 19, 9:27 am, Dave Bonallack
Why can't you use Copy paste command.
Why you require a macro for this.
Regards,
Kishan Reddy, K
On Aug 18, 9:04 pm, kamal shah kamal...@gmail.com wrote:
Hi group
I have piece of XML for example below which i need to repeat it for 1
times
May I request one of expert to develop a
You're welcome
Regards - Dave.
Date: Wed, 18 Aug 2010 14:28:57 +0530
Subject: Re: $$Excel-Macros$$ Extract Only Mobile Numbers from the
strings--Urgent
From: venkat1@gmail.com
To: excel-macros@googlegroups.com
CC: davebonall...@hotmail.com
Dear Dave,
Thanks a lot
Best Regards,
Venkat
Hi Kalyan,
Looks like you need to repeat the same formula twice in the same cell.
Once with Distributor and once with Super stockist. Ya, do not forget
to adjoin the formula's with plus in between. ;)
I don't understand one thing though, why don't you use Pivot. Its
really easy with that.
The NA is not an error from a formula. Attached is detail of what I am
looking for. Thanks in advance!
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack
Sent: Thursday, August 19, 2010 12:27 AM
To:
Unfortunately a puvot table won't work here as I need the formula on each line
in the worksheet. Otherwise your suggestion would be a great one.
From: Soni.Rajender soni.rajen...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Wed,
This should help.
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey Company
http://www.facebook.com/Harmeeet
On Thu, Aug 19, 2010 at 7:18 PM, None n8dine4ma...@yahoo.com wrote:
Unfortunately a puvot table won't work here as I need the formula on each
line in the worksheet. Otherwise your
Hi Kalyan,
Please use DATAFilterCustom FilterTop Ten
Regards
Ramkesh
On Tue, Aug 17, 2010 at 11:21 AM, Kal xcel kalx...@gmail.com wrote:
Dear experts,
I have SAP sales data, how to get top 10 distributor frm that huge data.
One distributor billed many times. Is there any mechanism??
Beckie or is it Becky?
Im hoping someone has a more elegant solution than I do...the only way
I know how to do it is to create three additional columns.
In cell AZ3 I put this formula
=IF(R3=NA,IF(T3=NA,IF(V3=NA,IF(X3=NA,IF(Z3=NA,IF(AB3=NA,IF(AD3=NA,NOT
Thanks so much for your help. This works and is the last piece of a workbook I
was putting together. Thank you!
From: Harmeet Singh harmeet.hew...@gmail.com
To: excel-macros@googlegroups.com
Cc: soni.rajen...@gmail.com
Sent: Thu, August 19, 2010 10:08:27 AM
Hello,
I am using group's member code to convert text (like: 1-2,3,6) to
values (1,2,3,6).
Imput is in Col A and values are writen from ColB.
I am trying to fill output array with values
but it dows not work.
Can you help me ?
Thank you
-
Sub txt2arr()
'Assuming that all the texts
Thanks, Michael!
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Michael Hayes
Sent: Thursday, August 19, 2010 2:37 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Need help with a formula
Beckie or is it Becky?
Dear Experts,
I have many data in excel sheet and want to convert the same in Lakh.
Kindly help me how can it be divided it through single formula.
Regards
OPS
--
--
Some important links for excel users:
1.
Please find attached solution.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Kal xcel
Sent: Wednesday, August 18, 2010 6:49 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Etracting sales data as per desired
23 matches
Mail list logo