Re: $$Excel-Macros$$ Help on Week Formula

[Aindril De]

Please use the following formula in the cell C2
="WK"&INT((DAY(A2)+6)/7)

And drag down to copy the formula.
Cheers!!
Aindril

On Tue, Jul 25, 2017 at 1:03 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello Team,
>
> Could you please help me in attached week formula.
>
> Regards,
>
> Chandru
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: needed formula to convert hejri date to gregorian date

[Aindril De]

Didn't find the attachment.
Found these two articles that would help:
http://www.mrexcel.com/forum/excel-questions/534307-hijra-date-into-gregorian.html
http://www.mrexcel.com/forum/excel-questions/827201-gregorian-hijri-date-conversion.html


On Sun, May 8, 2016 at 7:54 PM, Rabindra Thapa 
wrote:

> FYI...
>
> On Sun, May 8, 2016 at 7:45 PM, Rabindra Thapa 
> wrote:
>
>> Dear Experts,
>>
>> Please help me toconvert hejri date to gregorian date as per attach file.
>>
>>
>>
>> --
>>
>> Regards,
>> r.thapa
>>
>
>
>
> --
>
> Regards,
> Rabindra Thapa
> www.facebook.com/TraveltheNepal.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ please help me GRK

[Aindril De]

Dear GRKNAIDU,

Please use this formula in the Bonus Qty column and copy down:

=IF(MOD(J4,100)=0,(J4/100)*20,ROUNDDOWN(J4/100,0)*20)

Regards,
Aindril

On Sat, Mar 2, 2013 at 5:33 PM, GRKRISHNA NAIDU wrote:

> Dear all
>
> Will you please help to get the formula
>
>
> for an example  in attachment we have a product with code FLAC003   which
>  has to sell as 100+ 20 free if party placed the order for 100
> if party placed the order for multiples of 100  then the ration will be
>  multiples of  20's
>
> sales  free
>   FLAC0003 ACINIL LIQUID 120ML 100 20  FLAC0003 ACINIL LIQUID 120ML 200 40
> will any body can help us
>
>
> --
> GRKNAIDU
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ how to insert logo in excel print

[Aindril De]

Hi,

Use this link:
http://www.techrepublic.com/blog/msoffice/print-a-logo-in-an-excel-header/216

Regards,
Andy

On Thu, Feb 7, 2013 at 10:22 AM, excel lerner  wrote:

> Dear Experts
>
> I want to insert my company logo in Print by default.I tried to insert
> through custom header.But it applies for only that file.
> But i want by default to all my files.
> Please help me.
> Thanks in advance
>
>
> Regards
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Sumproduct Formula Required

[Aindril De]

If you Delete the rows mentioned.. then the formula you have mentioned works

On Fri, Jan 11, 2013 at 2:09 PM, amar takale  wrote:

> No problem hide row delete,no matter.
>
>
> On Fri, Jan 11, 2013 at 1:59 PM, Aindril De  wrote:
>
>> Dear Amar,
>>
>> You are getting a #Value error.. since you have the following #Value
>> errors in your data.
>>
>>
>>   ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
>> PHARMA ADVANCED RESEARCH 33 #VALUE!
>>
>> On Fri, Jan 11, 2013 at 12:15 PM, amar takale wrote:
>>
>>> Hi All,
>>> Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but
>>> it is so long & Confusing.Pls suggest me simple formula for solution
>>>
>>> Regards
>>> Amar
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>> Warm Regards,
>> Aindril De
>> Ph: 9811300157
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Join official 

Re: $$Excel-Macros$$ Sumproduct Formula Required

[Aindril De]

Dear Amar,

You are getting a #Value error.. since you have the following #Value errors
in your data.


  ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
PHARMA ADVANCED RESEARCH 33 #VALUE!
On Fri, Jan 11, 2013 at 12:15 PM, amar takale  wrote:

> Hi All,
> Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but it
> is so long & Confusing.Pls suggest me simple formula for solution
>
> Regards
> Amar
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ is that is sunday

[Aindril De]

 Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

[Aindril De]

Great Work Noorain!!
Though I have been silent in this group for quite some time...
However I keep following the posts.. almost everyday.. thx to great members
like you, from whom I learn everyday...!

Cheers and Keep up the good work,

Regards,
Andy

On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain  wrote:

> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel expertise.
>
> I truly appreciate his consistency and commitment to the group. He is
> really doing great job.
>
> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
> Sunita and other folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> Regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

[Aindril De]

Congratulations Ashish and Dilip!!
Your Contributions have always been an asset to our group..

Hard Luck Don...!!
Your contributions have always been really helpful in our group..
Better luck next time!!

Cheers
Andy

On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain  wrote:

> Dear members,
>
> I am extremely happy to inform you that two members of the group are
> awarded Microsoft Most Valuable Professional Award.
> My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
> thanks for their big support to this forum.
>
> Keep posting !
>
> Best regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Addition of Formula in Pivot

[Aindril De]

Hi Amit,

Can you send a sample dataset?

Regards,
Andy

On Fri, May 18, 2012 at 10:22 AM, Amit Desai (MERU)  wrote:

>  Please help...
>
> ** **
>
> I have tried adding formula in Pivot but getting an error “#DIV/0! .
>
> ** **
>
> I want Avg cost per Visit. There is a column for cost(column head “A”)in
>  of each cab getting repaired & also cab registration number (column head
> “B”)is maintained. 
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ----------
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ suggest a formula on this attachement

[Aindril De]

Sorry missed the last part of the formula

The corrected formula is:

=IF(F4=0,MIN(E4,C4),(E4+F4-C4))

Cheers,
Andy

On Wed, May 16, 2012 at 2:37 PM, Smitha S R  wrote:

> Hi,
>
> Please correct my formula on this attachment.
>
>
> On Wed, May 16, 2012 at 2:31 PM, Smitha S R  wrote:
>
>> Hi,
>>
>> Please suggest a formula on this attachment.
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



--

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ suggest a formula on this attachement

[Aindril De]

Hi Smitha,

Attached is the soln.

Cheers,
Andy

On Wed, May 16, 2012 at 2:31 PM, Smitha S R  wrote:

> Hi,
>
> Please suggest a formula on this attachment.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



--

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


test-Smitha.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Need help in ranking with multiple criteria

[Aindril De]

Dear Vijay,

The easiest way to do that is to select the entire table and then Sort on
Multiple Criteria.
1) Quality (Largest to Smallest)
2) Achieved (Largest to smallest)

That would do the trick..

Hope that helps...

Cheers!
Andy

On Tue, Apr 24, 2012 at 11:01 AM, Vijay Mane  wrote:

>
> Hi Experts,
>
> Please refer file for more information
>
> I want to calculate top performer agent according to achieved target and
> quality
> If there are multiple agent with same achieved target and quality then
> preference in ranking should go with quality
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



--

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Week Ending formula help.

[Aindril De]

Dear Avinash,

My mistake.. I forgot I am using Excel 2010 and shd have been careful. [?]

Looks like the part of the formula *WEEKDAY(C2,17)* caused the issue.

Change it to *WEEKDAY(C2,1)*
*
*
 17 in excel 2010 pertains to the * "*Numbers 1 (Sunday) through 7
(Saturday)" and is not supported in versions below 2010. *
*Use 1 instead of 17 as it behaves like previous versions of Microsoft
Excel. *
*
*
*That will work for you..*
*
*
*So your final formula will be*
*="Week Ending - "&TEXT(C2+7-WEEKDAY(C2,1),"dd-mmm-")*
*
*
*Cheers,*
*Andy*
*HTH
*
On Sat, Apr 21, 2012 at 11:11 PM, Avinash  wrote:

> Thanks Andy,
>
> I saw the sheet which u have attached and the results also but when i
> tried to press enter to that cell it is automatically showing me (
> #NUM!) error message i don't know what is the issue i am using excel
> 2007. Please help
>
>
> regards,
>
> Avinash.
>
>
> On Saturday, April 21, 2012 10:18:38 PM UTC+5:30, Andy wrote:
>
>> Dear Avinash,
>>
>> Use the Formula -   *="Week Ending - "&TEXT(C2+7-WEEKDAY(C2,17),"
>> dd-mmm-")*
>> This is for the first Row in your records, and can be copied down.
>>
>> Attached is the solved Sheet.
>>
>> Hope this Helps
>>
>> Cheers,
>> Andy
>> HTH
>>
>>
>> Dear Masters,
>>>
>>> Please find attached sheet for better understanding, i want help
>>> regarding week ending formula to determine week ending.
>>>
>>>
>>> Regards,
>>>
>>> Avinash
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>> --**--**
>>> --**
>>>
>>>
>>
>>
>>
>>
>>   --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<<32F.gif>>

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

[Aindril De]

Congratulations Noorin Bhai!!
Keep it up! :)
Waiting for more poems on excel flowing from you :)

Cheers !
Andy

On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain  wrote:

>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
> !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ----------
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ hindi version of excel

[Aindril De]

Hi Anil,

Please check the following link:

http://office.microsoft.com/hi-in

You can also check the following link:
http://www.bollywhat-forum.com/index.php?topic=26611.0

Regards,
Aindril

On Tue, Jan 17, 2012 at 5:39 PM, anil kumar  wrote:

> Hello friends,
>
>
> any body tell me were i can gat hindi version of excel. plz tell me link
>
>
> anil
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ----------
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ shortcut key .

[Aindril De]

Hi

Try this:

http://dmcritchie.mvps.org/excel/shortx2k.htm

Cheers,
andy

On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote:

> Hello sir
>
> Can you tell me what is shortcut key for data clear(filter)?
>
>
> Thanks
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

[Aindril De]

Sorry NOT USING TRIM

On Wed, Dec 7, 2011 at 2:39 PM, Aindril De  wrote:

> NOTE:
> I am using the simple TRIM(<>) function as the data you have sent contains
> multiple spaces in the trail.
>
>
> On Wed, Dec 7, 2011 at 2:35 PM, Aindril De  wrote:
>
>> Dear Lakshman,
>>
>> You are not able to do the SUM as the data in the last column has leading
>> and trailing spaces.
>> You can use the add-on
>> http://www.ablebits.com/excel-trim-spaces/index.php
>> to quickly remove the spaces, if you regularly receive/generate such data.
>>
>> Cheers,
>> Andy
>>
>>
>> On Wed, Dec 7, 2011 at 1:43 PM, Lakshman Prasad wrote:
>>
>>> Dear All,
>>> Plz see the attach file. I can’t understand why I m unable to do sum.
>>> What is the problem in sheet or number? Help anybody?
>>> Regards
>>> LAKSHMAN
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>>
>> Warm Regards,
>> Aindril De
>> Ph: 9811300157
>>
>>
>
>
> --
>
> Warm Regards,
> Aindril De
> Ph: 9811300157
>
>


-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

[Aindril De]

