Re: $$Excel-Macros$$ How to count the items except repetition

[Chandra Gupta]

Hi Pravin,

It will also help you.
=SUMPRODUCT((C3:C39<>"")/COUNTIF(C3:C39,C3:C39&""))

Regards




On Wed, Sep 5, 2012 at 11:10 AM, Amresh Maurya wrote:

> for  unique agency and unique city
>
> use this formula.
> =SUM(IF(FREQUENCY(MATCH(C3:C39,C3:C39,0),MATCH(C3:C39,C3:C39,0))>0,1))
>
> Regards
> Amresh
>
>
> On Wed, Sep 5, 2012 at 11:06 AM, Manoj Kumar 
> wrote:
>
>> Dear Amresh,
>>
>> if we need unique agency and unique city how can we find...
>>
>>
>> Regard
>> Manoj
>>
>>
>> On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya 
>> wrote:
>>
>>> Hi Pravin,
>>>
>>> find the attached solution.
>>>
>>> use this small formula.
>>>
>>> =COUNTA(C3:C39)
>>>
>>> Regards
>>> Amresh
>>>
>>>
>>> On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal wrote:
>>>
 Dear Friends,

 Greetings !

 Request for your help on the subject matter.

 I have attached the file for your reference, in which there are two
 different rows which are having repetition entries and I need to count them
 without deleting the records/ any of the rows.

 Thank you.

 Regards,
 Pravin Gunjal.

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



>>>
>>>  --
>>> 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.
>>>
>>>
>>>
>>
>>  --
>> 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.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> htt

$$Excel-Macros$$ Discounting factor for monthly payments

[sharad jain]

Hi,

Can someone give me a formula for calculating the discounting factor to get
present value of monthly interest payment?

Regards,
Sharad

-- 
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$$ How to count the items except repetition

[Amresh Maurya]

for  unique agency and unique city

use this formula.
=SUM(IF(FREQUENCY(MATCH(C3:C39,C3:C39,0),MATCH(C3:C39,C3:C39,0))>0,1))

Regards
Amresh


On Wed, Sep 5, 2012 at 11:06 AM, Manoj Kumar wrote:

> Dear Amresh,
>
> if we need unique agency and unique city how can we find...
>
>
> Regard
> Manoj
>
>
> On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya 
> wrote:
>
>> Hi Pravin,
>>
>> find the attached solution.
>>
>> use this small formula.
>>
>> =COUNTA(C3:C39)
>>
>> Regards
>> Amresh
>>
>>
>> On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal  wrote:
>>
>>> Dear Friends,
>>>
>>> Greetings !
>>>
>>> Request for your help on the subject matter.
>>>
>>> I have attached the file for your reference, in which there are two
>>> different rows which are having repetition entries and I need to count them
>>> without deleting the records/ any of the rows.
>>>
>>> Thank you.
>>>
>>> Regards,
>>> Pravin Gunjal.
>>>
>>> --
>>> 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.
>>>
>>>
>>>
>>
>>  --
>> 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.
>>
>>
>>
>
>  --
> 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.
>
>
>

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

Re: $$Excel-Macros$$ How to count the items except repetition

[੧ਓ ਦੀਪਕ ਗਿਰੋਤ੍ਰਾ ੧ਓ]

Hi
You Can Also Use
*Amresh Maurya Technic *
*or pivot table for counting *
*spratley*
---
Regard
ਦੀਪਕ ਗਿਰੋਤ੍ਰਾ
+91-9911568956
੧ਓ ਸਤਨਾਮ ਸ਼੍ਰੀ ਵਾਹੇਗੁਰੁ ੧ਓ



On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal  wrote:

> Dear Friends,
>
> Greetings !
>
> Request for your help on the subject matter.
>
> I have attached the file for your reference, in which there are two
> different rows which are having repetition entries and I need to count them
> without deleting the records/ any of the rows.
>
> Thank you.
>
> Regards,
> Pravin Gunjal.
>
> --
> 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.
>
>
>

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




How to count the items except repetition.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How to count the items except repetition

[Manoj Kumar]

Dear Amresh,

if we need unique agency and unique city how can we find...


Regard
Manoj

On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya wrote:

> Hi Pravin,
>
> find the attached solution.
>
> use this small formula.
>
> =COUNTA(C3:C39)
>
> Regards
> Amresh
>
>
> On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal  wrote:
>
>> Dear Friends,
>>
>> Greetings !
>>
>> Request for your help on the subject matter.
>>
>> I have attached the file for your reference, in which there are two
>> different rows which are having repetition entries and I need to count them
>> without deleting the records/ any of the rows.
>>
>> Thank you.
>>
>> Regards,
>> Pravin Gunjal.
>>
>> --
>> 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.
>>
>>
>>
>
>  --
> 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.
>
>
>

-- 
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$$ How to count the items except repetition

[Amresh Maurya]

