-- Forwarded message --
From: Sachin Harale
Date: Thu, 23 Sep 2010 10:30:22 +0530
Subject: RE: $$Excel-Macros$$ Excel quiz
To: excel-macros@googlegroups.com
Cc: sachin.har...@gmail.com
Dear Ayush,
Please find attached answer to your Quiz.
Regards
Sachin N Harale
-Original M
-- Forwarded message --
From: Sachin Harale
Date: Thu, 23 Sep 2010 10:30:22 +0530
Subject: RE: $$Excel-Macros$$ Excel quiz
To: excel-macros@googlegroups.com
Cc: sachin.har...@gmail.com
Dear Ayush,
Please find attached answer to your Quiz.
Regards
Sachin N Harale
-Original M
-- Forwarded message --
From: Sachin Harale
Date: Thu, 23 Sep 2010 10:30:22 +0530
Subject: RE: $$Excel-Macros$$ Excel quiz
To: excel-macros@googlegroups.com
Cc: sachin.har...@gmail.com
Dear Ayush,
Please find attached answer to your Quiz.
Regards
Sachin N Harale
-Original M
Dear member,
The winner of this quiz is *ROBERTO MENSA* whose answer and timing is
perfect among all.
Congrats Roberto...Keep it up and thanks.
Regards,
Ayush Jain
On Wed, Sep 22, 2010 at 7:43 PM, Shreedar Pandurangaiah <
shreedar.panduranga...@gmail.com> wrote:
> Hi Ayush, Here are my answers
For that u go to reginal and language option through control panel, in
language tab just select default input language(arabic),press ok. now
onwards whenever u start your application it will type arabic language
automatically. and uhave to select other language by pressing alt+shift
On Wed, Sep 22
Hi Noorain,
Correct me if I am wrong. What you are trying to do in this function
is to bring up the relevant data from 3 different worksheets. In the
event, that one worksheet does not have the data, the formula will
cycle through to the other worksheet. However, using the OR function
here will no
Hi All,
How to unlock a password that is set for an excel file?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
I would appreciate some help/guidance for doing the following. I
would like to create a userform, ( which is triggered by an action
taken in a cell on another sheet called test1 in the workbook), with
five variables each with it’s own checkbox; the checkbox information
will be a 1 or 0 and will be
Hi Vijay
I want the format as it is in the notepad eg if there is 2 spacebar distance
between the columns , and we transfer that to excel it should take the same
distance so that if we want to save this excel to notepad again ( after
calculation) the same distance of space ber should be maintained
I have on my computer Arabic and English language
And I can change between these two language by pressing " Alt +Shift"
But I want when running my form which contains textbox
The curser on textbox is Arabic automatically without pressing " Alt
+Shift"
From: excel-macros@googlegroups.
Hi Saurabh,
Attached is the solution.
Regards,
Dhananjay Pinjan
(Contact No. 08866078062)
On Wed, Sep 22, 2010 at 8:19 PM, Saurabh Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Dear All,
>
>
>
> I have attached a sheet wherein I want the result by a formula that I get
> the number star
You could use:
=MID(A2,FIND("80",A2),8)
this would only work if:
"80" only appears once
the # is 8 characters long
Paul
>
>From: Saurabh Patel
>To: excel-macros@googlegroups.com
>Sent: Wed, September 22, 2010 10:49:48 AM
>Subject: $$Excel-Macros$$ Extracting Number from Cell
>
>
>Dear All,
>
Dear All,
I have attached a sheet wherein I want the result by a formula that I get
the number starting from "80" in another raw. Result which is required is
been highlighted in yellow.
Regards,
Saurabh Patel
DISCLAIMER:The information contained in this electronic message and in any
Hi Ayush, Here are my answers...
If B and C is given A = Bth root of C
If A and C is given B = Log(C,A)
If A and B is given C = A ^ B
Thanks,
Shreedar P.
On Wed, Sep 22, 2010 at 5:55 PM, Ayush wrote:
>
> Dear Group,
>
> A small quiz for you...let see who answers it first and correct
>
> A rai
2010/9/22 Ayush
>
> Dear Group,
>
> A small quiz for you...let see who answers it first and correct
>
> A raise to the power B equals C
> example 2 raise to the power 5 equals 32
>
> Now you have to tell me how would you calculate the third variable if
> you have only two variables ...
>
> Calcul
Dear All,
I want to use VLookup function for more than one sheet at a time. But I am
unable to find output.
Please see attached Sample sheet.
Thanks & regards,
Noorain Ansari
--
--
Some important links for excel us
power means power function...
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 22 September 2010 18:15, Upendra Singh Sengar <
upendrasinghsen...@gmail.com> wrote:
> Mathmatically if a raise to power b is c
> then
> a=C raise to power 1/B
> b=C raise to po
Dear Maureeze,
Solution of your Problem is :
1. A1=concatenate("A",text("1","1"))
2. A1="A"&TEXT("1","1")
Thanks & regards,
Noorain Ansari
On Wed, Sep 22, 2010 at 6:03 PM, Maureeze wrote:
> Dear all,
>
> I have been looking for a solution for this problem for a while and i
>
Mathmatically if a raise to power b is c
then
a=C raise to power 1/B
b=C raise to power 1/A
but power is not working is excel properly...
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 22 September 2010 17:55, Ayush wrote:
>
> Dear Group,
>
> A small
Hi
Use indirect function
=INDIRECT("A"&1)
I hope it helps.
regards,
Ayush
On Wed, Sep 22, 2010 at 6:03 PM, Maureeze wrote:
> Dear all,
>
> I have been looking for a solution for this problem for a while and i
> hope that someone out there can help me.
>
> How do i exececute the following :
Dear all,
I have been looking for a solution for this problem for a while and i
hope that someone out there can help me.
How do i exececute the following : =A&1
I want A and 1 joined together and then execute that as =A1 and show
me the value of what is in A1
Thank you,
ps : This is an simpl
Dear Group,
A small quiz for you...let see who answers it first and correct
A raise to the power B equals C
example 2 raise to the power 5 equals 32
Now you have to tell me how would you calculate the third variable if
you have only two variables ...
Calculate A if B& C is given
Calculate B i
Hi Praveen,
Can you be more specific with your question and if possible send a sample
sheet in response to this email with some dummy data and explaination of the
required result.
Regards,
Andy
On Wed, Sep 22, 2010 at 4:52 PM, praveen kumar wrote:
> hello
> Dear Sir,
> this is praveen
> i have
hello
Dear Sir,
this is praveen
i have some problem's please sort out my problem's
i want use in v lookup function isna,iserror,isblank,and if, and
nested if
how can i
please help me
--
--
Some important links for e
If you need the more shortcut then I can develop a macro for that
On Wed, Sep 22, 2010 at 4:45 PM, Sanjoy Nath wrote:
> Just open the notepad and find and replace all the spaces with comma
> and after that close the file
> and rename the file extension from .txt to .csv
>
>
> see the magic
>
>
Just open the notepad and find and replace all the spaces with comma
and after that close the file
and rename the file extension from .txt to .csv
see the magic
reverse process to get the thing in txt again
ITS WILL WORK GREAT
2010/9/22 Abhidha Dixit
> Dear ALL
>
> Please help how can i tr
Dear all,
I have a question about excel file protection. I would like to know if
it is possible to open an excel file with a password for protection
for opening via a msdos command.
Something like:
c:\"MyFile.xls" (password for opening)
The goal is to open it automatically with the windows tasks
Hello,
You an change the keyboard language by going to the control panel and
selecting the language date & time option.You can select Arabic language and
then press OK.Some languages will not be installed in your computer. If they
are not installed you have to install them before starting you have
Hello
You can copy the text in to excel and to break excel in the format as it is
in not pad you have to you text to columns in the review menu of menu
bar.If you text is separated by comma or colon or space or other delimiters
you can choose delimited option and choose the symbol that separates
Please Check this
2010/9/22 Abhidha Dixit
> Dear ALL
>
> Please help how can i transpose the data from notepad to excel with the
> similar colomn gap so that when we copy this again to notebook i shall get
> the data with the samilar spaces
>
> thanks
>
> --
>
> ---
30 matches
Mail list logo