NOTE:
I am using the simple TRIM(<>) function as the data you have sent contains
multiple spaces in the trail.

On Wed, Dec 7, 2011 at 2:35 PM, Aindril De  wrote:

> Dear Lakshman,
>
> You are not able to do the SUM as the data in the last column has leading
> and trailing spaces.
> You can use the add-on http://www.ablebits.com/excel-trim-spaces/index.php
> to quickly remove the spaces, if you regularly receive/generate such data.
>
> Cheers,
> Andy
>
>
> On Wed, Dec 7, 2011 at 1:43 PM, Lakshman Prasad wrote:
>
>> Dear All,
>> Plz see the attach file. I can’t understand why I m unable to do sum.
>> What is the problem in sheet or number? Help anybody?
>> Regards
>> LAKSHMAN
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
>
> Warm Regards,
> Aindril De
> Ph: 9811300157
>
>


-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

[Aindril De]

Dear Lakshman,

You are not able to do the SUM as the data in the last column has leading
and trailing spaces.
You can use the add-on http://www.ablebits.com/excel-trim-spaces/index.php
to quickly remove the spaces, if you regularly receive/generate such data.

Cheers,
Andy

On Wed, Dec 7, 2011 at 1:43 PM, Lakshman Prasad wrote:

> Dear All,
> Plz see the attach file. I can’t understand why I m unable to do sum. What
> is the problem in sheet or number? Help anybody?
> Regards
> LAKSHMAN
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Formula Help

[Aindril De]

Dear Hemant,

It can be achieved using the vlookup formula.
Suppose you have a data set in Sheet 1 from A1 to A9, which you need to
compare with the values present in column A in Sheet 2
Then in Column B, please type:

=VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0)

and drag the formula down.

You will get some #N/A values for the values not matching with Sheet 1.
You can further refine the formula, to suppress the #N/A values as follows:

=IF(ISERROR(VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0)),"",VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0))

This will suppress the #N/A values and replace them with blank.
Hope this helps

Cheers,
Andy


On Wed, Dec 7, 2011 at 2:00 PM, hemant  wrote:

> Hi all
>
> I need help on the following in EXCEL 2007:
>
> Compare the values of sheet 1:column A with Values of Sheet2:column A
>
> If the CELL values in sheet1 column matches with Range of values in
> Sheet2 column.
>
> copy that CELL VALUE from sheet1 and paste it adjacent column (Column
> B) of sheet2. Or COLOUR that particular cell background.
>
> Thanks and Regards
> Hemant Dange
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Comvert Excel/CSV to XML

[Aindril De]

Hi Rajan,

Thanks for your prompt response. After testing this code. I had the
following output:
Files created with .xml extension, according to the number of records.
These files were in the XML format, however the Tags were not as per the
column heads.
following is a sample output:


  
 -  http://www.w3.org/TR/REC-html40*";>
 -  
   Mr. Aindril De
   Mr. Aindril De
   2011-12-07T08:39:05Z
   14.00
  
 -  <
OfficeDocumentSettings xmlns="*urn:schemas-microsoft-com:office:office*">
   
  
 -  
   7995
   16275
   240
   75
   False
   False
  
 -  
 -  
   <Alignment ss:Vertical="*Bottom*" />
   <Borders />
   <Font ss:FontName="*Calibri*" x:Family="*Swiss*" ss:Size="*11*" ss:Color
="*#00*" />
   <Interior />
   <NumberFormat />
   <Protection />
  
 -  
   <NumberFormat ss:Format="*Short Date*" />
  
  
 -  
 - 

 -  
 -  
   500014049
  
 -  
   G J SARMA
  
 -  
   gjsarma2...@gmail.com
  
 -  
   India
  
 -  
   cGFzc0AxMjM=
  
 -  
   500014049.xml
  
 -  
   500014049.jpg
  
 -  
   1
  
 -  
   2011-06-12T00:00:00.000
  
 -  
   super
  
 -  
   2011-06-12T00:00:00.000
  
 -  
   super
  
  
  
 -  
 -  
   
   
   
  
   
 -  
 -  
   3
   R1C1:R1C13
  
  
   False
   False
  
  
  

Cheers,
Andy

On Tue, Dec 6, 2011 at 8:41 PM, rajan verma wrote:

> Hi
> Please try this :
> Sub MakeXML()
>Dim strPath As String
>Dim rngUsed As Range
>Dim rngRow  As Range
>Dim wbknew  As Workbook
>With Application.FileDialog(msoFileDialogFolderPicker)
>.Title = "please Choose Folder to Save XML File"
>.Show
>strPath = .SelectedItems(1)
>End With
>If strPath = "" Then
>MsgBox "Exit"
>End If
>Set rngUsed = ThisWorkbook.ActiveSheet.UsedRange
>Application.ScreenUpdating = False
>ThisWorkbook.SaveAs strPath & "\" & ThisWorkbook.Name, 46
>For Each rngRow In rngUsed.Rows
>rngRow.Copy
>Set wbknew = Workbooks.Add(1)
>wbknew.ActiveSheet.Paste
>wbknew.SaveAs strPath & "\" & wbknew.Name, 46
>wbknew.Close
>Next
>MsgBox "Done"
>Application.ScreenUpdating = False
> End Sub
>
>
> On 12/6/11, Aindril De  wrote:
> > Hi All,
> >
> > I have a dataset in Excel.
> > I have to do the following:
> > 1) Convert the dataset to XML Format
> > 2) Create a different XML File for each row.
> >
> > Any help would be really appreciated.
> >
> > Cheers
> > --
> >
> > Andy
> >
> > --
> > FORUM RULES (934+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De

$$Excel-Macros$$ Comvert Excel/CSV to XML

[Aindril De]

Hi All,

I have a dataset in Excel.
I have to do the following:
1) Convert the dataset to XML Format
2) Create a different XML File for each row.

Any help would be really appreciated.

Cheers
-- 

Andy

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

[Aindril De]

t;>>
>>> --
>>> Regards
>>> Rajan verma
>>> +91 9158998701
>>>  --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Aamir Shahzad
>>
>>  --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

[Aindril De]

NED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>>> owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Thanks & Regards
>>
>>
>> Aivran kumar
>> Mob:8130906102,E-mail:- aivran...@gmail.com *
>>
>>
>>
>>  --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

[Aindril De]

Dear All,

Thanks for the help. I tried your solutions:
The solutions with Large work with almost all the lists.

But If you try this on a list 1,2,2,3,3
=LARGE(A1:A5,2) does not work
None except Divaker's formula worked on that.
I am wondering why.!
Any Guesses?

On Thu, Dec 1, 2011 at 5:48 PM, Divaker Pandey  wrote:

> try this one,
>
>
> =LARGE(A2:A10,COUNTIF(A2:A10,MAX(A2:A10))+1)
>
>
>
> On Thu, Dec 1, 2011 at 5:32 PM, Aindril De  wrote:
>
>> Thanks all..
>>
>>
>> On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh wrote:
>>
>>> =LARGE(A1:G1,2)
>>> Regards
>>> jeet
>>>
>>> On Thu, Dec 1, 2011 at 3:51 PM, Aindril De  wrote:
>>>
>>>> Hi Friends,
>>>> I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to
>>>> extract the second biggest number from this list.
>>>> Note: This list cannot be sorted. I have already found out how to do it
>>>> from a sorted list. Also I would need this to be done possibly through a
>>>> formula and not any UDF.
>>>>
>>>> --
>>>>
>>>> Warm Regards,
>>>> Andy
>>>>
>>>> --
>>>> FORUM RULES (934+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>
>>>  --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>>
>> Warm Regards,
>> Aindril De
>> Ph: 9811300157
>>
>>  --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (934+ members already BANNED for 

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

[Aindril De]

Thanks all..

On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh  wrote:

> =LARGE(A1:G1,2)
> Regards
> jeet
>
> On Thu, Dec 1, 2011 at 3:51 PM, Aindril De  wrote:
>
>> Hi Friends,
>> I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to
>> extract the second biggest number from this list.
>> Note: This list cannot be sorted. I have already found out how to do it
>> from a sorted list. Also I would need this to be done possibly through a
>> formula and not any UDF.
>>
>> --
>>
>> Warm Regards,
>> Andy
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

[Aindril De]

Dear Noorain,

Thanks for the response.
I have already tried this. This does not work. If you use this on the list
i have mentioned. It generates 4 and not 2,, which should be the correct
answer.
Please note. This list has duplicate values.

Regards,
Andy

On Thu, Dec 1, 2011 at 4:10 PM, NOORAIN ANSARI wrote:

> Dear Aindril,
>
> Please use this one,
>
> =LARGE(A32:A40,2)
>
> -
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Thu, Dec 1, 2011 at 3:51 PM, Aindril De  wrote:
>
>> Hi Friends,
>> I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to
>> extract the second biggest number from this list.
>> Note: This list cannot be sorted. I have already found out how to do it
>> from a sorted list. Also I would need this to be done possibly through a
>> formula and not any UDF.
>>
>> --
>>
>> Warm Regards,
>> Andy
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> -
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

[Aindril De]

Hi Friends,
I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to
extract the second biggest number from this list.
Note: This list cannot be sorted. I have already found out how to do it
from a sorted list. Also I would need this to be done possibly through a
formula and not any UDF.

-- 

Warm Regards,
Andy

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Need Help with IF(AND formula

[Aindril De]

Hi,

If you are using Excel 2007 or 2010, then you can use the SUMIFS or
COUNTIFS to achieve the same.

Cheers
Andy

On Tue, Nov 22, 2011 at 11:00 PM, Jedi Spencee wrote:

> Hello- I am trying to write a formula that would return the COUNT and
> SUM, with 3 criteria elements.
>
> IF(AND(data!F:F = "A"),and(data!B:B, = "04 - Closed Won"), and(data!
> D:D, = Oct-11),count, "0")
>
>
> Can this be done?
>
> Thank you.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Help Required

[Aindril De]

Hi Neeraj,

You can use the Consolidate function of Excel to achieve the same. Please
follow the link below for the steps:
http://support.microsoft.com/kb/214270

Cheers,
Andy

On Tue, Nov 15, 2011 at 4:00 PM, Neeraj Chauhan
wrote:

>  Dear Experts,
>
> How can I make the qty against particular Indus id from the different
> files.
>
> We have two sheets book 1 and 2 I want to know the sum  of quantity
> against particular Indus id
>
> Book1
> 
>
> ** **
>
> ** **
>
> *Sr.No.*
>
> *Period and Date*
>
> *Indus ID*
>
> *Site name*
>
> *QTY*
>
> 1
>
> 2-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 2
>
> 4-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 3
>
> 6-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 4
>
> 8-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 5
>
> 10-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 6
>
> 12-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 7
>
> 14-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> ** **
>
> *Sr.No.*
>
> *Period and Date*
>
> *Indus ID*
>
> *Site name*
>
> *QTY*
>
> 1
>
> 16-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 2
>
> 18-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 3
>
> 20-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 4
>
> 22-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 5
>
> 24-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 6
>
> 26-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 7
>
> 28-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> 8
>
> 30-Oct-11
>
> IN-158
>
> JANDHERA
>
> 74
>
> ** **
>
> I want to know the automatic sum of In-158
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> *Thanks & Regards*
>
> *Neeraj Chauhan*
>
> *MIS Executive.*
>
> *b4S* *Solutions (P) Ltd.*
>
> *169/1 Mangal Pandey Nagar*
>
> *Meerut UPW 251*
>
> *Mob. +91-**9639001150*
>
> *email-neerajchauhan...@gmail.com*
>
> ** **
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



--

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Convert Date to month

[Aindril De]

Hi Sandeep,

We do not need a formula to do the same.
Simple select the column/cell that has your date and change the format to a
custom format delete everything in the "Type:" box and fill "" to
display the full month name or "mmm" to display the month in a short form.

Cheers,
Andy

On Tue, Nov 15, 2011 at 3:19 PM,  wrote:

> Dear all,
>
> I have a date written as 01/04/2011, 03/05/2011; I want a function in next
> column to show only April and May respectively.
>
> Thanking you in advance.
>
> Sandeep Chhajer.
> Sent on my BlackBerryŽ from Vodafone
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



--

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Listing name of worksheet & renaming them

[Aindril De]

Pl chk this,

http://support.microsoft.com/kb/812386

Cheers,
Andy

On Sun, Nov 13, 2011 at 1:36 PM, Amit Desai (MERU)
wrote:

>  Dear Master,
>
> ** **
>
> I have an excel file with sheet names ranging from A to V. However I want
> to change its sequence post changing its name.
>
> ** **
>
> Do we have any shortcut?
>
> ** **
>
> Regards,
>
> *Amit Desai*
>
> AM - MIS Corporate
>
> Meru Cabs Company Pvt.Ltd
>
> Mumbai
>
> Mob:9867232534
>
> ** **
>
> [image: cid:image005.gif@01CC7D2E.37B8B040]
>
> ** **
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



--

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Query related to subtotal and condition

[Aindril De]

Dear Mr. Modi,

Attached is the soln. pl chk if this is ok.

Regards,
Andy

On Sat, Nov 12, 2011 at 12:09 PM, L.K. Modi  wrote:

> Dear All members,
>
> I am attaching herewith a file regarding tds and the requirement is
> mention in that file related to subtotal and conditions. Please solve my
> problem . Thanks to all in advance
>
>
> Regards
> LKModi
> 9309243685
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ----------
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


TDS 2011-12-Modi.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help Required.xlsx

[Aindril De]

Good one Noorain..
Can you help how this array works please..
Cheers,
Andy

On Fri, Nov 11, 2011 at 3:34 PM, NOORAIN ANSARI wrote:

> Dear Neeraj,
>
> Please try through below formula, See attached sheet..
>
>
> =OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),""),COUNTIF($I$2:$I2,$I2))-1,0)
> Press ctrl+shift+enter
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan <
> neerajchauhan...@gmail.com> wrote:
>
>>  Dear Experts,
>>
>> ** **
>>
>> Kindly find the attached sheet.
>>
>> I want to only last date qty and stock in three sites.
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ Help Required.xlsx