Hi Pravin,

find the attached solution.

use this small formula.

=COUNTA(C3:C39)

Regards
Amresh

On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal  wrote:

> Dear Friends,
>
> Greetings !
>
> Request for your help on the subject matter.
>
> I have attached the file for your reference, in which there are two
> different rows which are having repetition entries and I need to count them
> without deleting the records/ any of the rows.
>
> Thank you.
>
> Regards,
> Pravin Gunjal.
>
> --
> 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.
>
>
>

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




How to count the items except repetition - Solved.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ How to count the items except repetition

[Pravin Gunjal]

Dear Friends,

Greetings !

Request for your help on the subject matter.

I have attached the file for your reference, in which there are two
different rows which are having repetition entries and I need to count them
without deleting the records/ any of the rows.

Thank you.

Regards,
Pravin Gunjal.

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




How to count the items except repetition.xls
Description: MS-Excel spreadsheet

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

[noorain . ansari]

Thanks to all of you dear

Aside to Ayush: Most helful award certificate is very lovely and nice,it will 
encourage to our group member to solve query more and more. Thanks brother for 
this creativity.


Sent from BlackBerry® on Airtel

-Original Message-
From: Sam Mathai Chacko 
Date: Tue, 4 Sep 2012 23:00:43 
To: 
Cc: NOORAIN ANSARI
Subject: Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member August 
2012

Congratulations Noorain. Keep up the excellent work.

Regards,
Sam

On Tue, Sep 4, 2012 at 3:40 PM, Prince Dubey  wrote:

> Congrats Noorain sir.
>
> On Sunday, September 2, 2012 10:33:02 AM UTC+5:30, Ayush Jain wrote:
>
>>  Dear members,
>>
>> Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
>> the month of Aug'12. He has posted 111 posts in August 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.
>> *Noorain, please find enclosed the award certificate in honour of your
>> contribution.*
>>
>> Thanks to all other folks for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>  --
> 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.
>
>
>



-- 
Sam Mathai Chacko

-- 
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$$ Simple formula required

[Ms-Exl-Learner .]

Or

=IF(ISERR(FIND(")",D3)),"",TRIM(MID(D3,FIND(")",D3)+1,255)))

<><><><><><>
*Ms.Exl.Learner*
<><><><><><>

---


On Tue, Sep 4, 2012 at 2:01 PM, amar takale  wrote:

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

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

$$Excel-Macros$$ Re: need tool for automation

[Prince Dubey]

Hi Maksood,
 
Can you pls let us know what kind of tool do you want.I mean what kind of 
 functionalities do you want in your tool.
 
 
Regards
Prince

On Tuesday, September 4, 2012 11:47:03 PM UTC+5:30, maksood alam wrote:

> Hi Gusy, 
>  
>  
> Please provide some website from where i can download automated tool for 
> excel.
>  
>  
> Thanks
>  
> Maksood alam
>

-- 
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$$ Excel Macro

[Paul Schreiner]

My suggestion remains the same.
Simply adding: ".xlsm" doesn't doesn't instruct Excel to change the file format.
just the "name".
In fact...
I don't know anything about a Mac, but does it use a file extension similar to 
Windows?
are both operating systems DISPLAYING file extensions?

For some reason, your Windows system is trying to save the file in .xlsx format.
telling it to use the name: "Incomplete" & " - " & Range("G4").Value & ".xlsm"
May actually be attempting to create a file called:
"Incomplete-907.xlsm.xlsx"

Try using:
ActiveWorkbook.SaveAs Filename:="Incomplete-" & Range("G4").Value & ".xlsm", 
FileFormat:=xlOpenXMLWorkbookMacroEnabled
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: combellack 
To: excel-macros@googlegroups.com
Sent: Tue, September 4, 2012 12:51:03 PM
Subject: Re: $$Excel-Macros$$ Excel Macro



On Tuesday, 4 September 2012 13:59:31 UTC+1, combellack wrote: 
Hi Paul,
>
>here's the first error mwssage, when i click 'No' in the message box.
>
>
>
>if i then click 'NO', i get this
>
>
>
>Debug show's this
>
>
>
>I'm added "xlsm" at the end because i thought it may had been an file 
>extenison 
>issue.
>
>The Value range("G4") is the cell in which we enter our Purchase Order Number.
>
>If i click 'Yes' on the first message box, the file is converted to PDF 
>perferct, its only when i click 'NO' so i can edit it later.
>
>The stangest thing, its works perfect on my Mac, saves to Dropbox, and open's 
>on 
>Windows fine.
>
>I only get this error when i click 'NO' in the first message box. 'Yes' & 
>'Cancel' work fine.
>
>On Tuesday, 4 September 2012 13:35:30 UTC+1, Paul Schreiner wrote: 
>Sorry about my previous message.
>>I didn't finish reading...
>>
>>What does the error message read?
>>
>>what is the value of Range("G4")
>>
>>and... wouldn't the line following
>>elseif PO = vbCancel then
>>Cancel = true
>>
>>??
>> 
>>Paul
>>-- ---
>>“Do all the good you can,
>>By all the means you can,
>>In all the ways you can,
>>In all the places you can,
>>At all the times you can,
>>To all the people you can,
>>As long as ever you can.” - John Wesley
>>-- ---
>>
>>
>>
>>
>>

