$$Excel-Macros$$ Re: excel certificate course

[shashi]

Dear Karthikeyan


There are numerous online institute providing the online teaching and
conduct certificate examinations.

I am sending u the one link for that.

They must charge u in dollar somewhere near about $50.

http://www.technologyed.com/teach.php

Thanks
Regards
Shashi Ranjan

On Nov 15, 4:10 pm, karthikeyan 
wrote:
> Hi all,
>
> I am from chennai.If any body knows about online excel certificate
> course.Pls let me know.
>
> txs
> karthik

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Fwd:Urgent. I have a Problem.Pls help

[Aindril De]

Dear Hemant
There is nothing written in the attached sheet.

Please resend
Regards,
Andy

On Mon, Nov 16, 2009 at 12:55 AM, hemant shah wrote:

> Hi Mr-excel,
>
> Pls help me on my query. Have a look at attached sheet
>
>
> -- Forwarded message --
> From: hemant shah 
> Date: Thu, Nov 12, 2009 at 10:46 AM
> Subject: $$Excel-Macros$$ Problem.Pls help
> To: excel-macros@googlegroups.com
>
>
> Hi All,
>
> Pls help me on my problem.
> I have explained everything in the attached excel.
>
> Thanks in advance for you help.
>
> Regards,
> Hemant Shah
>
>
> -- Forwarded message --
> From:  
> Date: Wed, Nov 11, 2009 at 11:48 PM
> Subject: Create a Puzzle...
> To: hemanthin...@gmail.com
>
>
> Hi,
>
>
>
>
> Please do not print this email unless it is absolutely necessary.
>
> The information contained in this electronic message and any
> attachments to this message are intended for the exclusive use of the
> addressee(s) and may contain proprietary, confidential or privileged
> information. If you are not the intended recipient, you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately and destroy all copies of this message and any
> attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of
> viruses. The company accepts no liability for any damage caused by any
> virus transmitted by this email.
>
> www.wipro.com
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes
> about the learning and support from the group. Our goal is to have
> 10,000 subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: text and date in one cell

[Dilip Pandey]

You are always welcome..!!

Best Regards,
-- 
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On Sun, Nov 15, 2009 at 9:09 PM, Prashanth Banneni wrote:

> Hi Dilip,
>
> Thanks a lot, You are a genius
> Thanks
> Prashanth
>
>   On Sat, Nov 14, 2009 at 10:38 PM, Dilip Pandey wrote:
>
>> Hi Prashanth,
>>
>> You can use following formula to get the desired output.
>> =C3&TEXT(D3," MMM-YY")
>>
>> Solved workbook is also attached.
>> Let me know if solves your query
>>
>> Best Regards,
>> --
>> DILIP KUMAR PANDEY
>>MBA-HR,B COM(Hons.),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 110062
>>
>>
>>
>> On 11/12/09, Prashanth Banneni  wrote:
>>>
>>> Hi All,
>>>
>>> Can you help me how to get the desired output from the attached sheet.
>>>
>>> Many thanks in advance
>>>
>>> Best
>>> Prashanth
>>>
>>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ hi

[Y AlterS]

Your being troubled by "array functions". those curly brackets cannot
be entered manually.

On Fri, Nov 13, 2009 at 3:45 AM, Shraddha Shah wrote:

>  Hi,
>
>
>
> We are using the attached file to prepare certain reports for the bank.
>
>
>
> We need to actually bucket the all the deposits as per the maturities
> given.
>
>
>
> One of colleague is using this formula (highlighted in yellow). Can u
> suggest any other method.
>
>
>
> If not please help me with the same formula as im unable to use the same.
>
>
>
>
>
> *Thanks & Regards*
>
> *Shraddha Shah*
>
> *State Bank of **Mauritius*
>
> *Tel - 2 2846 560 Ext (115)*
>
>
>
> P* Please don't print this e-mail unless you really need to.*
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ procdure to limit the printing to fix number of times

[Y AlterS]

how about a custom doc property, something like "times printed"? is there an
event at print  to update such a property, and set it to the next count?
then maybe we can use that event to not allow printing when this custom
prop. reaches your limit.

On Thu, Nov 12, 2009 at 1:05 PM, Hemant Hegde wrote:

> Hi
>
> You can keep a count of number of prints taken using VB but I don't think
> you can actually restrict it because the user can print it
>
> 1) on another machine
> 2) Or by just changing the name of the workbook
> 3) Or by restoring the original copy of the workbook after the number of
> prints allowed are exhausted.
>
> If you can explain the reason and importance of doing it, we may be able to
> give you a suitable solution
>
>
> Hemant Hegde
>
>
> 2009/11/10 OSAVentures Calamba 
>
> dear gurus,
>>
>> say i have a worksheet, but i want to limit the printing of this worksheet
>> to 10 times only.  is it possible?
>> any vba idea.  most probably this is a worksheet print event?
>>
>> im new to macro.  thanks for understanding.
>>
>> dellosa
>>
>> --~--~-~--~~~---~--~~
>> --
>>
>> Some important links for excel users:
>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain  @ jainayus...@gmail.com or
>> Ashish Jain @ 26may.1...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file

[MKamal]

Hello,

I think i did some effort to solve your problem take a look  at this
post : 
http://groups.google.com/group/excel-macros/browse_thread/thread/29083fc9f3da2cdc
Hope this helps you

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Problem.Pls help

[MKamal]

There is no explanation in your worksheet!

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: text and date in one cell

[Prashanth Banneni]

Hi Dilip,

Thanks a lot, You are a genius
Thanks
Prashanth

On Sat, Nov 14, 2009 at 10:38 PM, Dilip Pandey  wrote:

> Hi Prashanth,
>
> You can use following formula to get the desired output.
> =C3&TEXT(D3," MMM-YY")
>
> Solved workbook is also attached.
> Let me know if solves your query
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
>
> On 11/12/09, Prashanth Banneni  wrote:
>>
>> Hi All,
>>
>> Can you help me how to get the desired output from the attached sheet.
>>
>> Many thanks in advance
>>
>> Best
>> Prashanth
>>
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ lenghty IF formula

[Johnnyboy5]

Hi,  got the answer

I am using either of these,  but the shorter one works just the same.

Thanks for your reply.

Johnnyboy

ROW 70  in the MAIN sheet =IF(AND(A70>=3,A70<=53),INDIRECT
("C"&A70))
ROW 70  in the MAIN sheet =INDIRECT("c" & A70)



