thank you Noorain ji !!
On Fri, Jul 20, 2012 at 8:45 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hi Sunita,
Try this one
*=SUBSTITUTE(TEXT(A1/B1,?/?),/,:)*
or
*=ROUND(A1/B1, 2) : ROUND(B1/A1,2)*
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
Dear all,
In this attached file there is data in one sheet 1, I want the same account
head amount from the sheet 1 to appear in sheet 2. Is it possible?. I tried
manually but takin time so if you all could help me on this.
Thank you very much for the cooperation.
Regards,
Sunita
--
--
FORUM
Dear Manoj,
Please see attached sheet, Change range as per State Name
Hope it help to you.
On Fri, Jul 20, 2012 at 11:24 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji.
I need 1st,2nd and 3rd Max sealing model name in every state...
Regard
Manoj
On Fri, Jul 20, 2012
Thank you soo much
I will try it
have a nice weekend
Sunita
On Fri, Jul 20, 2012 at 5:16 PM, Deba Ranjan drdeva...@gmail.com wrote:
Hi Sunita Ji,
PFA... might help you out your Query.
Thanks Regards,
*Deba Ranjan P*
On Fri, Jul 20, 2012 at 2:41 PM, सुनिता पौडेल
Dear All,
Greetings for the day...!
I have trying to convert Text to numbers (digits), and I h've apply the
formula (spellnumber), but this is not working. please help me to convert
this, is this possible to convert it with formula not with the help of VB
codeing.
Example :- Four
Dear Manoj,
Please see attachment without Array Function.
On Fri, Jul 20, 2012 at 5:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji,
Thanks for reply
Your formula is correct but can you do it without Erry..
Regard
Manoj
On Fri, Jul 20, 2012 at 4:08 PM, NOORAIN
“Please help me” is NOT a good subject line. Please describe your problem in
the body of your email and also attach file.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Manoj Kumar
Sent: Friday, July 20, 2012 12:43 AM
To: excel-macros@googlegroups.com
Manoj Please change reference of range, As per need otherwise it will show
same result.
On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Noorain Ji,
when i drag this formula it show same result...
On Fri, Jul 20, 2012 at 5:52 PM, NOORAIN ANSARI
Dear Champs,
kindly help me to create Dynamic Chart give some knowledge about the
tools and functions, define the tool names and how to use these tools
functions to create dynamic charts.
Thanks in advance..!
Thanks Regards
Ashish Kumar
--
--
FORUM RULES (986+ members already
Dear Ashish,
Please visit Chandoo website, it is good a resource to know regarding
dynamic chart.
Link is below
http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/
On Fri, Jul 20, 2012 at 6:14 PM, kumar.ashish861
kumar.ashish...@gmail.comwrote:
Dear Champs,
kindly help me to create
hi pascal,
i didn't understand this part of code...what should i write if i run this
macro in new workbook
Set wbIn = Workbooks(Book1 - Copy.xlsm)
'Set wsInOut = wbIn.Worksheets.Add: wsInOut.Name = sorted data ok2
Set wsInOut = wbIn.Worksheets(sorted data)
Set wsIn = wbIn.Worksheets(splitted
spellnumber function working only number to text only
On Fri, Jul 20, 2012 at 5:17 PM, Ashish kumar kumar.ashish...@gmail.comwrote:
Dear All,
Greetings for the day...!
I have trying to convert Text to numbers (digits), and I h've apply the
formula (spellnumber), but this is
Dear Noorain,
Thanks for the valuable feedback.
Thanks
Ashish kumar
On 20 July 2012 18:16, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Ashish,
Please visit Chandoo website, it is good a resource to know regarding
dynamic chart.
Link is below
Hi
Kindly advise how in the same chart data can be shown also depicting the
point of increase i.e., the increase in volume also being shown in the same
chart.
Thanks
Aruna
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
hey! good work...
i have a question
How to display the
*Format Shape Style Gallery*
**
**through VBA - i.e. in the lines of
*1. Application.Dialogs(xlDialogFormatFont).Show*
*2. Set Cmd = Application.CommandBars(1).FindControl _*
* (Type:=1, ID:=256, Recursive:=True)*
*
Dear Excel Experts,
I have attached a spreadsheet with dummy data. The first tab shows the
dummy information and the second tab shows what I would like it to look
like.
As I have over 100 of rows of data to do this for, I am looking to develop
some vba code to help accelerate the work.
Each row
Thanks a lot Noorain. :)
On Fri, Jul 20, 2012 at 9:52 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Indrajit,
PFA
On Fri, Jul 20, 2012 at 9:48 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Thanks Noorain, but please send me the Answer paper also. :)
On Fri, Jul 20,
17 matches
Mail list logo