From: combellack 
>>To: excel-...@googlegroups.com
>>Sent: Tue, September 4, 2012 8:17:40 AM
>>Subject: $$Excel-Macros$$ Excel Macro
>>
>>
>>
>>
>>I was hope you could help!
>> 
>>I wrote a VB Code for Excel (mainly copied for Google!) to help us when 
>>raising 
>>purchase orders.
>> 
>>I wrote it on my mac within Office 2010, and I ran perfect.
>> 
>>Unfortunately when I try on Windows (also Office 2010) I get a debug error?  
>> 
>> Private Sub Workbook_BeforeClose(Cancel As Boolean)
>>Dim PO As Long
>>PO = MsgBox("Is the Purchase Order complete?", vbYesNoCancel)
>>If PO = vbYes Then
>> 
>>Me.Saved = True
>> 
>>Dim fName As String, fPath As String
>> 
>>fName = Range("G4").Value
>>    fPath = "\\SBS1\dropbox\Purchase Order"
>>    
>>ActiveWorkbook. ExportAsFixedFormat _
>>    Type:=xlTypePDF, _
>>    Filename:=fPath & "/" & fName, _
>>    Quality:=xlQualityStandard, _
>>    IncludeDocProperties:=True, _
>>    IgnorePrintAreas:=False, _
>>    OpenAfterPublish:=True
>>    
>>ElseIf PO = vbNo Then
>>ActiveWorkbook.SaveAs Filename:="Incomplete" & " - " & Range("G4").Value & 
>>".xlsm"
>> 
>>ElseIf PO = vbCancel Then
>>Quit = True
>> 
>>End If
>> 
>>End Sub
>> 
>> 
>>Windows Office is showing the error as being
>>ElseIf PO = vbNo Then
>>ActiveWorkbook.SaveAs Filename:="Incomplete" & " - " & Range("G4").Value & 
>>".xlsm"
>> 
>>What have I done wrong?-- 
>>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 

$$Excel-Macros$$ need tool for automation

[maksood alam]

Hi Gusy,


Please provide some website from where i can download automated tool for
excel.


Thanks

Maksood alam

-- 
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$$ Re: How to import data from Oracle SQL to MS Excel ?

[Mangesh Vimay]

Hi Prince,

Thanks.
But please let me know if this is vba code or something else.