On 15 Nov, 12:37, Dilip Pandey  wrote:
> Dear Johnny,
>
> First you should try to identify important factors or key locators in your
> data and they you can try SUMPRODUCT formula or some other array
> functionality to achieve the desired result.
>
> For better explanation, attach a sample spreadsheet.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>    MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
> On 11/15/09, Johnnyboy5  wrote:
>
>
>
> > I need to use the IF 53 times ! I have 53 rows which I am using filter
> > and  Subtotal (row70)  I need to get one of the columns "C" to enter
> > its text (names) into the subtotal row 70.
>
> > However I can only use the brackets up to 9 times ( I think) can does
> > anyone know how to reduce the formula size.  I need to get A70 up to
> > =53 and likewise with the C column.
>
> > =IF(A70=3,C3,IF(A70=4,C4,IF(A70=5,C5,IF(A70=6,C6,IF(A70=6,C6,IF
> > (A70=7,C7,IF(A70=8,C8,
> > IF(A70=9,C9
>
> > Row 70 works like this
> > if the subtotal in column A row 70 = 5 then in the subtotal column C
> > (where the above formula is) it puts the name of the person,   all the
> > other subtotal columns are for data and they work fine.   This does
> > what I need but I need but only up to number 9, I need to get the
> > "equals" up to number 53 and therefore the C part of the formula up to
> > 53.
>
> > thanks everyboy how reads these posts.
>
> > --
>
> > --
> > Some important links for excel users:
> > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >http://www.excelitems.com
> > 2. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com
> > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
> > If you find any spam message in the group, please send an email to:
> > Ayush Jain  @ jainayus...@gmail.com or
> > Ashish Jain @ 26may.1...@gmail.com
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,500 subscribers worldwide and receive many nice notes about
> > the learning and support from the group. Our goal is to have 10,000
> > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ lenghty IF formula

[Dave Bonallack]

Hi,

Try using this formula instead:

=INDIRECT("C"&A70)

 

Regards - Dave.
 
> Date: Sun, 15 Nov 2009 03:39:46 -0800
> Subject: $$Excel-Macros$$ lenghty IF formula
> From: intermediatec...@googlemail.com
> To: excel-macros@googlegroups.com
> 
> I need to use the IF 53 times ! I have 53 rows which I am using filter
> and Subtotal (row70) I need to get one of the columns "C" to enter
> its text (names) into the subtotal row 70.
> 
> However I can only use the brackets up to 9 times ( I think) can does
> anyone know how to reduce the formula size. I need to get A70 up to
> =53 and likewise with the C column.
> 
> =IF(A70=3,C3,IF(A70=4,C4,IF(A70=5,C5,IF(A70=6,C6,IF(A70=6,C6,IF
> (A70=7,C7,IF(A70=8,C8,
> IF(A70=9,C9
> 
> Row 70 works like this
> if the subtotal in column A row 70 = 5 then in the subtotal column C
> (where the above formula is) it puts the name of the person, all the
> other subtotal columns are for data and they work fine. This does
> what I need but I need but only up to number 9, I need to get the
> "equals" up to number 53 and therefore the C part of the formula up to
> 53.
> 
> thanks everyboy how reads these posts.
> 
> -- 
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> 
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,500 subscribers worldwide and receive many nice notes about 
> the learning and support from the group. Our goal is to have 10,000 
> subscribers by the end of 2009. Let friends and co-workers know they can 
> subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
Looking for a date? View photos of singles in your area!
http://clk.atdmt.com/NMN/go/150855801/direct/01/

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Patron List

[Dilip Pandey]

Dear Tommy,

One thing you can do here is to use key combination CTRL + Down Arrow to go
to the last record of the column and then use CTRL + SHIFT + HOME to select
the data - Note this will select the data only till freeze line and by this
way you can skip the data which are lying above from the freeze line.

Hope this helps.

Best Regards,
-- 
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On 11/15/09, Tommy  wrote:
>
> Thanks so much Dilip , that is exactly what I was looking for.
>
> I have another challenge that you may be able to shed some light on.
> The column of data (the patrons) that I would like to filter, shone
> below as an example, begins right below the pane freeze line and
> continues very far down the page. the list gets longer and longer with
> time as ticket sales come in. I don't want the data above the freeze
> line, Xs in this example, to enter into the generation of the patron
> list. Using the second option for generating a patron list that you
> suggested, requires that I first select every thing below the freeze
> line to the very end, where ever that may be. The selection must not
> include any above the freeze line. Do you have any suggestion for me
> on that situation?
>
>   X
>   X
>   X
> Pane Freeze Line _X
>   D
>   G
>   A
>   E
>
> Again thanks for your help.
> Tommy
>
>
> On Nov 14, 8:31 am, Dilip Pandey  wrote:
> > Hi,
> >
> > If the list is in Excel, then you can use below two options as per your
> > choice:-
> >
> > 1)  Use Pivot Table, put the Names in Row column and the count of the
> names
> > in data field, sort the data as ascending and you have the names in
> > alphabetcal oder and their count in the next column.
> >
> > 2) If you just want the unique name, then you can use Data - > Filter->
> > Advanced Filter and check on the checkbox against Unique records, choose
> the
> > destination and click on OK.
> >
> > A macro can be built easily to achieve both the above tasks in a click of
> a
> > button.
> > Let me know if it solves your query, else reply with your query.
> >
> > Best Regards,
> > --
> > DILIP KUMAR PANDEY
> >MBA-HR,B COM(Hons.),BCA
> > Mobile: +91 9810929744
> > dilipan...@gmail.com
> > dilipan...@yahoo.com
> > New Delhi - 110062
> >
> > On 11/14/09, Tommy  wrote:
> >
> >
> >
> >
> >
> > > I am developing a ticket managing program for a community choir and
> > > now have generated an extensive list of ticket purchasers by name,
> > > where some names are repeated many times over due to multiple
> > > purchases by the same person. I would like to generate an alphabetized
> > > list by name, a patron list,  where any given name is only found once
> > > so that the list is not so long. I could just alphabetize the list of
> > > data and then go in and manually remove instances where the same name
> > > is repeated many times, but this would be time consuming. Is there
> > > some neat way to generate a patron list automatically ?
> >
> > > Tommy
> >
> > > --
> >
> > >
> ---­---
> > > Some important links for excel users:
> > > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> > >http://www.excelitems.com
> > > 2. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com
> > > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> > > If you find any spam message in the group, please send an email to:
> > > Ayush Jain  @ jainayus...@gmail.com or
> > > Ashish Jain @ 26may.1...@gmail.com
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
> >
> > > We reach over 6,500 subscribers worldwide and receive many nice notes
> about
> > > the learning and support from the group. Our goal is to have 10,000
> > > subscribers by the end of 2009. Let friends and co-workers know they
> can
> > > subscribe to group at
> > >http://groups.google.com/group/excel-macros/subscribe- Hide quoted text
> -
> >
> > - Show quoted text -

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainay

Re: $$Excel-Macros$$ Flagging duplicate values with Countif and Search functions re partial matches

[Dilip Pandey]

Dear Dan,

I have tried to build up the data as mentioned by you and able to get the
desired result.
Same spreadsheet is attached herewith for your review.

Best Regards,
-- 
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On 11/15/09, dsulliva  wrote:
>
> Hi Everyone...I have a list of names (column A) and in column B I want
> a formula to flag all duplicate items in column A. I was using the
> formula =IF(COUNTIF($A$2:$A$10,A2)>1,1,0) where "1" would flag me to a
> possible duplicte (i.e. I could filter on it).
>
> The data in column A is causing problems. Column A contains names. It
> could be in the format first name / last name or last name / first
> name. There also could be a comma or a semi-colon separating the 2.
> There almost always will be a space between the two. My solution was
> to use the last 4 or 5 charactes of the column A cell and use that as
> a condition in the count if. It looks something like this, but I can't
> get it to work.
> =IF(COUNTIF($A$2:$A$13,IF(ISERROR(SEARCH(RIGHT($A2,2),$A2,1))=TRUE,
> 0,1)), 1,0)
>
> Can someone give me some advice? I'm also open to other formulas /
> functions that would allow me to flag possible duplicate names based
> upon a partial match of the cell (e.g. a cell in column A containing
> "Ron Smith" would have to identify "Smith, Ron"; "Smith Ron"; "Smith;
> Ron"; "Ron, Smith" as a potential duplicate values). Then there's
> possible duplicate data that contains spelling errors (e.g. Smith vs.
> Smithh vs. Smyth). I don't think there's any help for that??
>
> I'd prefer not to sort, subtotal, etc. the data and I'm using Excel
> 2003. I also don't want VBA solutions.
>
> Thanks
> Dan
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Flagging duplicate values - by DILipandey.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ excel certificate course

[sarfaraz ahmed]

i took exams at brainbench.com. This is good.

Regards,
Sarfaraz Ahmed
Microsoft Excel and VBA help 

On Sun, Nov 15, 2009 at 4:40 PM, karthikeyan  wrote:

> Hi all,
>
> I am from chennai.If any body knows about online excel certificate
> course.Pls let me know.
>
> txs
> karthik
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe




-- 
Thanks with regards,
Sarfaraz Ahmed

http://feeds2.feedburner.com/~r/blogspot/rtws/~6/6";>http://feeds2.feedburner.com/blogspot/rtws.6.gif"; alt="Free MS Excel
help" style="border:0">

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ lenghty IF formula

[Dilip Pandey]

Dear Johnny,

First you should try to identify important factors or key locators in your
data and they you can try SUMPRODUCT formula or some other array
functionality to achieve the desired result.

For better explanation, attach a sample spreadsheet.

Best Regards,
-- 
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On 11/15/09, Johnnyboy5  wrote:
>
> I need to use the IF 53 times ! I have 53 rows which I am using filter
> and  Subtotal (row70)  I need to get one of the columns "C" to enter
> its text (names) into the subtotal row 70.
>
> However I can only use the brackets up to 9 times ( I think) can does
> anyone know how to reduce the formula size.  I need to get A70 up to
> =53 and likewise with the C column.
>
> =IF(A70=3,C3,IF(A70=4,C4,IF(A70=5,C5,IF(A70=6,C6,IF(A70=6,C6,IF
> (A70=7,C7,IF(A70=8,C8,
> IF(A70=9,C9
>
> Row 70 works like this
> if the subtotal in column A row 70 = 5 then in the subtotal column C
> (where the above formula is) it puts the name of the person,   all the
> other subtotal columns are for data and they work fine.   This does
> what I need but I need but only up to number 9, I need to get the
> "equals" up to number 53 and therefore the C part of the formula up to
> 53.
>
> thanks everyboy how reads these posts.
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<

[Abhishek Jain]

Hello Ayush,

This is exactly what I wanted.

Thank you very much.

Jai Jinendra !

Abhishek Jain

On Sun, Nov 15, 2009 at 4:25 PM, Ayush Jain  wrote:

>   Hi Abhishek,
>
> Jai Jinendra ! You are most welcome !
>
> Attached is the updated solution. Please see the file and let me know if
> this is the desired solution. I have added data validation in column E.
>
> Best regards,
> Ayush Jain
> [Group Manager & Owner]
>
>
> --- On *Sun, 15/11/09, Abhishek Jain * wrote:
>
>
> From: Abhishek Jain 
> Subject: $$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<<
> To: "Ayush" 
> Cc: "MS EXCEL AND VBA MACROS" 
> Date: Sunday, 15 November, 2009, 1:21 PM
>
>
>  Hello Ayush,
>
> Thank you very much for the macro which worked exactly as expected. The
> only problem was that I already had entries filled up, for which I used your
> macro as a separate module and it solved the issue.
>
> Although not related to this question - I am going to send this file to my
> managers and I want to set a drop-down list for input values, i.e.,
> 0,1,2,3. Data Validation can simply do this. The problem is it will show 0 ,
> 1 , 2 and 3 in the drop-down and when they change the value, say, from 2 to
> 3, the macro will change the display from Good to Excellent. Fairly
> confusing for Managers ;) I don't know, but can I somehow get an indication
> for display values (Excellent, Good, Average, Poor) in the drop-down ?
>
> Hope I am not bothering you too much. Thanks again for your suport.
>
> Jai Jinendra
>
> Abhishek Jain
>
> On Sat, Nov 14, 2009 at 8:15 PM, Ayush 
> http://mc/compose?to=jainayus...@gmail.com>
> > wrote:
>
>> Hi Abhishek,
>>
>> Unfortunately, The custom number format can take only up to two
>> conditions and you have three conditions in your requirement. Also,
>> Conditional formatting may not work as it displays colors,borders and
>> patterns.
>>
>> I have written a macro for you which should fulfill your requirement.
>> This macro should be used in Change event of excel sheet(or workbook)
>> and you should specify your desired range in macro. So, whenever you
>> will change value in the range, the macro will trigger and change the
>> custom format.
>>
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>>
>> For Each cell In ActiveSheet.Range("A1:Z100")
>> If cell.Value < 2 Then
>>cell.NumberFormat = "[=0]""Poor"";[=1]""Average"""
>> End If
>>
>> If cell.Value > 1 And cell.Value < 4 Then
>>cell.NumberFormat = "[=2]""Good"";[=3]""Excellent"""
>> End If
>> Next
>>
>> End Sub
>>
>> I hope this macro will help you. Let us know if it does not work or
>> any further help is required.
>>
>> Best regards,
>> Ayush Jain
>> [Group Owner and Manager]
>>
>>
>>
>>
>>
>> On Nov 14, 1:52 pm, Abhishek Jain 
>> http://mc/compose?to=abhishek@gmail.com>>
>> wrote:
>> > Hi folks,
>> >
>> > I have this cell where the values filled can be - 0 or 1 or 2 or 3. I
>> want
>> > to set a custom format for excel to show -
>> >
>> > "Poor" for 0
>> > "Average" for 1
>> > "Good" for 2
>> > "Excellent" for 3
>> >
>> > Now, I've tried and figured out that I can set maximum 03 conditions in
>> > Custom Number format but in my case they are 4. I used this format -
>> >
>> > [=0]"Poor";[=1]"Average";"Good"
>> >
>> > It's working for 03 conditions but If I add one more condition in this,
>> -
>> > error ! format can't be set.
>> >
>> > I tried this formula in Conditional Formatting, which is working in
>> another
>> > cell but not in formatting -
>> >
>> > =IF(J2=0,"Poor",IF(J2=1,"Average",IF(J2=2,"Good","Excellent")))
>> >
>> > Any help is greatly appreciated.
>> >
>> > Thanks,
>> >
>> > AJ
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
> --
> Yahoo! India has a new look. Take a sneak 
> peek
> .
>

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downlo

$$Excel-Macros$$ lenghty IF formula

[Johnnyboy5]

I need to use the IF 53 times ! I have 53 rows which I am using filter
and  Subtotal (row70)  I need to get one of the columns "C" to enter
its text (names) into the subtotal row 70.

However I can only use the brackets up to 9 times ( I think) can does
anyone know how to reduce the formula size.  I need to get A70 up to
=53 and likewise with the C column.

=IF(A70=3,C3,IF(A70=4,C4,IF(A70=5,C5,IF(A70=6,C6,IF(A70=6,C6,IF
(A70=7,C7,IF(A70=8,C8,
IF(A70=9,C9

Row 70 works like this
if the subtotal in column A row 70 = 5 then in the subtotal column C
(where the above formula is) it puts the name of the person,   all the
other subtotal columns are for data and they work fine.   This does
what I need but I need but only up to number 9, I need to get the
"equals" up to number 53 and therefore the C part of the formula up to
53.

thanks everyboy how reads these posts.

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ excel certificate course

[karthikeyan]

Hi all,

I am from chennai.If any body knows about online excel certificate
course.Pls let me know.

txs
karthik

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<

[Ayush Jain]

Hi Abhishek,

Jai Jinendra ! You are most welcome !

Attached is the updated solution. Please see the file and let me know if this 
is the desired solution. I have added data validation in column E.

Best regards,
Ayush Jain
[Group Manager & Owner]


--- On Sun, 15/11/09, Abhishek Jain  wrote:

From: Abhishek Jain 
Subject: $$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<<
To: "Ayush" 
Cc: "MS EXCEL AND VBA MACROS" 
Date: Sunday, 15 November, 2009, 1:21 PM

Hello Ayush,
 
Thank you very much for the macro which worked exactly as expected. The only 
problem was that I already had entries filled up, for which I used your macro 
as a separate module and it solved the issue.
 
Although not related to this question - I am going to send this file to my 
managers and I want to set a drop-down list for input values, i.e., 
0,1,2,3. Data Validation can simply do this. The problem is it will show 0 , 1 
, 2 and 3 in the drop-down and when they change the value, say, from 2 to 3, 
the macro will change the display from Good to Excellent. Fairly confusing for 
Managers ;) I don't know, but can I somehow get an indication for display 
values (Excellent, Good, Average, Poor) in the drop-down ?

 
Hope I am not bothering you too much. Thanks again for your suport.
 
Jai Jinendra
 
Abhishek Jain


On Sat, Nov 14, 2009 at 8:15 PM, Ayush  wrote:

Hi Abhishek,

Unfortunately, The custom number format can take only up to two
conditions and you have three conditions in your requirement. Also,

Conditional formatting may not work as it displays colors,borders and
patterns.

I have written a macro for you which should fulfill your requirement.
This macro should be used in Change event of excel sheet(or workbook)

and you should specify your desired range in macro. So, whenever you
will change value in the range, the macro will trigger and change the
custom format.


Private Sub Worksheet_Change(ByVal Target As Range)


For Each cell In ActiveSheet.Range("A1:Z100")
If cell.Value < 2 Then
   cell.NumberFormat = "[=0]""Poor"";[=1]""Average"""
End If

If cell.Value > 1 And cell.Value < 4 Then

   cell.NumberFormat = "[=2]""Good"";[=3]""Excellent"""
End If
Next

End Sub

I hope this macro will help you. Let us know if it does not work or
any further help is required.


Best regards,
Ayush Jain
[Group Owner and Manager]








On Nov 14, 1:52 pm, Abhishek Jain  wrote:
> Hi folks,
>
> I have this cell where the values filled can be - 0 or 1 or 2 or 3. I want

> to set a custom format for excel to show -
>
> "Poor" for 0
> "Average" for 1
> "Good" for 2
> "Excellent" for 3
>
> Now, I've tried and figured out that I can set maximum 03 conditions in

> Custom Number format but in my case they are 4. I used this format -
>
> [=0]"Poor";[=1]"Average";"Good"
>
> It's working for 03 conditions but If I add one more condition in this, -

> error ! format can't be set.
>
> I tried this formula in Conditional Formatting, which is working in another
> cell but not in formatting -
>
> =IF(J2=0,"Poor",IF(J2=1,"Average",IF(J2=2,"Good","Excellent")))

>
> Any help is greatly appreciated.
>
> Thanks,
>
> AJ




-- 

--

Some important links for excel users:

1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com

2. Excel tutorials at http://www.excel-macros.blogspot.com

3. Learn VBA Macros at http://www.vbamacros.blogspot.com

4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

 

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

If you find any spam message in the group, please send an email to:

Ayush Jain  @ jainayus...@gmail.com or

Ashish Jain @ 26may.1...@gmail.com

<><><><><><><><><><><><><><><><><><><><><><>

HELP US GROW !!

 

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe


  Keep up with people you care about with Yahoo! India Mail. Learn how. 
http://in.overview.mail.yahoo.com/connectmore

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about

$$Excel-Macros$$ Re: Custom Number Format - Help >>>URGENT<<

[Abhishek Jain]

Hello Ayush,

Thank you very much for the macro which worked exactly as expected. The only
problem was that I already had entries filled up, for which I used your
macro as a separate module and it solved the issue.

Although not related to this question - I am going to send this file to my
managers and I want to set a drop-down list for input values, i.e.,
0,1,2,3. Data Validation can simply do this. The problem is it will show 0 ,
1 , 2 and 3 in the drop-down and when they change the value, say, from 2 to
3, the macro will change the display from Good to Excellent. Fairly
confusing for Managers ;) I don't know, but can I somehow get an indication
for display values (Excellent, Good, Average, Poor) in the drop-down ?

Hope I am not bothering you too much. Thanks again for your suport.

Jai Jinendra

Abhishek Jain

On Sat, Nov 14, 2009 at 8:15 PM, Ayush  wrote:

> Hi Abhishek,
>
> Unfortunately, The custom number format can take only up to two
> conditions and you have three conditions in your requirement. Also,
> Conditional formatting may not work as it displays colors,borders and
> patterns.
>
> I have written a macro for you which should fulfill your requirement.
> This macro should be used in Change event of excel sheet(or workbook)
> and you should specify your desired range in macro. So, whenever you
> will change value in the range, the macro will trigger and change the
> custom format.
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> For Each cell In ActiveSheet.Range("A1:Z100")
> If cell.Value < 2 Then
>cell.NumberFormat = "[=0]""Poor"";[=1]""Average"""
> End If
>
> If cell.Value > 1 And cell.Value < 4 Then
>cell.NumberFormat = "[=2]""Good"";[=3]""Excellent"""
> End If
> Next
>
> End Sub
>
> I hope this macro will help you. Let us know if it does not work or
> any further help is required.
>
> Best regards,
> Ayush Jain
> [Group Owner and Manager]
>
>
>
>
>
> On Nov 14, 1:52 pm, Abhishek Jain  wrote:
> > Hi folks,
> >
> > I have this cell where the values filled can be - 0 or 1 or 2 or 3. I
> want
> > to set a custom format for excel to show -
> >
> > "Poor" for 0
> > "Average" for 1
> > "Good" for 2
> > "Excellent" for 3
> >
> > Now, I've tried and figured out that I can set maximum 03 conditions in
> > Custom Number format but in my case they are 4. I used this format -
> >
> > [=0]"Poor";[=1]"Average";"Good"
> >
> > It's working for 03 conditions but If I add one more condition in this, -
> > error ! format can't be set.
> >
> > I tried this formula in Conditional Formatting, which is working in
> another
> > cell but not in formatting -
> >
> > =IF(J2=0,"Poor",IF(J2=1,"Average",IF(J2=2,"Good","Excellent")))
> >
> > Any help is greatly appreciated.
> >
> > Thanks,
> >
> > AJ
>

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe