Fwd: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread Sachin Harale 
-- 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 Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ayush
Sent: Wednesday, September 22, 2010 5:55 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Excel quiz


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 if A & C is given

Calculate C if A & B is given

You have to provide excel formula only...no VBA allowed

Regards,
Ayush Jain
Group Manager

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe

Disclaimer: This e-mail contains privileged information or information
belonging to IDBI Ltd and is intended solely for the addressee/s.
Access to this email by anyone else is unauthorized. Any copying
(whole or partial) or further distribution beyond the original
recipient is not intended, and may be unlawful. The recipient
acknowledges that IDBI Ltd is unable to exercise control or ensure or
guarantee the integrity of the contents of the information contained
in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and are
not binding on IDBI Ltd. E-mails are susceptible to alteration and
their integrity cannot be guaranteed. IDBI Ltd does not accept any
liability for any damages caused on account of this e-mail. If you
have received this email in error, please contact the sender and
delete the material from your computer.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Fwd: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread Sachin Harale 
-- 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 Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ayush
Sent: Wednesday, September 22, 2010 5:55 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Excel quiz


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 if A & C is given

Calculate C if A & B is given

You have to provide excel formula only...no VBA allowed

Regards,
Ayush Jain
Group Manager

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe

Disclaimer: This e-mail contains privileged information or information
belonging to IDBI Ltd and is intended solely for the addressee/s.
Access to this email by anyone else is unauthorized. Any copying
(whole or partial) or further distribution beyond the original
recipient is not intended, and may be unlawful. The recipient
acknowledges that IDBI Ltd is unable to exercise control or ensure or
guarantee the integrity of the contents of the information contained
in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and are
not binding on IDBI Ltd. E-mails are susceptible to alteration and
their integrity cannot be guaranteed. IDBI Ltd does not accept any
liability for any damages caused on account of this e-mail. If you
have received this email in error, please contact the sender and
delete the material from your computer.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Fwd: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread Sachin Harale 
-- 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 Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ayush
Sent: Wednesday, September 22, 2010 5:55 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Excel quiz


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 if A & C is given

Calculate C if A & B is given

You have to provide excel formula only...no VBA allowed

Regards,
Ayush Jain
Group Manager

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe

Disclaimer: This e-mail contains privileged information or information
belonging to IDBI Ltd and is intended solely for the addressee/s.
Access to this email by anyone else is unauthorized. Any copying
(whole or partial) or further distribution beyond the original
recipient is not intended, and may be unlawful. The recipient
acknowledges that IDBI Ltd is unable to exercise control or ensure or
guarantee the integrity of the contents of the information contained
in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and are
not binding on IDBI Ltd. E-mails are susceptible to alteration and
their integrity cannot be guaranteed. IDBI Ltd does not accept any
liability for any damages caused on account of this e-mail. If you
have received this email in error, please contact the sender and
delete the material from your computer.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Answer-Quiz.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread ayush jain 
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...
>
> 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 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 if A & C is given
>>
>> Calculate C if A & B is given
>>
>> You have to provide excel formula only...no VBA allowed
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Best regards,
Ayush Jain

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ change keyboard language

2010-09-22 Thread sudhir kumar 
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, 2010 at 9:55 PM, عمر  wrote:

> 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.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR
> *Sent:* Wednesday, September 22, 2010 11:38 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ change keyboard language
>
>
>
> 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 to
> install them
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Regards,
>
> P.VIJAY KUMAR
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Regards-
Sudhir Kumar
Design Engineer,
Conceptia Software Technologies Pvt. Ltd.
Email id-sudhir.p...@gmail.com,

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: VLookup Query.??????................Plz Help

2010-09-22 Thread Cloud 
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 not serve that purpose ,what you need to use instead is the
IF function.

=IF(NOT(ISERROR(VLOOKUP(B3,Raw_Data1!$A$2:$F
$50,2,FALSE))),VLOOKUP(B3,Raw_Data1!$A$2:$F
$50,2,FALSE),IF(NOT(ISERROR(VLOOKUP(B3,Raw_Data2!$A$2:$F
$50,2,FALSE))),VLOOKUP(B3,Raw_Data2!$A$2:$F
$50,2,FALSE),VLOOKUP(B3,Raw_Data3!$A$2:$F$50,2,FALSE)))

Try using the formula above and everything should fall into place.

Regards,
Cloud

On Sep 22, 9:23 pm, NOORAIN ANSARI  wrote:
> 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
>
>  VLookup Query for more than One Sheet.xls
> 52KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ password

2010-09-22 Thread Skanda 
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 group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ UserForm

2010-09-22 Thread mikeb 
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 placed / saved / copied into separate
columns “M through Q” , with the new data being added to row below
each time the userform is triggered the information is placed on a
different sheet test2 cloumns “M through Q”in the same workbook.  I
would like the userform to have an OK button on it so once the user is
finished choosing variable 1 thru 5 or all five,and licks on the OK
button the userform  will close.

In addition to capturing the userform information information I would
like to then copy three other cells on the same row in sheet test1 to
be copied to the same row and dedicated columns in sheet test2, that
we are placing the userform information.

Thank you,

MikeB

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

2010-09-22 Thread Abhidha Dixit 
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

My problem is if I transfer the data from this notepadd to excel and again
if I want to save the same data from excel to notepad then the previous
alignment gets disturbed

hope this is clear will be greatful if this could resolved

On Wed, Sep 22, 2010 at 12:20 PM, P.VIJAYKUMAR  wrote:

> 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 text
> and  excel will break the text into columns wherever the delimiter is there.
> If there is no such delimiter is there the you can choose fixed option.In
> fixed option you can place the arrows where you want to  break the text into
> columns and press the next button and once it is finished excel will break
> the text into columns where you placed the arrows.But, select the first
> column where you copied the text to break into columns or otherwise it will
> not work properly. For more information see. this
>
>
>
>  Split names by using the Convert Text to Columns Wizard
>  [image: Show All]Show 
> All
> [image: Hide All]Hide 
> All
>
> Use the Convert Text to Columns Wizard to separate simple cell content,
> such as first names and last names, into different columns.
>   *Full name*   *First name*   *Last name*   Syed Abbas   Syed
> Abbas Molly Dempsey   Molly Dempsey Lola Jacobsen   Lola Jacobsen 
> Diane
> Margheim   Diane Margheim
>
> Depending on your data, you can split the cell content based on a
> delimiter, such as a space or a comma, or based on a specific column break
> location within your data.
> What do you want to do?
> --
>
>- Split content based on a 
> delimiter
>- Split cell content based on a column 
> break
>
> --
>  Split content based on a delimiter
>
> Use this method if your names have a delimited format, such as "First_name
> Last_name" (where the space between First_name and Last_name is the
> delimiter) or "Last_name, First_name" (where the comma is the delimiter).
> Split space-delimited content
>
> To complete these steps, copy the following sample data to a blank
> worksheet.
>
> [image: Hide]How to copy an 
> example
>
>1. Create a blank workbook or worksheet.
>2. Select the example in the Help topic.
>
> * Note *  Do not select the row or column headers.
>
> [image: Selecting an example from Help]
>
>1. Press CTRL+C.
>2. On the worksheet, select cell A1, and then press CTRL+V.
>3. To switch between viewing the results and viewing the formulas that
>return the results, press CTRL+` (grave accent), or on the *Formulas*tab, 
> in the
>*Formula Auditing* group, click the *Show Formulas* button.
>
>   *1* *2* *3* *4*
>*A* Syed Abbas Molly Dempsey Lola Jacobsen Diane Margheim
>
>1. Select the range of data that you want to convert.
>2. On the *Data* tab, in the *Data Tools* group, click *Text to Columns
>*.
>
>
>1. In Step 1 of the Convert Text to Columns Wizard, click *Delimited*,
>and then click *Next*.
>2. In Step 2, select the *Space* check box, and then clear the other
>check boxes under *Delimiters*.
>
> The *Data preview* box shows the first and last names in two separate
> columns.
>
> [image: Text to Columns Wizard - Step 2 of 3]
>
>1. Click *Next*.
>2. In Step 3, click a column in the *Data preview* box, and then click
>*Text* under *Column data format*.
>
> Repeat this step for each column in the *Data preview* box.
>
>1. If you want to insert the separated content into the columns next to
>the full name, click the icon to the right of the *Destination* box,
>and then select the cell next to the fi

RE: $$Excel-Macros$$ change keyboard language

2010-09-22 Thread عمر 
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.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of P.VIJAYKUMAR
Sent: Wednesday, September 22, 2010 11:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ change keyboard language

 

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 to
install them  

 

 

 

 

 

 

 

Regards,

P.VIJAY KUMAR

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 7000 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Extracting Number from Cell

2010-09-22 Thread Dhananjay Pinjan 
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 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 
> attachments to this message is
>confidential, legally privileged and intended only for the person 
> or entity to which this electronic
>message is addressed. If you are not the intended recipient, 
> please notify the system manager and
>you are hereby notified that any distribution, copying, review, 
> retransmission, dissemination or
>other use of this electronic transmission or the information 
> contained in it is strictly prohibited.
>Please accordingly also note that any views or opinions presented 
> in this email are solely those of
>the author and may not represent those of the Company or bind the 
> Company. This message has been
>scanned for viruses and dangerous content by Mail Scanner, and is 
> believed to be clean.
>The Company accepts no liability for any damage caused by any 
> virus transmitted by this email.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Data(1) ans by dppinjan.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Extracting Number from Cell

2010-09-22 Thread Paul Schreiner 
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,
> 
>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 
>attachments to this message isconfidential, legally privileged and 
>intended only for the person or entity to which this electronic
>message is addressed. If you are not the intended recipient, please notify the 
>system manager and you are hereby notified that any distribution, 
>copying, review, retransmission, dissemination or other use of 
>this 
>electronic transmission or the information contained in it is strictly 
>prohibited.Please accordingly also note that any views or opinions 
>presented in this email are solely those of the author and may not 
>represent those of the Company or bind the Company. This message has been  
>   
>scanned for viruses and dangerous content by Mail Scanner, and is believed to 
>be 
>clean. The Company accepts no liability for any damage caused by 
>any 
>virus transmitted by this email. -- 
>
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>HELP US GROW !!
> 
>We reach over 7000 subscribers worldwide and receive many nice notes about the 
>learning and support from the group.Let friends and co-workers know they can 
>subscribe to group at http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Extracting Number from Cell

2010-09-22 Thread Saurabh Patel 
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 
attachments to this message is
   confidential, legally privileged and intended only for the person or 
entity to which this electronic
   message is addressed. If you are not the intended recipient, please 
notify the system manager and 
   you are hereby notified that any distribution, copying, review, 
retransmission, dissemination or 
   other use of this electronic transmission or the information 
contained in it is strictly prohibited.
   Please accordingly also note that any views or opinions presented in 
this email are solely those of 
   the author and may not represent those of the Company or bind the 
Company. This message has been 
   scanned for viruses and dangerous content by Mail Scanner, and is 
believed to be clean. 
   The Company accepts no liability for any damage caused by any virus 
transmitted by this email.
   

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Data.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread Shreedar Pandurangaiah 
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 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 if A & C is given
>
> Calculate C if A & B is given
>
> You have to provide excel formula only...no VBA allowed
>
> Regards,
> Ayush Jain
> Group Manager
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread roberto mensa 
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 ...
>
> Calculate A if B& C is given
>

=C3^(1/B3)



>
> Calculate B if A & C is given
>


=LOG(C7;A7)



>
> Calculate C if A & B is given
>


=A1^B1


>
> You have to provide excel formula only...no VBA allowed
>
> Regards,
> Ayush Jain
> Group Manager
>


regards
r



>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ VLookup Query.??????................Plz Help

2010-09-22 Thread NOORAIN ANSARI 
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 users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


VLookup Query for more than One Sheet.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread Upendra Singh Sengar 
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 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 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 if A & C is given
>>
>> Calculate C if A & B is given
>>
>> You have to provide excel formula only...no VBA allowed
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Concatenate

2010-09-22 Thread NOORAIN ANSARI 
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
> 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 simplified question, since i actually have =gllinks|
> Mkt!'/BAS,TheoOpenPrice' to execute in excel and i want to change /BAS
> into different texts like /DBK or /DTE.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks & regards,
Noorain Ansari

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread Upendra Singh Sengar 
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 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 if A & C is given
>
> Calculate C if A & B is given
>
> You have to provide excel formula only...no VBA allowed
>
> Regards,
> Ayush Jain
> Group Manager
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Concatenate

2010-09-22 Thread ayush jain 
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 : =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 simplified question, since i actually have =gllinks|
> Mkt!'/BAS,TheoOpenPrice' to execute in excel and i want to change /BAS
> into different texts like /DBK or /DTE.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Best regards,
Ayush Jain

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Concatenate

2010-09-22 Thread Maureeze 
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 simplified question, since i actually have =gllinks|
Mkt!'/BAS,TheoOpenPrice' to execute in excel and i want to change /BAS
into different texts like /DBK or /DTE.


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel quiz

2010-09-22 Thread 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 ...

Calculate A if B& C is given

Calculate B if A & C is given

Calculate C if A & B is given

You have to provide excel formula only...no VBA allowed

Regards,
Ayush Jain
Group Manager

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ use in vlookup isna and isblank iserror

2010-09-22 Thread Aindril De 
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 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 excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ use in vlookup isna and isblank iserror

2010-09-22 Thread praveen kumar 
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 excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

2010-09-22 Thread Sanjoy Nath 
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
>
> 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 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
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> Your Sincerely
> Sanjoy Nath
> Engineer
> EOL Gurgaon
> EOL/M/NZ/Engg.Dept.(Haryana Division)
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

2010-09-22 Thread Sanjoy Nath 
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 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
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Open a protected excel file via a DOS command

2010-09-22 Thread EvilButterfly 
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 schedule
via a dos command.
If you have another solution that would be cool too.

Thanks in advance.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ change keyboard language

2010-09-22 Thread P.VIJAYKUMAR 
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 to
install them








Regards,
P.VIJAY KUMAR

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

2010-09-22 Thread P.VIJAYKUMAR 
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 text
and  excel will break the text into columns wherever the delimiter is there.
If there is no such delimiter is there the you can choose fixed option.In
fixed option you can place the arrows where you want to  break the text into
columns and press the next button and once it is finished excel will break
the text into columns where you placed the arrows.But, select the first
column where you copied the text to break into columns or otherwise it will
not work properly. For more information see. this



Split names by using the Convert Text to Columns Wizard
 [image: Show All]Show
All
[image: Hide All]Hide
All

Use the Convert Text to Columns Wizard to separate simple cell content, such
as first names and last names, into different columns.
  *Full name*   *First name*   *Last name*   Syed Abbas   Syed
Abbas Molly
Dempsey   Molly Dempsey Lola Jacobsen   Lola Jacobsen Diane Margheim
  Diane Margheim

Depending on your data, you can split the cell content based on a delimiter,
such as a space or a comma, or based on a specific column break location
within your data.
What do you want to do?
--

   - Split content based on a
delimiter
   - Split cell content based on a column
break

--
 Split content based on a delimiter

Use this method if your names have a delimited format, such as "First_name
Last_name" (where the space between First_name and Last_name is the
delimiter) or "Last_name, First_name" (where the comma is the delimiter).
Split space-delimited content

To complete these steps, copy the following sample data to a blank
worksheet.

[image: Hide]How to copy an
example

   1. Create a blank workbook or worksheet.
   2. Select the example in the Help topic.

* Note *  Do not select the row or column headers.

[image: Selecting an example from Help]

   1. Press CTRL+C.
   2. On the worksheet, select cell A1, and then press CTRL+V.
   3. To switch between viewing the results and viewing the formulas that
   return the results, press CTRL+` (grave accent), or on the