On 9/4/12, Prince Dubey  wrote:
>
> Hi Mangesh
>
> You can use an sddin to simplify your task for example you can use SQLodbc
> (
> *http://sqlodbc.t35.com* )
> =sql.execute("CONNECTION STRING";"YOUR SQL CODE");
>
> hope this will help you
> regards
>
> prince dubey.
>
> On Monday, September 3, 2012 6:03:56 PM UTC+5:30, Mangesh wrote:
>
>> Hi Friends,
>>
>> I would like to import the data/query result of Oracle SQL to Excel.
>> Can you please help me by providing suitable solution over my problem.
>> You can also suggest VBA code/guidelines to solve the issue.
>> Thanks lot !!!
>>
>> --
>> With regards,
>>
>> *MaNgEsH*
>>
>
> --
> 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.
>
>
>


-- 
With regards,

*MaNgEsH*

-- 
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$$ Re: Noorain Ansari - Most Helpful Member August 2012

[Sam Mathai Chacko]

Congratulations Noorain. Keep up the excellent work.

Regards,
Sam

On Tue, Sep 4, 2012 at 3:40 PM, Prince Dubey  wrote:

> Congrats Noorain sir.
>
> On Sunday, September 2, 2012 10:33:02 AM UTC+5:30, Ayush Jain wrote:
>
>>  Dear members,
>>
>> Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
>> the month of Aug'12. He has posted 111 posts in August 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.
>> *Noorain, please find enclosed the award certificate in honour of your
>> contribution.*
>>
>> Thanks to all other folks for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>  --
> 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.
>
>
>



-- 
Sam Mathai Chacko

-- 
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$$ Moving Excel worksheet information in VBA memory

[chhajersandeep]

Dear Ruchir,

If you share your work with us it would be an immense help for us also.

Thanks,
Sandeep Chhajer. 
Sent on my BlackBerry® from Vodafone

-Original Message-
From: Sam Mathai Chacko 
Sender: excel-macros@googlegroups.com
Date: Tue, 4 Sep 2012 22:32:36 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Moving Excel worksheet information in VBA memory

No it won't. Try using

var = Worksheets("Name").UsedRange.Formula

Regards,
Sam Mathai Chacko

On Tue, Sep 4, 2012 at 9:56 PM, rjoshi88  wrote:

> Hi sam,
>
> Thanks for the reply, but this would not give me information about other
> cell parameters like dependents.
>
> Ruchir
>
>
> On Tuesday, September 4, 2012 9:46:15 PM UTC+5:30, Sam Mathai Chacko wrote:
>
>> Try taking all the values of the used range to a variant variable.
>>
>> Example
>>
>> Sub T()
>>
>> Dim var As Variant
>>
>> var = Worksheets("Name").UsedRange.**Value
>>
>> End Sub
>>
>> Regards,
>> Sam Mathai Chacko
>>
>> On Tue, Sep 4, 2012 at 9:43 PM, Ruchir Joshi  wrote:
>>
>>> Hello everyone,
>>>
>>> I am designing a tool to identify whether a cell has inter or intra
>>> sheet dependents using VBA. The problem is the extremely slow speed due to
>>> interaction with worksheet and use of 'showarrows' and 'hidearrows'
>>> function. Can the entire sheet information be copied into VBA memory, so
>>> that execution time reduces. ? I am looking forward for any code /
>>> supporting link.
>>>
>>> Regards
>>> Ruchir Joshi
>>>
>>> --
>>> 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-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>  --
> 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.
>
>
>



-- 
Sam Mathai Chacko

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

Re: $$Excel-Macros$$ Moving Excel worksheet information in VBA memory

[Sam Mathai Chacko]

No it won't. Try using

var = Worksheets("Name").UsedRange.Formula

Regards,
Sam Mathai Chacko

On Tue, Sep 4, 2012 at 9:56 PM, rjoshi88  wrote:

> Hi sam,
>
> Thanks for the reply, but this would not give me information about other
> cell parameters like dependents.
>
> Ruchir
>
>
> On Tuesday, September 4, 2012 9:46:15 PM UTC+5:30, Sam Mathai Chacko wrote:
>
>> Try taking all the values of the used range to a variant variable.
>>
>> Example
>>
>> Sub T()
>>
>> Dim var As Variant
>>
>> var = Worksheets("Name").UsedRange.**Value
>>
>> End Sub
>>
>> Regards,
>> Sam Mathai Chacko
>>
>> On Tue, Sep 4, 2012 at 9:43 PM, Ruchir Joshi  wrote:
>>
>>> Hello everyone,
>>>
>>> I am designing a tool to identify whether a cell has inter or intra
>>> sheet dependents using VBA. The problem is the extremely slow speed due to
>>> interaction with worksheet and use of 'showarrows' and 'hidearrows'
>>> function. Can the entire sheet information be copied into VBA memory, so
>>> that execution time reduces. ? I am looking forward for any code /
>>> supporting link.
>>>
>>> Regards
>>> Ruchir Joshi
>>>
>>> --
>>> 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-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>  --
> 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.
>
>
>



-- 
Sam Mathai Chacko

-- 
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$$ Moving Excel worksheet information in VBA memory

[rjoshi88]

Hi sam, 

Thanks for the reply, but this would not give me information about other 
cell parameters like dependents. 

Ruchir

On Tuesday, September 4, 2012 9:46:15 PM UTC+5:30, Sam Mathai Chacko wrote:
>
> Try taking all the values of the used range to a variant variable.
>
> Example
>
> Sub T()
>
> Dim var As Variant
>
> var = Worksheets("Name").UsedRange.Value
>
> End Sub
>
> Regards,
> Sam Mathai Chacko
>
> On Tue, Sep 4, 2012 at 9:43 PM, Ruchir Joshi 
> > wrote:
>
>> Hello everyone, 
>>
>> I am designing a tool to identify whether a cell has inter or intra sheet 
>> dependents using VBA. The problem is the extremely slow speed due to 
>> interaction with worksheet and use of 'showarrows' and 'hidearrows' 
>> function. Can the entire sheet information be copied into VBA memory, so 
>> that execution time reduces. ? I am looking forward for any code / 
>> supporting link. 
>>
>> Regards
>> Ruchir Joshi
>>
>> -- 
>> 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-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>>  
>>  
>>
>
>
>
> -- 
> Sam Mathai Chacko
>

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

$$Excel-Macros$$ Re: Moving Excel worksheet information in VBA memory

[rjoshi88]

Hi sam, 

Thanks for the reply, but this would not give me information about other 
cell parameters like dependents. 

Ruchir

On Tuesday, September 4, 2012 9:43:13 PM UTC+5:30, rjoshi88 wrote:
>
> Hello everyone, 
>
> I am designing a tool to identify whether a cell has inter or intra sheet 
> dependents using VBA. The problem is the extremely slow speed due to 
> interaction with worksheet and use of 'showarrows' and 'hidearrows' 
> function. Can the entire sheet information be copied into VBA memory, so 
> that execution time reduces. ? I am looking forward for any code / 
> supporting link. 
>
> Regards
> Ruchir Joshi
>

-- 
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$$ Moving Excel worksheet information in VBA memory

[Sam Mathai Chacko]

Try taking all the values of the used range to a variant variable.

Example

Sub T()

Dim var As Variant

var = Worksheets("Name").UsedRange.Value

End Sub

Regards,
Sam Mathai Chacko

On Tue, Sep 4, 2012 at 9:43 PM, Ruchir Joshi  wrote:

> Hello everyone,
>
> I am designing a tool to identify whether a cell has inter or intra sheet
> dependents using VBA. The problem is the extremely slow speed due to
> interaction with worksheet and use of 'showarrows' and 'hidearrows'
> function. Can the entire sheet information be copied into VBA memory, so
> that execution time reduces. ? I am looking forward for any code /
> supporting link.
>
> Regards
> Ruchir Joshi
>
> --
> 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.
>
>
>



-- 
Sam Mathai Chacko

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

$$Excel-Macros$$ Moving Excel worksheet information in VBA memory

[Ruchir Joshi]

Hello everyone, 

I am designing a tool to identify whether a cell has inter or intra sheet 
dependents using VBA. The problem is the extremely slow speed due to 
interaction with worksheet and use of 'showarrows' and 'hidearrows' 
function. Can the entire sheet information be copied into VBA memory, so 
that execution time reduces. ? I am looking forward for any code / 
supporting link. 

Regards
Ruchir Joshi

-- 
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$$ Returning a cumulative value based on the contents of a given cell

[Steve Weaver]

Perfecto!!!  I believe I got it now.

Thanks everyone for your help.

Steve


*From:* Steve Weaver 
*Sent:* Wednesday, August 29, 2012 11:24 AM
*To:* excel-macros@googlegroups.com 

*Subject:* $$Excel-Macros$$ Returning a cumulative value based on the 
contents of a given cell
I need help to create a formula that will return a cumulative value 
based on the contents of a given cell. A sample worksheet is attached 
with more detailed instructions.


Thank you in advance for your help!

Steve


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



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





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

$$Excel-Macros$$ CFP: Computing, Networking and Digital Technologies

[SDIWC Conferences]

We invite participation and submissions to The International Conference on 
Computing, Networking and Digital Technologies (ICCNDT 2012) that will be 
held at Gulf University, Sanad, Bahrain from Nov. 11-13, 2012. More details 
can be found at the conference's official web site, visit 
http://sdiwc.net/bh

*RESEARCH TOPICS (but not limited to):
- Software Specification
- Software Assurance
- Social Search
- Software Process Modeling
- Software Reuse
- Cloud Computing
- Grid Computing
- Green Computing
- Information and Data Management

*IMPORTANT DATES
Paper Submission Deadline: Sept. 25, 2012
Notification of Acceptance: Oct. 10, 2012
Camera Ready Submission: Oct. 30, 2012
Registration: Oct. 30, 2012

**Please consider forwarding this message to persons who might be 
interested. Thank you.**

-- 
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$$ Simple formula required

[Rajan_Verma]

 

=TRIM(RIGHT(SUBSTITUTE(D3," ",REPT(" ",LEN(D3)),1),LEN(D3)))

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 04 September 2012 2:01
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Simple formula required

 

 

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

-- 
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$$ Count when po is greater than zero

[Rajan_Verma]

 

 

=SUMPRODUCT(N($B$2:$B$10=B2),N($D$2:$D$10<>""))

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Muralidhar E
Sent: 04 September 2012 11:28
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count when po is greater than zero

 


Dear all,

 

Find the attached file, I want i column E if column D is more than zero to
be calculated with how many times column B is repeated.

Ex. In column B Murali is repeated 3 times but in column D is more than zero
is only 2 times, the result is 2.

 

Thanks in advance.

On Mon, Sep 3, 2012 at 6:02 PM, dguillett1  wrote:

Provide a file and a complete explanation and examples.

 

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

 

From: Muralidhar E   

Sent: Monday, September 03, 2012 3:33 AM

To: excel-macros@googlegroups.com 

Subject: Re: $$Excel-Macros$$ Count when po is greater than zero

 

Hi,

 

Thanks for quickly reply, but it is not working, in result columncount of
name is not coming, name is appears,

 

Plz, ignore the column E it is remarks for the status of PO under process.

Actually i want the vendor name how many times it is repeat when it has PO,
if PO is not confirmed it will not to be calculated(not to be counted).

 

Thanks in advance.


 

On Mon, Sep 3, 2012 at 12:55 PM, Kuldeep Singh 
wrote:

 

Hi Murli,

 

Try this one.

 

=IFERROR(INDEX($B$2:$B$10,SMALL(IF($D$2:$D$10>=E2,ROW($E$2:$E$10),""),COUNTI
F($B$2:B10,B2))-1),"0") 

 

Ctrl + Shift + Enter

 

Regards,

Kuldeep Singh 

 

On Mon, Sep 3, 2012 at 12:29 PM, Muralidhar E 
wrote:

Hi,

 

thanks, But the result is coming wrong, for blank "p o" vendor name is
taking in calculation.

On Mon, Sep 3, 2012 at 11:52 AM, Kuldeep Singh 
wrote:

 

Hi Muralidhar, 

 

Try this.

 

=IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0"))

 

Regards,

Kuldeep Singh 

 

 

On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E 
wrote:

 

Dear all,
 
Good morning to every body

 

Iam using Office 2010, I need in result column(F) how many times the vendor
name(column B) is repeat, it is countable when the po(column D) is greater
than zero, if po is blank or zero it will not be counted(calculated). Plz,
find the attached file.


Thanks in advance.
-- 

Thanks & Regards,

 

Muralidhar E.

Think different

Do Different

Make different

 

-- 
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
mailto:excel-macros%2bunsubscr...@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
mailto:excel-macros%2bunsubscr...@googlegroups.com.
 
 




-- 

Thanks & Regards,

 

Muralidhar E.

Think different

Do Different

Make different

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ membe

Re: $$Excel-Macros$$ Rank Formula

[dguillett1]

Put in H5 and copy down
=SUMPRODUCT(--($F$5:$F$14<>"fail"),--(D5<$D$5:$D$14))+1

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: kumar Kishore 
Sent: Tuesday, September 04, 2012 7:15 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Rank Formula

hai..friends/Masters,

i had applied formula in column G2 and i need same numer in H3

but while copying it shows only ref.

Please tell how to do.


Regards,

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

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




Rank Formula.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel Macro

[Paul Schreiner]

Sorry about my previous message.
I didn't finish reading...

What does the error message read?

what is the value of Range("G4")

and... wouldn't the line following
elseif PO = vbCancel then
Cancel = true

??
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: combellack 
To: excel-macros@googlegroups.com
Sent: Tue, September 4, 2012 8:17:40 AM
Subject: $$Excel-Macros$$ Excel Macro




I was hope you could help!
 
I wrote a VB Code for Excel (mainly copied for Google!) to help us when raising 
purchase orders.
 
I wrote it on my mac within Office 2010, and I ran perfect.
 
Unfortunately when I try on Windows (also Office 2010) I get a debug error?  
 
 Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim PO As Long
PO = MsgBox("Is the Purchase Order complete?", vbYesNoCancel)
If PO = vbYes Then
 
Me.Saved = True
 
Dim fName As String, fPath As String
 
fName = Range("G4").Value
    fPath = "\\SBS1\dropbox\Purchase Order"
    
ActiveWorkbook.ExportAsFixedFormat _
    Type:=xlTypePDF, _
    Filename:=fPath & "/" & fName, _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, _
    OpenAfterPublish:=True
    
ElseIf PO = vbNo Then
ActiveWorkbook.SaveAs Filename:="Incomplete" & " - " & Range("G4").Value & 
".xlsm"
 
ElseIf PO = vbCancel Then
Quit = True
 
End If
 
End Sub
 
 
Windows Office is showing the error as being
ElseIf PO = vbNo Then
ActiveWorkbook.SaveAs Filename:="Incomplete" & " - " & Range("G4").Value & 
".xlsm"
 
What have I done wrong?-- 
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.

-- 
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$$ Excel Macro

[Paul Schreiner]

Where is the debugger hilighting the error?

I suspect that it's the quit=true line.
I'm not sue what that does.
I would have thought the syntax would be Application.Quit.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: combellack 
To: excel-macros@googlegroups.com
Sent: Tue, September 4, 2012 8:17:40 AM
Subject: $$Excel-Macros$$ Excel Macro




I was hope you could help!
 
I wrote a VB Code for Excel (mainly copied for Google!) to help us when raising 
purchase orders.
 
I wrote it on my mac within Office 2010, and I ran perfect.
 
Unfortunately when I try on Windows (also Office 2010) I get a debug error?  
 
 Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim PO As Long
PO = MsgBox("Is the Purchase Order complete?", vbYesNoCancel)
If PO = vbYes Then
 
Me.Saved = True
 
Dim fName As String, fPath As String
 
fName = Range("G4").Value
    fPath = "\\SBS1\dropbox\Purchase Order"
    
ActiveWorkbook.ExportAsFixedFormat _
    Type:=xlTypePDF, _
    Filename:=fPath & "/" & fName, _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, _
    OpenAfterPublish:=True
    
ElseIf PO = vbNo Then
ActiveWorkbook.SaveAs Filename:="Incomplete" & " - " & Range("G4").Value & 
".xlsm"
 
ElseIf PO = vbCancel Then
Quit = True
 
End If
 
End Sub
 
 
Windows Office is showing the error as being
ElseIf PO = vbNo Then
ActiveWorkbook.SaveAs Filename:="Incomplete" & " - " & Range("G4").Value & 
".xlsm"
 
What have I done wrong?-- 
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.

-- 
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$$ Rank Formula

[dguillett1]

One way using this array formula (entered using ctrl+shift+enter CSE)
INDEX($C:$C,MATCH(LARGE(IF($F$5:$F$15<>"fail",$D$5:$D$15),ROW(A1)),$D:$D,0))

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: amar takale 
Sent: Tuesday, September 04, 2012 6:41 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Rank Formula


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

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

$$Excel-Macros$$ Excel Macro

[combellack]

I was hope you could help!

 

I wrote a VB Code for Excel (mainly copied for Google!) to help us when 
raising purchase orders.

 

I wrote it on my mac within Office 2010, and I ran perfect.

 

Unfortunately when I try on Windows (also Office 2010) I get a debug error? 
 

 

 Private Sub Workbook_BeforeClose(Cancel As Boolean)

Dim PO As Long

PO = MsgBox("Is the Purchase Order complete?", vbYesNoCancel)

If PO = vbYes Then

 

Me.Saved = True

 

Dim fName As String, fPath As String

 

fName = Range("G4").Value

fPath = "\\SBS1\dropbox\Purchase Order"



ActiveWorkbook.ExportAsFixedFormat _

Type:=xlTypePDF, _

Filename:=fPath & "/" & fName, _

Quality:=xlQualityStandard, _

IncludeDocProperties:=True, _

IgnorePrintAreas:=False, _

OpenAfterPublish:=True



ElseIf PO = vbNo Then

ActiveWorkbook.SaveAs Filename:="Incomplete" & " - " & Range("G4").Value & 
".xlsm"

 

ElseIf PO = vbCancel Then

Quit = True

 

End If

 

End Sub

 

 

Windows Office is showing the error as being

ElseIf PO = vbNo Then

ActiveWorkbook.SaveAs Filename:="Incomplete" & " - " & Range("G4").Value & 
".xlsm"

 

What have I done wrong?

-- 
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$$ Rank Formula

[kumar Kishore]

hai..friends/Masters,

i had applied formula in column G2 and i need same numer in H3

but while copying it shows only ref.

Please tell how to do.


Regards,

Kishore

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

$$Excel-Macros$$ Rank Formula

[amar takale]

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




Rank Formula.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Change Column Size

[Paul Schreiner]

Really?
Say you've got a cell 12 characters wide,
but the contents have 100 characers.

How does "Zooming" make the contents visible?
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Rajan_Verma 
To: excel-macros@googlegroups.com
Sent: Sat, September 1, 2012 1:04:41 AM
Subject: RE: $$Excel-Macros$$ Change Column Size


Try to zoom your worksheet
 
 
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of mburkett
Sent: 31 August 2012 11:41
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change Column Size
 
I am using a list with data validation in cells c64:c74. The choices are very 
long text strings. Does anyone have code that will expand the column width when 
I select any of the cells and return to original (or specific) size once 
deselected? 

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

-- 
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$$ Help needed in sum

[Rambabu Mudiraj]

Thank you its working

On Mon, Sep 3, 2012 at 5:22 PM, Amresh Maurya wrote:

> Hi  Rambabu,
>
> Find the attached file.
>
> use this formula.
>
> =SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15)
>
> Regards
> Amresh
>
>
>
>
>  On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI 
> wrote:
>
>> Please try
>>
>> =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
>>
>>
>> On Mon, Sep 3, 2012 at 5:17 PM, Rambabu Mudiraj wrote:
>>
>>> Dear all,
>>>
>>>
>>> --
>>> Regards
>>> Rambabu. G
>>>
>>> --
>>> 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.
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.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.
>>
>>
>>
>
>  --
> 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.
>
>
>



