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
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. Follow
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?
Im
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 are
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
To: excel-macros@googlegroups.com
Cc: soni.rajen...@gmail.com
Sent: Thu, August 19, 2010 10:08:27 AM
Subject: Re: $$Excel-Macr
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
CLOSED",AC$1),AA$1),Y$1),W$
Hi Kalyan,
Please use DATA>Filter>Custom Filter>Top Ten
Regards
Ramkesh
On Tue, Aug 17, 2010 at 11:21 AM, Kal xcel 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??
>
> Thanks in adv
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 wrote:
> 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
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
To: MS EXCEL AND VBA MACROS
Sent: Wed, August 18, 2010 8:13:21 PM
Subject: Re: $$Excel-Macros
Dave,
Can I trouble you for an example? I'm not sure how the COUNTIF would work
here. Thanks.
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Wed, August 18, 2010 7:34:17 PM
Subject: RE: $$Excel-Macros$$ Unique id to name
Hi,
You can use CO
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: excel-macro
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.
Anyways
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
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 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 simple macro which
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 wrote:
> Hi
Dear Sumit,
This code is not converting Lac values.
Please help..
Thanks,
Noorain
On Mon, Aug 9, 2010 at 1:18 PM, SUMIT VYAS wrote:
>
>1. Start Microsoft Excel.
>2. Press ALT+F11 to start the Visual Basic Editor.
>3. On the *Insert* menu, click *Module*.
>4. Type the following
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
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
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
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 wrote:
> Hi excel gurus,
>
> I need to summarize items appearing in a column. I have attached a
> sheet for your reference.
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 wrote:
> Alex,
>
> This a "Text to Columns" function. Select the column, use the Text to
> Columns/ delimited fu
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 wrote:
> Alex,
>
> This a "Text to Columns" function. Select the column, use the Text to
> Columns/ delimited fu
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
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 t
24 matches
Mail list logo