[Aindril De]

Hi Neeraj,

This can be achieved with the use of Pivots.
Attached is the Solution.
Please let me know if you need any clarification.

Cheers,
Andy

On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan
wrote:

>  Dear Experts,
>
> ** **
>
> Kindly find the attached sheet.
>
> I want to only last date qty and stock in three sites.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ----------
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Neeraj-Soln.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Validation

[Aindril De]

Hi Shashank,

Considering A2 has "country" and The Code in B1, the formula to be placed
in C1 is as follows:
=IF(AND(A2="India",OR(B2=8,B2=11)),"TRUE","ERROR")


On Mon, Oct 31, 2011 at 4:40 PM, shashank bhosle <
catchshashankbho...@yahoo.co.in> wrote:

> Hello ,
>
> When Cell= India and other cell  Code is equal to 8 or 11 show me Trueelse 
> Error
>
>
> Regards
> Shashank
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ----------
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year

[Aindril De]

Hi Sara,

Please find attached the soln.
Hope it helps.

Rgds,
Andy

On Mon, Oct 31, 2011 at 6:49 AM, Sara Lee  wrote:

> hi
>
> i have a column in excel with the following date format--
>
> ship date
> 20110801
> 20110823
> 20110903
>
> I need another column adjacent to it which gives me the following results
> for every respective date above-- basically calcualate month and the week
> in that particular month in below format... Also the week column should
> give the week no in the year . for example 20110801 might represent 32 nd
> week in the year . so i need to fill up 2 columns
>
> week-monthweek
> 08-1 week
> 08- 4 week
> 09 -1 week
>
> what formulas should i use to generate both the columns
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ----------
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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


Sara-Soln.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Thanks everyone.

[Aindril De]

Hi Ayush,

Great Going Brother Keep up the Good Work...

Cheers,
Andy

On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain  wrote:

> Dear members,
>
> I am proud to share that I have been re-awarded the Micrososft MVP award in
> 2011.  My deep thanks to each group member for all your support and
> contribution to this group.
> I keep saying that this forum is a great community and emerging as one of
> the largest forum in the world, because of the 'helping hand' we all give
> one another.
>
> Thanks again & keep posting !
>
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Urgent Help needed-Dashboards

[Aindril De]

Hi Avinash,

Try this:

http://www.freeexceldashboards.com/exceldashboardtemplates.html

Cheers,
Andy

On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:

> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like drop downs , charts, graphs
> "a dashboard with full graphical and customization interface"
>
> i'll be realy greatfull to you guys please forward me the designs,
>
> Regards,
>
> Avinash
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 

Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ SUMIFS

[Aindril De]

Hi Kaushik,

The criteria that you have mentioned is not clear enough. Please clarify the
critera properly.
Do you mean it would sum is all the criteria is met or sum only the cells
that meet the criteria.

Cheers,
Andy

On Wed, Jul 20, 2011 at 1:15 AM, kaushik modak
wrote:

> Hello Guys,
>
> Please help me to get to result in the attached.
> I have tried with sumifs, if etc., but not getting the accurate result.
>
> Regards,
> Kaushik
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 

Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Simple Code

[Aindril De]

Use
=ROUND(B12,-1) // (Suppose the number is in B12)

Cheers
Andy

On Sun, Jul 17, 2011 at 5:22 PM, sharad jain  wrote:

> Hi Guys,
>
> Can someone please send me a simple code for round off to nearest 10? (No
> macro if possible.)
>
> For example, if I put 23 in A1, it should result in 20 in B1 and if I put
> 27 in A1, it should result in 30 in B1. For 25, it should result in 30.
>
> Thanks in advance.
>
> Best,
> Sharad
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 

Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

[Aindril De]

Congrats Ashish!! Keep up the good work!! Cheers
Andy

On Wed, Apr 6, 2011 at 3:21 PM, NOORAIN ANSARI wrote:

> Congrats Ashish..Keep it up
>
> On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain  wrote:
>
>> Hello Everyone,
>>
>> Ashish Koul has been selected as 'Most Helpful Member' for the month of
>> March'11
>> He has posted 48 posts in March 2011 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum and
>> achieved this recognition from last four months.This is really awesome.
>>
>> ASHISH, Many Many thanks for the incredible support to group.
>>
>> This is a record achievement by anyone since we launched the recognition.
>> Let see who will break Ashish's record. :)
>>
>> *I have published the same on discussexcel.com homepage.*
>>
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 

Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: कविता : महिमा SUMPRODUCT की

[Aindril De]

HI Noorain!!

This is awsome maan...
This shows you are not only an expert in excel but also have a poetic angle
to this mastery!!!

@ Aayush!! This brings on an idea to create a list of most used formula in
excel by our users..

Cheers!
Andy

2011/3/11 Ayush Jain 

> Noorain, You are always awesome and this poem is phenomenal.
>
> Regards
> Ayush Jain
>
> 2011/3/11 NOORAIN ANSARI 
>
>> Dear Experts,
>>
>> I have tried to describe importance of sumproduct function in my poem
>> with example.
>> Please read and see attached worksheet.
>>
>> SUMPRODUCT है एक..लेकिन इसके  रूप है अनेक.
>> अगर बिश्वास नहीं है भाई तो जरा एक नज़र तो देख.
>>  नहीं चाहिए हमको बहूत सारे Functions  का सहारा.
>>  उनके जगह पे काफी है बस एक sumproduct  हमारा.
>>चाहे DATA  हो आसान,चाहे हो critical.
>>चाहे हो Horizental ,चाहे हो Vertical.
>>चाहे EXCEL हो 2003,  चाहे हो 2007.
>>इसके लिए issue नहीं  है कोई भी हालात.
>>कौन नहीं रखेगा excel के ऐसे  धांसू
>> function को याद.
>>  जो बिना CTRL+SHIFT+Enter का ही देता है
>> Array Function का स्वाद.
>>हर जगह इसका Performance  हैं शानदार.
>>Best Function के अवार्ड का ये है हकदार.
>>महिमा sumproduct का भईया अपरम्पार है.
>>तभी तो हर किसी के दिल में इसके लिए प्यार
>> है.
>>
>>   Name ID Marks Check Duplicate Entry Helping Col  A 111 123
>> =SUMPRODUCT(--($A$2:A5=A5)) 1  B 222 232  =SUMPRODUCT(--($A$2:A6=A6)) 1 A
>> 111 453  =SUMPRODUCT(--($A$2:A7=A7)) 2  D 444 231
>> =SUMPRODUCT(--($A$2:A8=A8)) 1  A 999 124  =SUMPRODUCT(--($A$2:A9=A9)) 3 B
>> 555 234  =SUMPRODUCT(--($A$2:A10=A10)) 2  C 333 321
>> =SUMPRODUCT(--($A$2:A11=A11)) 1  B 222 256  =SUMPRODUCT(--($A$2:A12=A12))
>> 3  D 444 231  =SUMPRODUCT(--($A$2:A13=A13)) 2 Formula Criteria Syntex
>> Example Output  Countif A  =SUMPRODUCT(--(A2:A10=B13)) 3  Countifs A,111
>>  =SUMPRODUCT((A2:A10=B14)*(B2:B10=111)) 2  Sum=SUMPRODUCT(C2:C10)
>> 2205  Sumif A  =SUMPRODUCT((A2:A10=B16)*(C2:C10)) 700  Sumifs A,111
>> =SUMPRODUCT((A2:A10="A")*(B2:B10=111)*(C2:C10)) 576  Averageif A
>> =SUMPRODUCT((A2:A10="A")*(C2:C10))/SUMPRODUCT(--(A2:A10="A")) 233.333 
>> Averageifs
>> A,111
>> =SUMPRODUCT((A2:A10="A")*(B2:B10=111)*(C2:C10))/SUMPRODUCT((A2:A10="A")*(B2:B10=111))
>> 288  Conditional MAX Max of A  =SUMPRODUCT(MAX((A2:A10="A")*(C2:C10)))
>> 453  Max Value A & B A,B
>> =SUMPRODUCT(MAX(($A$2:$A$10={"A","B"})*($C$2:$C$10))) 453  Conditional
>> Large 2nd Max of A  =SUMPRODUCT(LARGE((A2:A10="A")*(C2:C10),2)) 124  Sum
>> of A & B A, B  =SUMPRODUCT((A2:A10={"A","B"})*(C2:C10)) 1422  Count of
>> A&B A,B  =SUMPRODUCT(--(A2:A10={"A","B"})) 6  All Marks of A A
>> =SUMPRODUCT(($A$2:$A$10="A")*($D$2:$D$10=ROW(A1))*($C$2:$C$10)) 123
>>  =SUMPRODUCT(($A$2:$A$10="A")*($D$2:$D$10=ROW(A2))*($C$2:$C$10)) 453
>>  =SUMPRODUCT(($A$2:$A$10="A")*($D$2:$D$10=ROW(A3))*($C$2:$C$10)) 124 Total 
>> Unique Data
>>=SUMPRODUCT(1/COUNTIF(A2:A10,A2:A10)) Press ctrl+shift+enter 4
>>
>> If i missed any thing please add...
>> --
>> Thanks & regards,
>> Noorain Ansari
>>
>>
>
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 

Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

[Aindril De]

--
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 

Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

[Aindril De]

I go for
1) building XL-lence
- Andy

On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain  wrote:

> Dear members,
>
> I am too excited to share that discussexcel.com website development is in
> good progress and we are ready to launch the website on 4th Anniversary of
> our Google group. i.e. 16th -17th March.
>
> In the meantime, Can you advise a good tagline, punchline for website.
>
> My thoughts are :
> 1) building excel-lence
> 2) Excellence in Excel
> 3) Let's discuss and learn excel
>
> what do you think, Let me know
>
> Keep watching this space for more
>
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Wedding Planner

[Aindril De]

Haha.. Gr8 one as usual Ayush...
Wish I had one when I got married... ;) cheers!!!

On Wed, Feb 23, 2011 at 8:46 AM, Ayush  wrote:

> The most expensive wedding ever was that of Vanisha Mittal, daughter of
> world’s 8th richest person Lakshmi Mittal, to investment banker Amit Bhatia
> in 2004. It cost a whopping $78 million dollars. On that note, check out
> this Excel 2010 wedding budget plannerRegards,
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

[Aindril De]

Hi Mike,
Please use:
=VLOOKUP(A2,Sheet1!B:B,1,0) instead.

Regards,
Andy

On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike wrote:

> I am struggling with this and wondering if you could help..
>
> Worksheet 1 Column A & B
> Keyword Category
> telecom Telecom
> tele com#N/A
>
> Worksheet 2 Column A & B
> termcategory
> telecom Telecom
> telcom  Telecom
> tele comTelecom
>
> What I want to do is pull the category name from worksheet 2 on to
> worksheet 1.
>
> =VLOOKUP("*"&A2&"*",Sheet1!B:B,1,0)
>
> Is not working...any ideas?
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Official launch of Knowledge Portal - discussexcel.com

[Aindril De]

Hey Ayush,

This is indeed a great news!!
A great initiative from your side once again!!
By profession I do a little bit of web development and content development.
Therefore I would like to be the first volunteer to this job..

Cheers,
Andy

On Wed, Feb 2, 2011 at 9:09 PM, Ayush  wrote:

> Hello everyone,
>
> I am glad to share that I have decided to launch an excel knowledge website
> for this group.The website will be launched on 4th anniversary of this group
> i.e. 17th March 2011.
>
> The designing of the website and development of content has already been
> initiated by me.
> I will need your support time to time on content development & design too.
> Please let me know if you want to volunteer for writing the content or any
> other task in website development.
>
> The discussexcel.com domain will be used for this website. Its a long way
> to go & I am VERY EXCITED about the launch.
> Keep watching this space.
>
> Thanks & Best 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ if formula help

[Aindril De]

Hi Abhinda,

PFA the solution..

Regards,
Andy

On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit wrote:

> Dear All,
>
> please help me with  the formula where in I should get the result
>
> 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then
> B2-300, subsequelntly I hve tried but somehow i am not getting the desired
> result
>
> Regards
> Abhidha
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


PROBLEM (1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need it in seperate excel sheets

[Aindril De]

Hi Manjunath,

The solution provided in the link should suffice:

http://www.mvps.org/dmcritchie/excel/saveas.htm

Regards,
Aindril

On Tue, Nov 30, 2010 at 2:50 PM, Manjunath C wrote:

> Hi
>
> Can anyone help me, as I Have data in each tab, I need it in sperate
> excel sheet.
>
> Any macros available - appreciate your help in advance.
>
> Thanks
> Manjunath
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ sum duplicate value

[Aindril De]

Hi,

Looking at the data, the easiest you can use is SUMIF, instead of VLOOKUP

Regards,
Aindril

On Sun, Nov 14, 2010 at 12:55 PM, bhavya khanna  wrote:

> Hi Everyone.
>
> Can someone explain I have data in sheet 1 The columns Name and Production
> .  Now I want to fetch data in sheet 2  . I use vlookup on the basis of Name
> and fetch the production . But I have a problem. In the Name Columns There
> is Duplicate of A but production is different. So Can you tell me please how
> can we sum that value. Please find the attache sheet.
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Please help regard this question

[Aindril De]

Hey Jai,

Supposing the dates are in cells A1 and A2, you can use the following in
cell A3:

=DATEDIF(A2,A1,"y")&IF(DATEDIF(A2,A1,"y")>1," years ,"," year
,")&DATEDIF(A2,A1,"ym")&IF(DATEDIF(A2,A1,"ym")>1," months ,"," month
,")&DATEDIF(A2,A1,"md")&IF(DATEDIF(A2,A1,"md")>1," days left."," day left.")

Please modify accordingly.

Cheers,
Andy

On Fri, Nov 12, 2010 at 11:17 AM, Jai  wrote:

>   Dear  Groups
>
> First Cell
>
>  20/12/2011
>
>  Secound Cell
>
> 12/11/2010
>
>   Required Results
>
> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>
> DEAR GROUP MEMBER PLEASE HELP ME,
>
> I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL
>
>  Required Results
>
> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>
>   --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

[Aindril De]

Hi Ayush,

Thanks for the book.. It looks like a very handy resource to keep and refer
to.

Regards,
Aindril

On Tue, Nov 9, 2010 at 7:50 PM, ayush jain  wrote:

> Hi Andy,
>
> Attached is the book for your reference. *Please do not forward to our
> Google group and let them download from the URL.
> *
> Regards,
> Ayush Jain
>
> On Tue, Nov 9, 2010 at 5:27 PM, Aindril De  wrote:
>
>> Hi Ayush,
>>
>> Thanks a ton.. for the effort..
>> Something seems to be wrong at my end as the link you have given is not
>> opening..
>> Is there any way you can send the file to me plz..
>>
>> Cheers,
>> Andy
>>
>>
>> On Mon, Nov 8, 2010 at 7:35 PM, Ayush  wrote:
>>
>>> Dear Group Members,
>>>
>>> Good news for all of you !!
>>>
>>> Now you can download VBA macros ebook worth $45 for free.
>>>
>>> Here is the link to download :-
>>> http://recordexcelmacro.com/discussexcel.html
>>>
>>> I have talked to John Franco (Author) to get this eBook for our group.
>>> Please do not miss the chance to download the eBook. This eBook has
>>> 140 pages of valuable knowledge on recording macros and customize
>>> them.
>>>
>>> I am working with John to get more resources for you either free or
>>> paid.Keep watching this space.
>>>
>>> Feel free to forward this link and email to all your friends,
>>> coworkers and followers.
>>>
>>> So what are you waiting for...Download it now..
>>>
>>> Thanks.
>>>
>>> Best regards,
>>> Ayush Jain
>>> Microsoft MVP 2010
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>  --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

[Aindril De]

Hi Ayush,

Thanks a ton.. for the effort..
Something seems to be wrong at my end as the link you have given is not
opening..
Is there any way you can send the file to me plz..

Cheers,
Andy

On Mon, Nov 8, 2010 at 7:35 PM, Ayush  wrote:

> Dear Group Members,
>
> Good news for all of you !!
>
> Now you can download VBA macros ebook worth $45 for free.
>
> Here is the link to download :-
> http://recordexcelmacro.com/discussexcel.html
>
> I have talked to John Franco (Author) to get this eBook for our group.
> Please do not miss the chance to download the eBook. This eBook has
> 140 pages of valuable knowledge on recording macros and customize
> them.
>
> I am working with John to get more resources for you either free or
> paid.Keep watching this space.
>
> Feel free to forward this link and email to all your friends,
> coworkers and followers.
>
> So what are you waiting for...Download it now..
>
> Thanks.
>
> Best regards,
> Ayush Jain
> Microsoft MVP 2010
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ small help

[Aindril De]

Hi Sidhu,

Please find attached the solution.

Regards,
Andy

On Tue, Nov 9, 2010 at 3:36 PM, sudarshan rampe  wrote:

> hi friends
> plz find the attached sheet in which i want a formula in which if i enter
> the month it should give no. of days of a month in the next column. please
> help me out
> --
> Sidhu
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


New Microsoft Excel Worksheet.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Urgent Help needed

[Aindril De]

Hi,

It looks like your calculations are not working as you are Displaying the
numbers as text. For Example:
The following Formula:
=
IF(sheet1!Q2>74,"1",IF(sheet1!Q2>69,"2",IF(sheet1!Q2>64,"3",IF(sheet1!Q2>59,"4",IF(sheet1!Q2>49,"5",IF(sheet1!Q2>44,"6",IF(sheet1!Q2>39,"7",IF(sheet1!Q2>29,"8",IF(sheet1!Q2>1,"9","")

Can be written as:
=
IF(sheet1!Q2>74,1,IF(sheet1!Q2>69,2,IF(sheet1!Q2>64,3,IF(sheet1!Q2>59,4,IF(sheet1!Q2>49,5,IF(sheet1!Q2>44,6,IF(sheet1!Q2>39,7,IF(sheet1!Q2>29,8,IF(sheet1!Q2>1,9,"")

"1" (text) changed to 1 (numeric)

After you have modified your formulas, then in the final column you can use
the formula:

=IF(COUNTIF(A2:BL2,"missed")<8,"Missed",SUM(D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2))

Copy down the formula to the last row of your range and it should give you
the desired result.

Regards,
Andy

On Tue, Nov 2, 2010 at 5:36 PM, Aindril De  wrote:

> Hi Ayoub,
>
> Can you please explain this:
>
> Of these columns some lack data if less than 8 of the above columns lack
> data word "missed" should appear
>
> Regards,
> Andy
>
> On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande  wrote:
>
>> Good afternoon
>> I need some help on a project that is buzzing ma head
>> attached is the excel file
>> help is need on sheet 2
>> 1) I need a formula to find the sum of the least  8 columns
>> 2) The columns are
>> D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2
>> 3) Of these columns some lack data if less than 8 of the above columns
>> lack data word "missed" should appear
>>
>>
>> --
>> Ayoub Kakande
>> 0772656158 / 0703516660
>> Data - Mujhu
>> Mulago Hosp
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Urgent Help needed

[Aindril De]

Hi Ayoub,

Can you please explain this:

Of these columns some lack data if less than 8 of the above columns lack
data word "missed" should appear

Regards,
Andy

On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande  wrote:

> Good afternoon
> I need some help on a project that is buzzing ma head
> attached is the excel file
> help is need on sheet 2
> 1) I need a formula to find the sum of the least  8 columns
> 2) The columns are
> D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2
> 3) Of these columns some lack data if less than 8 of the above columns lack
> data word "missed" should appear
>
>
> --
> Ayoub Kakande
> 0772656158 / 0703516660
> Data - Mujhu
> Mulago Hosp
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ OPEN EXCEL - Needs your support and enthusiasm...

[Aindril De]

Dear Ashish,

I just downloaded the Open Excel.
It looks like a neat set of features.
Excellent work...
Would like to contribute to it, whever I get some time...

Cheers,
Andy

On Sun, Oct 31, 2010 at 11:27 PM, Ashish Jain wrote:

> Dear Members,
>
> We're proud to launch OPEN EXCEL under the GNU Public License v3 which
> means it's available with source code to reach the maximum users
> around the globe with rapid development, more robust & innovative
> features. Since, public forums like these are hub of great
> professionals, knowledge sharers and bug shooters, hence we thought to
> launch it here. While beginners may download it, use it and can learn
> from it, amateur, experienced and professionals may contribute their
> some time and mind in developing it further ...
>
> Below are Google project links to download, develop and suggest new
> features in OPEN EXCEL :)
>
> Download - http://code.google.com/p/openexcel/downloads/list
> Suggest New Feature - http://code.google.com/p/openexcel/issues/list
> Develop - Reply this post with your mail id, so that you can be added
> as developer in the project and project's mailing lists.
>
>
>
>
>
> Thanks & Regards
> Ashish Jain
> McKinsey India Knowledge Center
> (Microsoft Certified Application Specialist)
> (Microsoft Certified Professional)
> http://www.excelitems.com
> http://www.openexcel.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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ vlookup? sumproduct? sumif? argghhh!?

[Aindril De]

Hi Michael,

It would be easy for anyone in the group to respond, if you can send a set
of sample data.

Regards,
Andy

On Tue, Oct 12, 2010 at 5:35 AM, MikeMikeMike wrote:

> First of all thank you for any effort put in this direction. I am
> having problems with a couple excel formulas that I really need to get
> right for a client.
>
> Here is the deal:
>
> WORKSHEET 1
> Column1 = email address
> Column2 = ***This column I want the sum of events on new years but
> having problems (Stuck)
>
> WORKSHEET 2
> Column1 = email address
> Column2 = if an event is on new years indicated with a 1 if it is on
> new years and blank if it is not.
>
> I guess where I am confused is I do not know if it is best to do the
> summing in a column3 of WORKSHEET 2 and then use a Vlookup to pull
> that data into Column2 of WORKSHEET 1. OR if the summing should happen
> in the same formula as the vlookup??
>
> Any help with this is most appreciated!
>
> One thousand thank you's!
>
> -Michael
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Rupee symbol on PC

[Aindril De]

Hi,

I accidentally found an answer to the question put up by N Shivkumar. So
wanted to share the same, though I am sure most of you must have found the
solution to this. Following are the steps:

1) Select the column/cell where you want to have the format with the
new ` rupee
symbol.
2) Change the format of the cell to Currency.
3) Go to Cell Format -> Choose Custom and paste the following:
[>999]"` "##\,##\,##\,##0.00;[>9]"` "##\,##\,##0.00;`##,##0.00
4) Change the font of the column/cell selected to Rupee Fordian.
And thats all you need.

You can now use the format painter to replicate this same format across
wherever required.

Cheers,
Andy


On Wed, Sep 8, 2010 at 12:14 PM, N.Shivkumar  wrote:

> Thanx a lot I would like to know how to have the new symbol in the below
> mentioned format :
>
> [>999]"Rs. "##\,##\,##\,##0.00;[>9]"Rs.
> "##\,##\,##0.00;Rs.##,##0.00
> N.SHIVKUMAR
>
>  --
>
> --
> 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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

[Aindril De]

Hi C.G.,

Could you please elaborate more on what condition you would like to put in
here?

Regards,
Andy

On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar wrote:

> I am looking for conditional sum i.e. sum based on criteria. But neither
> Sumproduct nor SUMIFS and Pivot serve the purpose.
>
> Attached sample file . Hope you will be able to solve the crux.
>
>
> Regards,
>
> C.G.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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

[Aindril De]

Hey Ayush!! You haven't responded to Neil's email

Where is the Treat Man!!!?  [?][?]

Cheers,
Andy

On Mon, Oct 4, 2010 at 9:17 PM, krishna mummina wrote:

> Congratulations Ayush Jain. Really Very proud of you man.
>
> On 10/4/10, rajasekhar praharaju  wrote:
> > hearty congratulations ayush, you really deserve it
> >
> > Infact you are good encyclopedia for us.
> >
> > Have a flamboyant future and delightful moments for ur future endeavors.
> >
> > Regards,
> > Raj
> >
> > On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:
> >
> >> Dear Group,
> >>
> >> I am proud to announce that I am awarded Microsoft Most Valuable
> >> Professional MVP on October 01, 2010 for providing technical expertise
> >> in Excel technical communities for past one year.
> >>
> >>
> >>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
> >>
> >> This is a prestigious award from Microsoft given every Quarter to the
> >> people who share their deep knowledge, real-world experience, and
> >> impartial, objective feedback to help people enhance the way they use
> >> technology.
> >>
> >> My deep thanks to each group member for all your support and
> >> contribution to this group.
> >>
> >> Best regards,
> >> Ayush Jain
> >> Microsoft MVP
> >>
> >> --
> >>
> >>
> --
> >> 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
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >>
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
> >>
> >
> > --
> >
> --
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
> >
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
<<982.gif>>

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

[Aindril De]

Congratulations Brother!!

You deserved it!!!

Cheers,
Andy

On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:

> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertise
> in Excel technical communities for past one year.
>
>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>
> This is a prestigious award from Microsoft given every Quarter to the
> people who share their deep knowledge, real-world experience, and
> impartial, objective feedback to help people enhance the way they use
> technology.
>
> My deep thanks to each group member for all your support and
> contribution to this group.
>
> Best regards,
> Ayush Jain
> Microsoft MVP
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Hi

[Aindril De]

Hi Pankaj,

In your attached example put the following formula in cell C2 and copy it
down:

=IF(NOT(ISERROR(VLOOKUP(B2,$A$2:$A$8,1,0))),"Match","Mismatch")

The above formula matches the entries in the Column B with the column A.

Pl let me know if this works for you.

Regards,
Andy

On Thu, Sep 30, 2010 at 9:15 PM, Pankaj Kumar wrote:

> Hi, exper it urgent i need u r help i attached my excel sheet
>
> --
>  *Warm Regards
> Pankaj kumar
> M: 9899816107
> e-mail: rajputpanka...@gmail.com
>rajputpank...@yahoo.in*
> *   rajputpankaj1...@rediffmail.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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

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

[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

Re: $$Excel-Macros$$ Cubic spline interpolation macro in VBA

[Aindril De]

Hi Pratik,

Dont know much about this, however I have googled this up for you:

http://www.business-spreadsheets.com/forum.asp?t=120

please check if this
works

Regards,
Andy

On Sun, Sep 19, 2010 at 12:34 AM, Pratik  wrote:

> Hi,
>
> Can anybody help me find VBA macro to perform cubic spline
> interpolation?
>
> --
>
> --
> 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$$ Random Numbers generation

[Aindril De]

Hi Giorgio,

Looks like the issue was here:

*Function RandLotto(Bottom As Integer, Top As Integer, _

Amount As Integer) As String*

*
*

*When you copy paste the above it does not work.*

*
*

*Please replace the above lines with:*

*Function RandLotto(Bottom As Integer, Top As Integer, Amount As
Integer) As String*

It should work fine now

Cheers
Andy

On Sat, Sep 18, 2010 at 10:55 AM, Aindril De  wrote:

> Hi Giorgio,
>
> Use the following UDF.
>
> *Function RandLotto(Bottom As Integer, Top As Integer, _
>
> Amount As Integer) As String*
>
> Dim iArr As Variant
>
> Dim i As Integer
>
> Dim r As Integer
>
> Dim temp As Integer
>
>
>
> Application.Volatile
>
>
>
> ReDim iArr(Bottom To Top)
>
> For i = Bottom To Top
>
> iArr(i) = i
>
> Next i
>
>
>
> For i = Top To Bottom + 1 Step -1
>
> r = Int(Rnd() * (i - Bottom + 1)) + Bottom
>
> temp = iArr(r)
>
> iArr(r) = iArr(i)
>
> iArr(i) = temp
>
> Next i
>
>
>
> For i = Bottom To Bottom + Amount - 1
>
> RandLotto = RandLotto & " " & iArr(i)
>
> Next i
>
>
>
> RandLotto = Trim(RandLotto)
>
>
> *End Function*
>
>
> To use this UDF push *Alt*+*F11* and go *Insert*>*Module* and paste in the
> code. Push *Alt*+*Q* and save. The Function will appear under "*User
> Defined*" in the Paste Function dialog box (*Shift*+*F3*). Use the
> Function in any cell as shown below.
>
> *=RandLotto(1,20,8)*
> This would produce 8 unique random numbers between 1 and 20
>
> For further details you can visit the following link:
>
> http://www.ozgrid.com/VBA/RandomNumbers.htm
>
>
> Regards,
> Andy
>
>
> On Thu, Sep 16, 2010 at 7:07 PM, Giorgio  wrote:
>
>> All,
>> I need to build an excel that generates X unique series of 5 random
>> numbers, lottery style (no repetition in the same series and no
>> repetition across the series).
>> I know the function RANDBETWEEN, but how can I include the "no
>> repetition"?
>>
>> Thank you,
>> G
>>
>> --
>>
>> --
>> 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$$ Stock Monitoring from Raw data

[Aindril De]

You can use a pivot Table to resolve this issue

On Sat, Sep 18, 2010 at 4:16 PM, Kal xcel  wrote:

> Dear Experts,
>
> I am facing a problem to lookup data from another sheet. Please help me.
>
> Details is in attached file.
>
> Thanks in advance
>
> Kalyan
>
> --
>
> --
> 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$$ Help: Date to Days conversion

[Aindril De]

Hi Janet,

This can be possible if you have the dates in proper date format.
>From the data it seems that the dates are not in the proper format.
If you can enter the dates in a consistent format, then you can easily use
the following formula in Column C to get the days

=DATEDIF(A2,B2,"d") - Paste this formula in C2 and then copy it down.

Please let me know if you need any further help on this.

Regards,
Andy


On Sat, Sep 18, 2010 at 1:48 PM, janet dickson wrote:

> Hi Team,
>
> I have challenge, see attached file. I want to see days instead of dates
>
>
> Hugs en Love
>
> --
>
> --
> 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$$ Random Numbers generation

[Aindril De]

Hi Giorgio,

Use the following UDF.

*Function RandLotto(Bottom As Integer, Top As Integer, _

Amount As Integer) As String*

Dim iArr As Variant

Dim i As Integer

Dim r As Integer

Dim temp As Integer



Application.Volatile



ReDim iArr(Bottom To Top)

For i = Bottom To Top

iArr(i) = i

Next i



For i = Top To Bottom + 1 Step -1

r = Int(Rnd() * (i - Bottom + 1)) + Bottom

temp = iArr(r)

iArr(r) = iArr(i)

iArr(i) = temp

Next i



For i = Bottom To Bottom + Amount - 1

RandLotto = RandLotto & " " & iArr(i)

Next i



RandLotto = Trim(RandLotto)


*End Function*


To use this UDF push *Alt*+*F11* and go *Insert*>*Module* and paste in the
code. Push *Alt*+*Q* and save. The Function will appear under "*User Defined
*" in the Paste Function dialog box (*Shift*+*F3*). Use the Function in any
cell as shown below.

*=RandLotto(1,20,8)*
This would produce 8 unique random numbers between 1 and 20

For further details you can visit the following link:

http://www.ozgrid.com/VBA/RandomNumbers.htm


Regards,
Andy


On Thu, Sep 16, 2010 at 7:07 PM, Giorgio  wrote:

> All,
> I need to build an excel that generates X unique series of 5 random
> numbers, lottery style (no repetition in the same series and no
> repetition across the series).
> I know the function RANDBETWEEN, but how can I include the "no
> repetition"?
>
> Thank you,
> G
>
> --
>
> --
> 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$$ What is UBOUND and L Bound In VBA (Excel Macros)

[Aindril De]

HI,

The largest available subscript for the indicated dimension of an array can
be obtained by using theUbound function.  In our one-dimensional array
example, Ubound(arr) is 5.

In our two-dimensional array example above, there are two upper bound
figures - both are 2.
UBound returns the following values for an array with these dimensions*:

 Dim A(1 To 100, 0 To 3, -3 To 4)

 Statement Return Value
 UBound(A, 1) 100
 UBound(A, 2)3
 UBound(A, 3)4

* Example taken from Excel VBA Help section.

The UBound function is used with the LBound function to determine the size
of an array. Use theLBound function to find the lower limit of an array
dimension.

 Statement Return Value
 LBound(A, 1)1
 LBound(A, 2)0
 LBound(A, 3)   -3

To get the size of an array, use the following formula:

UBound(Arr) - LBound(Arr) + 1

For example:

Ubound(A,1) - LBound(A,1) + 1
= 100 - 1 + 1
= 100

Ubound(A,2) - LBound(A,2) + 1
= 3 - 0 + 1
= 4

Ubound(A,3) - LBound(A,3) + 1
= 4 - (-3) + 1
= 8

For more details please visit
http://www.anthony-vba.kefra.com/vba/vbabasic3.htm

Cheers
Andy

On Sun, Sep 5, 2010 at 12:53 PM, bhavya khanna  wrote:

> Hi Everyone.
>
> Can Someone explain About Ubound and Lbound in Excel VBA  with Example. Or
> sending some attached sheet.
>
> Thanks and Regards
>
>  --
>
> --
> 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$$ Formula for Military Time Calculations

[Aindril De]

Hi John,

Could you send a sample set of data.

Regards,
Andy

On Thu, Sep 2, 2010 at 11:41 PM, JohnA  wrote:

> I need to determine time increments from postings in Excel in the 24
> hour mode (commonly called military time).
>
> I can't come up with a formula to give me decimal hours from military
> time subtractions.
>
> Help please!
>
> JohnA
>
> --
>
> --
> 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$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

[Aindril De]

Hi,

1. You need to press Alt+F11, and open the visual basic editor.
2. Double click on "This Workbook"
3. Paste the code.
*Private Sub Workbook_Open()*

Sheets("Sheet2").Select
Range("A494").Select

*End Sub*
4. Save the file (For XL 2003 as .xls , or for XL 2007 as .xlsm)
5. Close the file and try to open it.

This should run the code.

NOTE: The macro might not run in case the macro security is set to High. You
have to lower the Macro Security to make it work.

Please let me know if you need any further help on this.

Regards,
Aindril

On Thu, Sep 2, 2010 at 6:10 PM, big smile  wrote:

> Sir.
>
>
> Thanks for your fast reply.
>
> I have put this in View Code. -- but stil it does not work until i press
> run in view code.
>
> I have  another function also in that as follows
>
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
> Cancel = True
> Target.EntireRow.Insert
> End Sub
>
> due to which the problem comes
>
> Whenever i close my cursor is  for Ex. on A392  & but whenever i reopen
> this file
>
> it should be on ex. A494.
>
>
> One more thing the soultion given by Michael Brumby that i know sir  Then
> also thanks for the answer.
>
> Thanks
>
> Have a nice day
> CP SAVLA
>
>
>
>
>
>
> On Thu, Sep 2, 2010 at 1:05 PM, Aindril De  wrote:
>
>> Hi,
>>
>> Please use the following code:
>>
>> *Private Sub Workbook_Open()*
>>
>>  Sheets("Sheet2").Select
>> Range("A494").Select
>>
>> *End Sub*
>>
>> Cheers!
>> Andy
>>
>> On Thu, Sep 2, 2010 at 9:58 AM, big smile  wrote:
>>
>>> Respected Excel Guru's
>>>
>>> How to make the macro so that
>>>
>>> When ever i start the file my cursor goes into that particular cell only.
>>> For EX. Sheet 2 - A494 etc.
>>>
>>> The purpose behing this is ex. i have set the target of achieving certain
>>> amount -- so how much
>>>
>>> still pending to achieve.
>>>
>>>
>>> Thanks & have a nice day.
>>>
>>> C P SAVLA
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN g

Re: $$Excel-Macros$$ How to create Speedometer chart in Excel

[Aindril De]

Hi Pankaj,

Pl go through this link
http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm

Regards,
Andy

On Thu, Sep 2, 2010 at 12:39 PM, Intelligent But Crazy  wrote:

> Hi Experts,
>
>
> --
> Pankaj Pandey
> Bhopal
>
> --
>
> --
> 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$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

[Aindril De]

Hi,

Please use the following code:

*Private Sub Workbook_Open()*

Sheets("Sheet2").Select
Range("A494").Select

*End Sub*

Cheers!
Andy

On Thu, Sep 2, 2010 at 9:58 AM, big smile  wrote:

> Respected Excel Guru's
>
> How to make the macro so that
>
> When ever i start the file my cursor goes into that particular cell only.
> For EX. Sheet 2 - A494 etc.
>
> The purpose behing this is ex. i have set the target of achieving certain
> amount -- so how much
>
> still pending to achieve.
>
>
> Thanks & have a nice day.
>
> C P SAVLA
>
> --
>
> --
> 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$$ extract only product name

[Aindril De]

Hi Kalyan,

You can use the following formula in the cell B2 and then copy it down

=LEFT(A2,LEN(A2)-(LEN(A2)-FIND("^^",SUBSTITUTE(A2," ","^^",LEN(A2)
-LEN(SUBSTITUTE(A2," ",""))

For more info on the above please check:
http://www.eggheadcafe.com/software/aspnet/28074391/need-to-find-first---from-right.aspx

Cheers
Andy

On Wed, Sep 1, 2010 at 3:41 PM, Kal xcel  wrote:

> Dear Experts,
>
> I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
> Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
> extract only product name (like: Skin Fruits Instant Fairness Fruit Bleach)
> from that string.
>
> File is attached.
>
> Thanks in advance
>
> Kalyan
>
> --
>
> --
> 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$$ Need Help in Cross tab

[Aindril De]

Hey Dave,

This is great!! you never stop amazing me with your simple solutions to
complex problems..
Keep it up man!!
You are a pillar of our group...

Cheers!!!
Andy

On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack
wrote:

>  Hi Shariq
> I've done this with worksheet functions, not VBA.
> The original formula is in B3 on the Report sheet. It's then just copied
> down, then copied across.
> If you really need it in VBA, it can be done easily enough, but this way
> updates instantly with any change to the DATA sheet; and some people don't
> like opening or receiving files with macros.
> Regards - Dave.
>
> > Date: Sat, 21 Aug 2010 13:26:35 +0530
> > Subject: $$Excel-Macros$$ Need Help in Cross tab
> > From: shariqcoo...@gmail.com
> > To: excel-macros@googlegroups.com
>
> >
> > Hi All,
> >
> > I need your help, as I’m unable to solve the problem which I’m going
> > to explain you guys……..
> > Please refer the attached the excel with two tabs “Data” and “Report”
> > On Data tab I have three columns loaded and Date and hours. Now I need
> > a macro code to generate a report actually the cross between Date and
> > Hours(we don’t have duplicate hours in date) and the we have max 22
> > hours in a date . if we have particular hours is the Data tab under a
> > date then we need to flag the value with “Yes” under the fixed
> > location of that hours in Report Tab.
> >
> > I hope you guys understand what I need. I cannot use pivot table.
> > If you look into the attached excel you will get an idea what I need.
> > Please help me guys…….
> > Thanks in advance
> >
> >
> >
> > Thanks and Reagrd’s
> > Shariq
> >
> > --
> >
> --
> > 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
>

-- 
--
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$$ Ageing of data

[Aindril De]

Hi Antony,

Assuming that the Header "Start date" is in Cell A1, please use the
following formula in the "Category" column:
=IF(AND(C2>=0,C2<=30),1,IF(AND(C2>=31,C2<=60),2,IF(AND(C2>=61,C2<=90),3,IF(AND(C2>=91,C2<=120),4,IF(C2>=120,5,"")

Please let me know if this helps or u need any further help on this.

Regards,
Andy

On Sat, Aug 21, 2010 at 11:36 AM, Antony  wrote:

> Hi Experts,
>
> Could anyone help me to have difference between two dates into
> different categories.
> For eg:
>
> Start date  End dateDifference  Category
> 6/6/20109/6/201092  4
>
> Categories  Values
> 0-301
> 31-60   2
> 61-90   3
> 91-120  4
> >1205
>
>
> Thanks in advance,
> Antony
>
> --
>
> --
> 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$$ Birthdays list formula or macro

[Aindril De]

Hi Phillip,

Please find attached the solved workbook.
Do let me know if it helps or you need further help.

I have added some other features other than your requirement which I felt
might come handy, as well, which will predict the following:
Today (As required)
Tomorrow (As required)
Day After (As required)
After x Days (Added)
Not in this month (Added)

Cheers,
Andy

On Sat, Aug 21, 2010 at 4:04 AM, Phillip Swanepoel wrote:

> Hi all
>
> Attached is a sample work book.
>
> In column b down i got birthdays.  next to that the persons name.
>
> B2 will be either =today()  or =now()  (or something else that will trigger
> the days date...
>
> how can i display in a column who has a birthday today or tomorrow?
>
>
> Phillip Swanepoel
> pswa...@gmail.com
> (JanPhi)
> 0825360597
> 0287134213
>
>  34° 4'58.48"S,  21°14'51.33"E
>
>
>
> This email has been forwarded using a mobile phone with a internet/wap
> application. Go to www.operamini.com for more info
>
> --
>
> --
> 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


birthdays-Andy.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Save As Excel Workbook Macro

[Aindril De]

Hi Steve,

In Excel 2007 certain things have changed in the VBA front as well. While
saving the file in any XML format that is .xlsx in this case, you need to
supply the file fomat value as well. The following link will give you
further details on this.

http://www.rondebruin.nl/saveas.htm
Regards,
Andy
On Thu, Aug 12, 2010 at 10:13 PM, Steve  wrote:

> Hi,
>
> I have this macro that someone had helped me with quite a while ago.
> It was working fine until I went to update it to work for Excel 2007.
>
> The macro below is what it was until I changed ".xls" to ".xlsx".
>
> 'SaveAsExcelWorkbook2()
> 'Remember to add the reference to Microsoft Scripting Runtime
> Dim TheFileName
> Dim fso As FileSystemObject
> Set fso = New FileSystemObject
> TheFileName = fso.GetBaseName(ActiveWorkbook.Name) & ".xls"
> TheFileName = Application.GetSaveAsFilename(TheFileName, _
> FileFilter:="Microsoft Office Excel Workbook (*.xls),*.xls")
>
> If (TheFileName <> False) Then _
> ActiveWorkbook.SaveAs Filename:=TheFileName, FileFormat:=xlNormal, _
> Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
> CreateBackup:=False
> Set fso = Nothing
>
>
>
> I also had another part of the macro that I had to change the number
> of rows to
> like 600K. Anyhow, the changes seem to work until the very end when I
> get a
> pop-up like the following:
>
> "Compatibility Report for NON POC-FIX.xlsx
> Run on 8/11/2010 17:42
>
> The following features in this workbook are not supported by earlier
> versions of
> Excel. These features may be lost or degraded when you save this
> workbook in an
> earlier file format.
>
> Significant loss of functionality # of occurrences
>
> This workbook contains data in cells outside of the row and column
> limit of the
> selected file format. Data beyond 256 (IV) columns by 65,536 rows will
> not be
> saved. Formula references to data in this region will return a #REF!
> error."
>
>
>
> Anyhow, I'd like to figure out what is causing the pop-up for
> compatibility to show up and figure out why the file that is being
> created now is corrupt and won't open.
>
> Thanks,
>
> Steve
>
> --
>
> --
> 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$$ Can we find left Value through VLOOKUP formula..

[Aindril De]

Hi Noorain,

Vlookup cant do this.. However u can use the Offset and Match formula
combination to do this..
The following link has the solution...
Look at the section "Left Lookups"

http://www.cpearson.com/excel/TablesAndLookups.aspx

Regards,
Andy

On Wed, Aug 11, 2010 at 2:46 PM, NOORAIN ANSARI wrote:

> Dear Experts,
>
> Can we find left Value through VLOOKUP formula..Please need your
> co-operation..
>
> Example...
>
> I want to find Emp Name behalf of Emp ID through only VLOOKUP.
>
> Emp Name
> Emp ID  Noorain 22330  Sunil 22331
>
>
> --
> Thanks & regards,
> Noorain Ansari
> noorain.ans...@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
>

-- 
--
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$$ save all sheets as csv and KEEP xls format open for edit (Excell 2003)

[Aindril De]

Hey Rolf,

You can use the following Code.

Public Sub SaveWorksheetsAsCsv()

Dim WS As Excel.Worksheet
Dim SaveToDirectory As String

Dim CurrentWorkbook As String
Dim CurrentFormat As Long

 CurrentWorkbook = ThisWorkbook.FullName
 CurrentFormat = ThisWorkbook.FileFormat
' Store current details for the workbook

  SaveToDirectory = "D:\" 'You can change to any Directory where you
want to save the file

  For Each WS In ThisWorkbook.Worksheets
  WS.SaveAs SaveToDirectory & WS.Name, xlCSV
  Next

End Sub


Cheers!!,
Andy

On Sun, Aug 8, 2010 at 7:05 PM, rolf.kem...@renesas.com <
rolf.kem...@renesas.com> wrote:

> Dear All,
>
> I'm new to this group and my programming skills in VBA are a bit
> outdated.
> Writing some csv file is quite easy, but I have some restrictions with
> it.
>
> Hoever, I would like to ask for some quick help on this:
> I have a workbook (active) and want to create a vba macro manages to:
> 1) save all sheets in this workbook as CSV files with the name of the
> sheet
> 2) ensure that the csv files have no limits in accessing them by other
> tools while the wokbook is still open
> 2) keep the workbook in xls format open ( to edit further on )
>
> Any code snipet which helps is welome.
>
> Thanks a lot
>
> Rolf
>
> --
>
> --
> 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$$ Open pipe delimited file

[Aindril De]

Hi Mat,

Open the file in Excel. You will find all the information in Column A.
Select Column A and then Use Text To Columns Feature in Excel.
Choose the Delimited option. And the the Next Screen you will have a place
to type a customized delimiter.
Type the Pipe symbol in that and click finish if you see the preview to be
correctly showing the data.

If you still have any problem, send the file to me I will do it for you.

Regards,
Andy

On Mon, Aug 9, 2010 at 9:16 AM, Mat  wrote:

> Hi all,
>
> When I open a pipe delimited file in excel it opens the file but does
> not put the data per cell as expected. Is there an option to have
> excel open a pipe delimited file appropriately as it does for comma
> delimited files?
>
> Thanks,
>
> Mat
>
> --
>
> --
> 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$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

[Aindril De]

By default, Microsoft Office Excel 2003 and Microsoft Excel 2002 recalculate
files that were last saved in an earlier version of Excel. This ensures that
any improvements made to the Excel calculation engine are applied to all
formulas in the workbook.

To prevent Excel 2003 or Excel 2002 from automatically recalculating
workbooks saved in earlier versions, follow these steps:

   1. On the *Tools* menu, click *Options*.

   *NOTE*: The *Options* command is only available when a workbook is open.
   If it is not available, click *New* on the *File* menu, and then
click *Blank
   Workbook* in the *New Workbook* task pane.
   2. Click the *Calculation* tab. Under *Calculation*, click *Manual*.
   Click to clear the*Recalculate before save* check box.
   3. Click *OK*.

Regards,
Andy


On Sat, Aug 7, 2010 at 5:52 PM, Aindril De  wrote:

> Hi Rahul,
>
> Which version of Excel are you using?
>
> Regards
> Andy
>
>
> On Sat, Aug 7, 2010 at 5:08 PM, rahul  wrote:
>
>> When you open a workbook and then close it with out making any
>> changes, you are prompted as follows:
>> Do you want to save the changes to Filename.xls?
>>
>> Microsoft Excel recalculates formulas when opening files last saved by
>> an earlier version of Excel.
>>
>> How to get rid of this problem
>>
>> File is uploaded on the below link
>>
>> http://www.sendspace.com/file/ztjm60
>>
>> Can any one please help me out.
>>
>>
>> Regards
>> Rahul
>>
>> --
>>
>> --
>> 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$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

[Aindril De]

Hi Rahul,

Which version of Excel are you using?

Regards
Andy

On Sat, Aug 7, 2010 at 5:08 PM, rahul  wrote:

> When you open a workbook and then close it with out making any
> changes, you are prompted as follows:
> Do you want to save the changes to Filename.xls?
>
> Microsoft Excel recalculates formulas when opening files last saved by
> an earlier version of Excel.
>
> How to get rid of this problem
>
> File is uploaded on the below link
>
> http://www.sendspace.com/file/ztjm60
>
> Can any one please help me out.
>
>
> Regards
> Rahul
>
> --
>
> --
> 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$$

[Aindril De]

Sorry got your name wrong

On Thu, Aug 5, 2010 at 10:22 AM, Aindril De  wrote:

> Hi Prabhat,
>
> This is happening because the column date contains actual dates and not
> months. However I have added a column called month, which takes care of the
> issue.
> PFA the solution Its in Sheet6.
>
> Regards,
> Aindril
>
>
> On Wed, Aug 4, 2010 at 10:49 PM, prabhakar thakur <
> prabhakarthak...@gmail.com> wrote:
>
>> Dear Group,
>>   I need help to a month & year wise report, I
>> made a povit but month repate again & again.
>>
>>
>> --
>> Thanks,
>> Prabhakar Thakur
>> New Delhi
>> +919953736776
>>
>> --
>>
>> --
>> 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$$ Need Help

[Aindril De]

Hi I have responded to your email
sent before pl chk and see if this is what u wanted
Regards,
Andy

On Thu, Aug 5, 2010 at 9:48 AM, prabhakar thakur  wrote:

> Hi All,
> Please help.
>
> Thanks,
> Prabhakar Thakur
> New Delhi
> +919953736776
>
>
>
> On Wed, Aug 4, 2010 at 10:49 PM, prabhakar thakur <
> prabhakarthak...@gmail.com> wrote:
>
>> Dear Group,
>>   I need help to a month & year wise report, I
>> made a povit but couldn't get correct report.
>>
>>
>> --
>> Thanks,
>> Prabhakar Thakur
>> New Delhi
>> +919953736776
>>
>> --
>>
>> --
>> 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
>

-- 
--
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$$ Format Problem

[Aindril De]

Looks like a part of the content in the file is corrupt..and cannot be
repaired

Regards,
Andy

On Mon, Aug 2, 2010 at 3:56 PM, Deepak Rawat wrote:

> Hi all
>
> This is a excel file and its not opening normally can anybody fix the
> problem.
>
> Regards,
> Deepak
>
> --
>
> --
> 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$$ how to enable macros?

[Aindril De]

Which version of Excel are you using??
In Excel 2003:

To allow unsigned macros to run, the *Trust all installed add-ins and
templates* check box must be selected on the *Trusted Publishers* tab of the
*Security* dialog box. This option is selected by default. If it is not
selected (recommended), Excel allows you to run only macros that have
trusted digital signatures.

   1. On the *Tools* menu, point to *Macro*, and then click *Security*.
   2. On the *Trusted Publishers* tab, select the *Trust all installed
   add-ins and templates* check box.

In Excel 2007:

You can change macro security settings in the Trust Center, unless a system
administrator in your organization has changed the default settings to
prevent you from changing the settings.

   1. On the *Developer* tab, in the *Code* group, click *Macro Security*.

* Tip *  If the *Developer* tab is not displayed, click the *Microsoft
Office Button* [image: Button image], click *Excel Options*, and then in the
*Popular* category, under *Top options for working with Excel*, click *Show
Developer tab in the Ribbon*.

   1. In the *Macro Settings* category, under *Macro Settings*, click the
   option that you want.

* Note *  Any changes that you make in the *Macro Settings* category in
Excel apply only to Excel and do not affect any other Microsoft Office
program.

* Tip *  You can also access the Trust Center in the *Excel Options* dialog
box. Click the *Microsoft Office Button* [image: Button image], and then
click *Excel Options*. In the *Trust Center* category, click *Trust Center
Settings*, and then click the *Macro Settings* category.

Regards,
Andy
On Fri, Jul 30, 2010 at 12:25 PM, Pooja S  wrote:

>
> hi
>
> there is a problem in opening an excel file with macros...wht should be
> done to open the excel file with macros?
> pls rply soon..it is urgent
> --
> Pooja
>
> --
>
> --
> 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$$ How to ADD product of two columns in a single cell

[Aindril De]

Use =SUMPRODUCT(A1:A3,B1:B3)

Assuming Column 1 is A and Column 2 is B

Cheers
Andy

On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal  wrote:

> Please help to add the product of two columns e.g.
>
> Column1Column2
>
> 23 119
> 8954
> 63   32
>
> Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2)
>
> Thanks Ravi
> --
>
> --
> 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$$ XML files to Excel

[Aindril De]

http://www.youtube.com/watch?v=r0S2CQd46C4

On Tue, Jul 20, 2010 at 9:33 PM, Aindril De  wrote:

> Try this
>
> http://www.forgram.com/
>
> <http://www.forgram.com/>Regards,
> Andy
>
>
> On Tue, Jul 20, 2010 at 12:59 AM, Al  wrote:
>
>>
>> Dear All :
>>
>> I have bunch of xml files, i would like to convert them in to  an
>> excel sheet ..
>> how can this be done ?
>>
>> Thanks in advance
>> Al
>>
>> --
>>
>> --
>> 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$$ XML files to Excel

[Aindril De]

Try this

http://www.forgram.com/

Regards,
Andy

On Tue, Jul 20, 2010 at 12:59 AM, Al  wrote:

>
> Dear All :
>
> I have bunch of xml files, i would like to convert them in to  an
> excel sheet ..
> how can this be done ?
>
> Thanks in advance
> Al
>
> --
>
> --
> 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$$ Need SUMIF with 3 criteria

[Aindril De]

You can simply use SUMIFS if you are using excel 2007

On Tue, Jul 20, 2010 at 11:49 AM, saggi  wrote:

> =SUM(IF(($A$1:$A$15=A2)*($D$2:$D$50=D8)*($C$3:$C$30=C5),1,0))
>
> This way you can use Sum IF formula for 3 Condition
>
> --
>
> --
> 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$$ Using Excel to Control Shapes Drawn In A Workbook

[Aindril De]

Thanks Dave...
This opens a new angle of experimenting with Excel for me...

Cheers!!
Andy

On Thu, Jul 15, 2010 at 9:53 PM, Vijay Aggarwal wrote:

> Hi Dave,
>
> It's really amazing!!!
>
> How could u do this??
>
>
> regards,
> Vijay
>
> On Tue, Jul 13, 2010 at 4:54 AM, Dave Bonallack  > wrote:
>
>>  Hi,
>> The attached contains a basic event macro. Change any cell in the range
>> A1:A4 to change the rectangle's size and position.
>> You may be able to adapt it for your own needs.
>> Regards - Dave.
>>
>> > Date: Mon, 12 Jul 2010 12:43:39 -0700
>> > Subject: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A
>> Workbook
>> > From: haymake...@gmail.com
>> > To: excel-macros@googlegroups.com
>>
>> >
>> > Dear Excel Experts,
>> >
>> > A former professor of mine had a series of Excel spreadsheets
>> > that he used to calculate properties of structural elements. Within
>> > these spreadsheets he drew shapes (such as rectangles, circles,
>> > triangles, etc..) using Excel's shapes tool. He would then enter in
>> > data (such as the height of a beam or column) into a cell in a given
>> > workbook and the shape would change relative to its original size. So
>> > basically I am asking:
>> >
>> > How do I change the size or properties of a shape drawn in an Excel
>> > workbook based on the input in a certain cell?
>> >
>> > I would like to create spreadsheets that would calculate material
>> > properties of common structural engineering elements that have some
>> > sort of visual element to them. I am fairly new to visual basic and
>> > macros, so if any of you can help me, please keep things very simple
>> > (if possible). Thanks so much anything you all can do for 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
>>
>> --
>> Australia's #1 job site If It Exists, You'll Find it on 
>> SEEK
>>
>> --
>>
>> --
>> 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
>

-- 
--
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, s

Re: $$Excel-Macros$$ Count months

[Aindril De]

Dear Nadine,

Assuming cell A1 has Apr-Jun. In Cell B1 you can
type =MONTH(1&RIGHT(A1,3))-MONTH(1&LEFT(A1,3)) to get the desired result.

Cheers,
Andy

On Thu, Jul 15, 2010 at 10:43 PM, Nadine S  wrote:

> If a cell says Apr - Jun what formula is there to count how many months
> that is?  The month range is in one cell and the formula would be in
> another.  Thanks.
> Nadine
>
>  --
>
> --
> 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$$ Help Reqired Loop in macros

[Aindril De]

Hi Venkat,

*

The purpose of a loop is to get Excel to repeat a piece of code a certain
number of times. How many times the code gets repeated can be specified as a
fixed number (e.g. do this 10 times), or as a variable (e.g. do this for as
many times as there are rows of data).

Loops can be constructed many different ways to suit different
circumstances. Often the same result can be obtained in different ways to
suit your personal preferences. These exercises demonstrate a selection of
different ways to use loops.

There are two basic kinds of loops, both of which are demonstrated here:
Do…Loop and For…Next loops. The code to be repeated is placed between the
key words.

Please refer to the attached link below and the example attached to it for
further clarity.

http://www.exceltip.com/st/Using_Loops_in_VBA_in_Microsoft_Excel/628.html

Please let me know if u need any further help on this.

Cheers!!,

Andy
*
On Tue, Jul 6, 2010 at 3:31 PM, Venkatesan c  wrote:

> Dear Group,
>
> What you mean by Loop in Macros&Use .can i have explanation with Example
>
>  Best Regards,
> *
>
> Venkat
> *
>
> --
>
> --
> 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$$ How to alter the contents of a row in a sheet

[Aindril De]

Hi Alex,

Please find attached the solution.
I have used the following code inside a module
Sub village()

' This loop runs until there is nothing in the last cell
' Aindril De (Andy)

Do

ActiveCell.Value = "[village]" & ActiveCell.Value & "[/village]"

ActiveCell.Offset(1, 0).Select

Loop Until IsEmpty(ActiveCell)

End Sub

*To run this code. click on the first cell where you want to start the
changes (in my example it is cell B2) and then click on the button named
village.*

Pl let me know if u need any further help on this.

Cheers!!,
Andy

On Tue, Jul 6, 2010 at 8:11 PM, Alexander Cargill <
zanderman1...@googlemail.com> wrote:

>
>
>
>
> Hi All I was wondering if you could help.  I have a column of data which is
>  Column B  within a sheet that I wish to alter, the data has the following
> format : XXX|XXX and I wish to change the contents of the cells in the
> column  from XXX|XXX to [village]XXX|XXX[/village] using a single button. So
> essentially I want to add the text [village] before the co-ords and the text
> [/village] after the co-ords in each cell in column B can anyone help??
>
>
>
> Thanks very much Alex
>
>
>
> Ps I can supply the sheet if needed J
>
> --
>
> --
> 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


Alexander.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Running Count for particular data

[Aindril De]

Hi Sameer,

PFA the solution,

Regards,
Aindril

On Mon, Jul 5, 2010 at 6:00 PM, Sameer Wagh  wrote:

> I want avoid sorting the data as far as possible .
>
> thanks
>
>
> On Mon, Jul 5, 2010 at 5:49 PM, WizExcel  wrote:
>
>> Dear Experts,
>>
>> want to know if there is way / function for having a "running" count
>> in Excel. I have tried COUNTIF and most of the Count Functions , but
>> all give "total" count and not the "Running" Count.
>>
>> Example: See below.
>>
>> The Count for HDFC Bank should be 1, 2 . and then finally 3. and
>> then similarly for other Banks. What the CountIF function shows is the
>> TOTAL count.
>>
>>
>>
>>  How it is happening now using CountIF:
>>
>> BankCount
>> HFDC Bank 3
>> SBI Bank2
>> SBI Bank2
>> HDFC Bank 3
>> Axis Bank   1
>> HDFC Bank 3
>>
>>
>> How  I want it :
>>
>> BankCount
>> HFDC Bank 1
>> SBI Bank1
>> SBI Bank2
>> HDFC Bank 2
>> Axis Bank   1
>> HDFC Bank 3
>
>
>
> --
>
> --
> 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


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

Re: $$Excel-Macros$$ Cell Capacity & filters

[Aindril De]

Sorry for the Typo
please read "text filter with Containg option" as"custom text filter with *
contains* option"

Regards,
Andy

On Mon, Jul 5, 2010 at 5:59 PM, Aindril De  wrote:

> Hi Iqbal,
>
> I don't know the way out.
> However, though it does not show up because of its length, you can still do
> a text filter with Containg option and search for something unique in that
> string to show that up in the result.
>
> Regards,
> Andy
>
>
> On Mon, Jul 5, 2010 at 5:04 PM, Iqbal Muneeb wrote:
>
>> Hi Dear ones.
>> I need help. Cells have a capacity of 255 characters, beyond which filters
>> do not work. Is there a wayout. I have a file where certain cells have very
>> long strings; they donot show up in the filter.
>> Please guide me. Thanks.
>>
>>
>> --
>> Have a good day!
>>
>> Muneeb
>> Cell: 0300 2213043
>>
>> --
>>
>> --
>> 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