-- 
Regards
Rambabu. G

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

Re: $$Excel-Macros$$ Returning a cumulative value based on the contents of a given cell

[Steve Weaver]

Perfecto!!!  I believe I got it now.

Thanks everyone for your help.

Steve


*From:* Steve Weaver 
*Sent:* Wednesday, August 29, 2012 11:24 AM
*To:* excel-macros@googlegroups.com 

*Subject:* $$Excel-Macros$$ Returning a cumulative value based on the 
contents of a given cell
I need help to create a formula that will return a cumulative value 
based on the contents of a given cell. A sample worksheet is attached 
with more detailed instructions.


Thank you in advance for your help!

Steve


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



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






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

[Kal xcel]

Brother,

I think, beside your achievement I also achieved something……….that is..

I got a really nice person called “NOORAIN ANSARI”.

Till date whenever I faced any problem in excel I got immediate answer from
you.

So I can describe it like this…..

ANSWER = ANSARI

And your ACHIEVEMENT!!

it’s became your habit.

Keep it up brother

Kalyan
On Mon, Sep 3, 2012 at 8:27 PM, xlstime  wrote:

> Congratulations Noorain 
>
>
> On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain  wrote:
>
>> Dear members,
>>
>> Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
>> the month of Aug'12. He has posted 111 posts in August 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.
>> *Noorain, please find enclosed the award certificate in honour of your
>> contribution.*
>>
>> Thanks to all other folks for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> 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.
>>
>>
>>
>
>
>
> --
> .
>
>  --
> 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.
>
>
>