*Formulas*tab, in the
   *Formula Auditing* group, click the *Show Formulas* button.

  *1* *2* *3* *4*
   *A* Syed Abbas Molly Dempsey Lola Jacobsen Diane Margheim

   1. Select the range of data that you want to convert.
   2. On the *Data* tab, in the *Data Tools* group, click *Text to Columns*.


   1. In Step 1 of the Convert Text to Columns Wizard, click *Delimited*,
   and then click *Next*.
   2. In Step 2, select the *Space* check box, and then clear the other
   check boxes under *Delimiters*.

The *Data preview* box shows the first and last names in two separate
columns.

[image: Text to Columns Wizard - Step 2 of 3]

   1. Click *Next*.
   2. In Step 3, click a column in the *Data preview* box, and then click *
   Text* under *Column data format*.

Repeat this step for each column in the *Data preview* box.

   1. If you want to insert the separated content into the columns next to
   the full name, click the icon to the right of the *Destination* box, and
   then select the cell next to the first name in the list (B2, in this
   example).

[image: Destination of splitted contents]

* Important *  If you do not specify a new destination for the new columns,
the split data will replace the original data.

   1. Click the icon to the right of the *Convert Text to Columns Wizard*.

[image: Text to Columns Wizard Step 3 of 3]

   1. Click *Finish*.

[image: Top of 
Page]
Top
of 
Page
 Split comma-delimited content

To comple

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

2010-09-22 Thread Jai 
 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
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks For Mail.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


SGfrchg.xls
Description: MS-Excel spreadsheet