-- 
*Kalyan Chattopadhyay*

*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*

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

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

[Prince Dubey]

Congrats Noorain sir.

On Sunday, September 2, 2012 10:33:02 AM UTC+5:30, Ayush Jain wrote:

>  Dear members,
>  
> Once again, Noorain Ansari has been selected as 'Most Helpful Member' for 
> the month of Aug'12. He has posted 111 posts in August 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.
> *Noorain, please find enclosed the award certificate in honour of your 
> contribution.*
>
> Thanks to all other folks for helping excel enthusiasts voluntarily !! 
> Keep posting.
>  
> Regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>

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

$$Excel-Macros$$ Re: Amazing Mind

[Prince Dubey]

I have got it logic(:
 
 
Regards
Prince 
 

On Tuesday, September 4, 2012 10:20:46 AM UTC+5:30, Bhaity wrote:

> Dearest All,
>
>   Lets have a break for a while :- 
>
> Minder Reader is attached with. Actually the reader seems to be very 
> creative, but it is built in logical way. Please have fun with the mind 
> reader.
>
> Notee:- Think in depth and you will find the answer earlier.  
>
> Just for forum fun break. 
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
>

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

$$Excel-Macros$$ Re: How to import data from Oracle SQL to MS Excel ?

[Prince Dubey]

 
Hi Mangesh 
 
You can use an sddin to simplify your task for example you can use SQLodbc (
*http://sqlodbc.t35.com* )
=sql.execute("CONNECTION STRING";"YOUR SQL CODE");
 
hope this will help you
regards
 
prince dubey.

On Monday, September 3, 2012 6:03:56 PM UTC+5:30, Mangesh wrote:

> Hi Friends, 
>
> I would like to import the data/query result of Oracle SQL to Excel. 
> Can you please help me by providing suitable solution over my problem. 
> You can also suggest VBA code/guidelines to solve the issue. 
> Thanks lot !!! 
>
> -- 
> With regards, 
>
> *MaNgEsH* 
>

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

$$Excel-Macros$$ Re: Help needed in sum

[Prince Dubey]

 
try this and drag the same at the end of ur range with criteria
 
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<"&O15)
 
 
regards
prince
 
 
 

On Monday, September 3, 2012 5:17:27 PM UTC+5:30, rambo wrote:

> Dear all,
>
>
> -- 
> Regards
> Rambabu. G
>

-- 
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$$ Simple formula required

[amar takale]

Hi Amresh,
Formula is ok.But other word file is fantastic.Amazing amresh
Thanks very much

On Tue, Sep 4, 2012 at 2:28 PM, Amresh Maurya wrote:

> find the attached solution  - 1
>
> solution  - 2 you can use this formula
>
> =TRIM(SUBSTITUTE(D4,LEFTB(D4,FIND(")",D4,1)),""))
>
> find the attached solved excel sheet also.
>
> Regards
> Amresh
>
> Regards
> Amresh Maurya
>
>
> On Tue, Sep 4, 2012 at 2:01 PM, amar takale  wrote:
>
>>
>>  --
>> 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.
>>
>>
>>
>
>  --
> 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.
>
>
>

-- 
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$$ Re: Simple formula required

[amar takale]

Thanks very much prince

On Tue, Sep 4, 2012 at 2:32 PM, Prince Dubey  wrote:

> Hi Amar,
>
>
> Please paste this formula H3 and Drag it to H6 this will give ur desire
> result.
>
> =RIGHT(D3,LEN(D3)-(FIND(")",D3,1)+1))
>
> Regards
> Prince
>
>
> On Tuesday, September 4, 2012 2:01:19 PM UTC+5:30, amar takale wrote:
>
>>
>>  --
> 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.
>
>
>

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

$$Excel-Macros$$ Re: Simple formula required

[Prince Dubey]

Hi Amar,
 
 
Please paste this formula H3 and Drag it to H6 this will give ur desire 
result.
 
=RIGHT(D3,LEN(D3)-(FIND(")",D3,1)+1))
 
Regards
Prince
 

On Tuesday, September 4, 2012 2:01:19 PM UTC+5:30, amar takale wrote:

>
>

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

$$Excel-Macros$$ Simple formula required

[amar takale]

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




Formula Required.xls
Description: MS-Excel spreadsheet