Re: $$Excel-Macros$$ Please help me

[Jayanta Barman]

Thanksa ton Sourav. You kind help is highly appreciated.

On Wed, Aug 3, 2016 at 7:46 PM, sourav devrani 
wrote:

> please use this file.
> i have change some little formula here you can use this file.
>
> Regards
> Sourav Devrani
>
> On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani <
> souravdevrani1...@gmail.com> wrote:
>
>> please see the attached file.
>>
>> On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman > > wrote:
>>
>>> Is there any one who can solve this, please ?
>>>
>>> On Aug 2, 2016 23:38, "Jayanta Barman" 
>>> wrote:
>>>
 Hello Excel experts,

 I have a small problem in excel. Please help me in resolving this.

 Problem: I have a set of products launched at different years with
 their revenue figures. I want to create another table wherein all the
 product sales will be displayed from their first year. I have attached the
 file. Please help me with excel formula or any vba macro would suffice.

 Thanks
 Jayanta

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

 FORUM RULES

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

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

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



-- 
Jayanta Kumar Barman
Unto

Re: $$Excel-Macros$$ Please help me

[sourav devrani]

please use this file.
i have change some little formula here you can use this file.

Regards
Sourav Devrani

On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani 
wrote:

> please see the attached file.
>
> On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman 
> wrote:
>
>> Is there any one who can solve this, please ?
>>
>> On Aug 2, 2016 23:38, "Jayanta Barman"  wrote:
>>
>>> Hello Excel experts,
>>>
>>> I have a small problem in excel. Please help me in resolving this.
>>>
>>> Problem: I have a set of products launched at different years with their
>>> revenue figures. I want to create another table wherein all the product
>>> sales will be displayed from their first year. I have attached the file.
>>> Please help me with excel formula or any vba macro would suffice.
>>>
>>> Thanks
>>> Jayanta
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

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

FORUM RULES

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

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


Blank Fill.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Please help me

[sourav devrani]

please see the attached file.

On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman 
wrote:

> Is there any one who can solve this, please ?
>
> On Aug 2, 2016 23:38, "Jayanta Barman"  wrote:
>
>> Hello Excel experts,
>>
>> I have a small problem in excel. Please help me in resolving this.
>>
>> Problem: I have a set of products launched at different years with their
>> revenue figures. I want to create another table wherein all the product
>> sales will be displayed from their first year. I have attached the file.
>> Please help me with excel formula or any vba macro would suffice.
>>
>> Thanks
>> Jayanta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


Blank Fill.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Please help me

[Jayanta Barman]

Is there any one who can solve this, please ?

On Aug 2, 2016 23:38, "Jayanta Barman"  wrote:

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

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

FORUM RULES

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

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

$$Excel-Macros$$ Please help me

[Jayanta Barman]

Hello Excel experts,

I have a small problem in excel. Please help me in resolving this.

Problem: I have a set of products launched at different years with their
revenue figures. I want to create another table wherein all the product
sales will be displayed from their first year. I have attached the file.
Please help me with excel formula or any vba macro would suffice.

Thanks
Jayanta

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

FORUM RULES

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

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


Blank Fill.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Please help me Urgent

[Gaurav Devrani]

Dat's Cool Vaibhav. Thanks.

On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth 
wrote:

>
> Very Nice... Mr.Vabz
>
> On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote:
>
>> Suppose you have value in cell A1 then type follo. formula in A2 & dont
>> press enter & press F9, you will get result in curly bracket, after = sign
>> enter CONCATENATE( & press enter to get result
>>
>> =TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)
>> ,UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),LOWER(MID(A1,
>> ROW(INDIRECT("1:"&LEN(A1))),1)),UPPER(MID(A1,ROW(INDIRECT("
>> 1:"&LEN(A1))),1)
>>
>> Cheers!!
>>
>> On Thu, Feb 26, 2015 at 8:42 PM, Gaurav Devrani 
>> wrote:
>>
>>> Hi Guys,
>>>
>>>
>>> I have a query . In this sentence.. "This iS a tEst" .
>>>
>>> All Upper case alphabets should be lower case and All Lowercase
>>> alphabets should be in Upper case. Please help me . I want that to be done
>>> in excel formulas.(If thats possible).
>>>
>>>
>>>
>>> Thanks & Regards
>>> Gaurav Devrani
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 

*Thanks & Regards*
*Gaurav Devrani*

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Please help me Urgent

[Michael Vinoth]

Very Nice... Mr.Vabz

On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote:

> Suppose you have value in cell A1 then type follo. formula in A2 & dont 
> press enter & press F9, you will get result in curly bracket, after = sign 
> enter CONCATENATE( & press enter to get result
>
>
> =TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),LOWER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)
>
> Cheers!!
>
> On Thu, Feb 26, 2015 at 8:42 PM, Gaurav Devrani  > wrote:
>
>> Hi Guys,
>>
>>
>> I have a query . In this sentence.. "This iS a tEst" .
>>
>> All Upper case alphabets should be lower case and All Lowercase alphabets 
>> should be in Upper case. Please help me . I want that to be done in excel 
>> formulas.(If thats possible).
>>
>>
>>  
>> Thanks & Regards
>> Gaurav Devrani
>>
>>  -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Please help me Urgent

[Vaibhav Joshi]

Suppose you have value in cell A1 then type follo. formula in A2 & dont
press enter & press F9, you will get result in curly bracket, after = sign
enter CONCATENATE( & press enter to get result

=TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),LOWER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)

Cheers!!

On Thu, Feb 26, 2015 at 8:42 PM, Gaurav Devrani 
wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Please help me Urgent

[Gaurav Devrani]

Hi Paul,

Thanks for the amazing macro you sent. it worked like a charm.. Thanks
again.


Regards
Gaurav Devrani

On Fri, Feb 27, 2015 at 1:04 AM, Paul Schreiner 
wrote:

> Are you wanting a macro made to work like a function?
> Like:
>
> =CaseSwap(A1)
>
> where CaseSwap is:
>
> Option Explicit
> Public Function CaseSwap(target As String)
> Dim Pos As Integer
> Dim StrNew
> StrNew = ""
> For Pos = 1 To Len(target)
> If (Mid(target, Pos, 1) = UCase(Mid(target, Pos, 1))) Then
> StrNew = StrNew & LCase(Mid(target, Pos, 1))
> Else
> StrNew = StrNew & UCase(Mid(target, Pos, 1))
> End If
> Next Pos
> CaseSwap = StrNew
> End Function
>
>
>
> *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:* Gaurav Devrani 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, February 26, 2015 11:55 AM
> *Subject:* Re: $$Excel-Macros$$ Please help me Urgent
>
> Thanks Paul for your quick reply. Yes I was also trying to create a macro
> but Just wanted to confirm before,  if that's possible in excel functions.
> No worries. I really appreciate your quick response once again. Thank you.
>
> Regards
> Gaurav Devrani
>
> On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner 
> wrote:
>
> I don't believe you'll be able to do that with standard Excel functions.
> you can create a CUSTOM function using VBA and use it like an Excel
> function.
> In your case, you need to process each character and "switch" the case.
> the problem is, within a standard Excel function, there's no way to
> "process each character".
>
>
>
> *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:* Gaurav Devrani 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, February 26, 2015 10:12 AM
> *Subject:* $$Excel-Macros$$ Please help me Urgent
>
> Hi Guys,
>
>
> I have a query . In this sentence.. "This iS a tEst" .
>
> All Upper case alphabets should be lower case and All Lowercase alphabets
> should be in Upper case. Please help me . I want that to be done in excel
> formulas.(If thats possible).
>
>
>
> Thanks & Regards
> Gaurav Devrani
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>   --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 

Re: $$Excel-Macros$$ Please help me Urgent

[Paul Schreiner]

Are you wanting a macro made to work like a function?
Like: 
 
=CaseSwap(A1)
 
where CaseSwap is:
 
Option Explicit
Public Function CaseSwap(target As String)
Dim Pos As Integer
Dim StrNew
StrNew = ""
For Pos = 1 To Len(target)
If (Mid(target, Pos, 1) = UCase(Mid(target, Pos, 1))) Then
StrNew = StrNew & LCase(Mid(target, Pos, 1))
Else
StrNew = StrNew & UCase(Mid(target, Pos, 1))
End If
Next Pos
CaseSwap = StrNew
End Function
 
 

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: Gaurav Devrani 
>To: excel-macros@googlegroups.com 
>Sent: Thursday, February 26, 2015 11:55 AM
>Subject: Re: $$Excel-Macros$$ Please help me Urgent
>  
>
>
>Thanks Paul for your quick reply. Yes I was also trying to create a macro but 
>Just wanted to confirm before,  if that's possible in excel functions. No 
>worries. I really appreciate your quick response once again. Thank you.
>
>
>Regards
>Gaurav Devrani
>
>
>On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner  
>wrote:
>
>I don't believe you'll be able to do that with standard Excel functions. 
>>you can create a CUSTOM function using VBA and use it like an Excel function.
>>In your case, you need to process each character and "switch" the case.
>>the problem is, within a standard Excel function, there's no way to "process 
>>each character".
>>
>>
>>
>>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: Gaurav Devrani 
>>>To: excel-macros@googlegroups.com 
>>>Sent: Thursday, February 26, 2015 10:12 AM
>>>Subject: $$Excel-Macros$$ Please help me Urgent
>>> 
>>>
>>>
>>>Hi Guys,
>>>
>>>
>>>
>>>
>>>I have a query . In this sentence.. "This iS a tEst" .
>>>
>>>
>>>All Upper case alphabets should be lower case and All Lowercase alphabets 
>>>should be in Upper case. Please help me . I want that to be done in excel 
>>>formulas.(If thats possible).
>>>
>>>
>>>
>>>
>>> 
>>>
>>>Thanks & Regards
>>>Gaurav Devrani
>>>
>>> 
-- 
>>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>>>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>>https://www.facebook.com/discussexcel
>>> 
>>>FORUM RULES
>>> 
>>>1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
>>>not get quick attention or may not be answered.
>>>2) Don't post a question in the thread of another member.
>>>3) Don't post questions regarding breaking or bypassing any security measure.
>>>4) Acknowledge the responses you receive, good or bad.
>>>5) Jobs posting is not allowed.
>>>6) Sharing copyrighted material and their links is not allowed.
>>> 
>>>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>>>members are not responsible for any loss.
>>>--- 
>>>You received this message because you are subscribed to the Google Groups 
>>>"MS EXCEL AND VBA MACROS" group.
>>>To unsubscribe from this group and stop receiving emails from it, send an 
>>>email to excel-macros+unsubscr...@googlegroups.com.
>>>To post to this group, send email to excel-macros@googlegroups.com.
>>>Visit this group at http://groups.google.com/group/excel-macros.
>>>For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>>
>>-- 
>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>https://www.facebook.com/discussexcel
>> 
>>FORUM RULES
>> 
>>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
>>get

Re: $$Excel-Macros$$ Please help me Urgent

[Gaurav Devrani]

Thanks Paul for your quick reply. Yes I was also trying to create a macro
but Just wanted to confirm before,  if that's possible in excel functions.
No worries. I really appreciate your quick response once again. Thank you.

Regards
Gaurav Devrani

On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner 
wrote:

> I don't believe you'll be able to do that with standard Excel functions.
> you can create a CUSTOM function using VBA and use it like an Excel
> function.
> In your case, you need to process each character and "switch" the case.
> the problem is, within a standard Excel function, there's no way to
> "process each character".
>
>
>
> *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:* Gaurav Devrani 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, February 26, 2015 10:12 AM
> *Subject:* $$Excel-Macros$$ Please help me Urgent
>
> Hi Guys,
>
>
> I have a query . In this sentence.. "This iS a tEst" .
>
> All Upper case alphabets should be lower case and All Lowercase alphabets
> should be in Upper case. Please help me . I want that to be done in excel
> formulas.(If thats possible).
>
>
>
> Thanks & Regards
> Gaurav Devrani
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>--
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Thanks & Regards
Gaurav Devrani

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the resp

Re: $$Excel-Macros$$ Please help me Urgent

[Paul Schreiner]

I don't believe you'll be able to do that with standard Excel functions. 
you can create a CUSTOM function using VBA and use it like an Excel function.
In your case, you need to process each character and "switch" the case.
the problem is, within a standard Excel function, there's no way to "process 
each character".
 
 

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: Gaurav Devrani 
>To: excel-macros@googlegroups.com 
>Sent: Thursday, February 26, 2015 10:12 AM
>Subject: $$Excel-Macros$$ Please help me Urgent
>  
>
>
>Hi Guys,
>
>
>
>
>I have a query . In this sentence.. "This iS a tEst" .
>
>
>All Upper case alphabets should be lower case and All Lowercase alphabets 
>should be in Upper case. Please help me . I want that to be done in excel 
>formulas.(If thats possible).
>
>
>
>
> 
>
>Thanks & Regards
>Gaurav Devrani
>
> 
-- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>https://www.facebook.com/discussexcel
> 
>FORUM RULES
> 
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Please help me Urgent

[Gaurav Devrani]

Hi Guys,


I have a query . In this sentence.. "This iS a tEst" .

All Upper case alphabets should be lower case and All Lowercase alphabets
should be in Upper case. Please help me . I want that to be done in excel
formulas.(If thats possible).



Thanks & Regards
Gaurav Devrani

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[Vaibhav Joshi]

Hi

I am not sure of this.

Thx


On Wed, Apr 30, 2014 at 3:34 PM, renuka chari  wrote:

> Dear Sir thanks alot...
>
> i have a one doubt i.e my client places they are using Lotus note we are
> used to send this dashboard to my client place is this macro would be work
> on that place.
>
> please suggest.
>
>
> On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote:
>
>> Hi
>>
>> You can do so by creating UDF.
>>
>> See UDF sheet.
>>
>> Thanks
>>
>>
>> On Wed, Apr 30, 2014 at 12:08 AM, renuka chari  wrote:
>>
>>> Dear Sir,
>>>
>>> countif function creating more violation for huge data range. is there
>>> any possible to overcome or use any other function.
>>>
>>> please guide me...
>>>
>>> thanks...
>>>
>>>
>>>
>>> On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote:

 Dear sir,

 thank you so much.your given a great help..


 On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:
>
> Hi
>
> PFA alternate method using formula & help sheet.
>
> Thanks
>
>
> On Tue, Apr 29, 2014 at 8:57 PM, renuka chari wrote:
>
>> Dear sir,
>>
>> Thank you so much for your time and effort into problem.
>>
>> my dashboard having huge no of sheets and if i make pivot sheet then
>> my workbook size is increasing more i was applied your formula earlier
>> itself. but i need even better solution. and my dash board data range is
>> not constant if this data set count increase or decrease on daily basis.
>> that scenario  every time we are going to apply refresh or expand data
>> option for PIVOT it is time consuming process
>>
>>
>> so kindly think even better output for this problem..
>>
>>
>> On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote:
>>
>>> Its not possible to do without any help column.
>>>
>>> Another way out is shown in attached file. Ref col E & F.
>>>
>>> Thx
>>>
>>>
>>> On Tue, Apr 29, 2014 at 2:34 PM, renuka chari wrote:
>>>
 Dear sir,

 i dont want to use pivot. i need only formula for offset or index
 is it possible...

 On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:

> Hi
>
> You can do using Pivot Table, see attached file.
>
>
>1. In the Pivot Table, click the drop down arrow in the
>RowLabels field heading.
>2. In the pop-up menu, click Value Filters, then click Top 10
>& change it to 5.
>
> You can sort on Descending on Output by going thru More Sort
> option under filter
>
> Cheers!
>
>
> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee <
> jva@gmail.com> wrote:
>
>> Dear experts,
>>
>> please help me
>>
>>
>> Thanks & Regards´¨)
>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>
>> P Let us do our best to save nature, save water, plant trees,
>> protect
>> greenery, keep our surroundings clean, reduce usage of plastics,
>> and
>> use renewable energy sources.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
>> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
>> forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
>> Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any
>> security measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros...@googlegroups.com.
>> To post to this group, send email to excel-...@googlegroups.com.
>>
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you 

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear Sir thanks alot...

i have a one doubt i.e my client places they are using Lotus note we are 
used to send this dashboard to my client place is this macro would be work 
on that place. 

please suggest.


On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote:
>
> Hi
>
> You can do so by creating UDF.
>
> See UDF sheet.
>
> Thanks
>
>
> On Wed, Apr 30, 2014 at 12:08 AM, renuka chari 
> > wrote:
>
>> Dear Sir,
>>
>> countif function creating more violation for huge data range. is there 
>> any possible to overcome or use any other function. 
>>
>> please guide me...
>>
>> thanks...
>>
>>
>>
>> On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote:
>>>
>>> Dear sir,
>>>
>>> thank you so much.your given a great help..
>>>
>>>
>>> On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:

 Hi

 PFA alternate method using formula & help sheet.

 Thanks


 On Tue, Apr 29, 2014 at 8:57 PM, renuka chari wrote:

> Dear sir,
>
> Thank you so much for your time and effort into problem.
>
> my dashboard having huge no of sheets and if i make pivot sheet then 
> my workbook size is increasing more i was applied your formula earlier 
> itself. but i need even better solution. and my dash board data range is 
> not constant if this data set count increase or decrease on daily basis. 
> that scenario  every time we are going to apply refresh or expand data 
> option for PIVOT it is time consuming process  
>
>
> so kindly think even better output for this problem..
>
>
> On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote:
>
>> Its not possible to do without any help column.
>>
>> Another way out is shown in attached file. Ref col E & F.
>>
>> Thx
>>
>>
>> On Tue, Apr 29, 2014 at 2:34 PM, renuka chari wrote:
>>
>>> Dear sir,
>>>  
>>> i dont want to use pivot. i need only formula for offset or index is 
>>> it possible...
>>>
>>> On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
>>>
 Hi 

 You can do using Pivot Table, see attached file.

  
1. In the Pivot Table, click the drop down arrow in the 
RowLabels field heading. 
2. In the pop-up menu, click Value Filters, then click Top 10 & 
change it to 5.

 You can sort on Descending on Output by going thru More Sort option 
 under filter

 Cheers!


 On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee <
 jva@gmail.com> wrote:

> Dear experts,
>
> please help me
>
>
> Thanks & Regards´¨)
>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>
> P Let us do our best to save nature, save water, plant trees, 
> protect
> greenery, keep our surroundings clean, reduce usage of plastics, 
> and
> use renewable energy sources.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna 
> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
> forum @ 
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like 
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
> Need 
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any 
> security measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google 
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, 
> send an email to excel-macros...@googlegroups.com.
> To post to this group, send email to excel-...@googlegroups.com.
>
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear Sir,

countif function creating more violation for huge data range. is there any 
possible to overcome or use any other function. 

please guide me...

thanks...



On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote:
>
> Dear sir,
>
> thank you so much.your given a great help..
>
>
> On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:
>>
>> Hi
>>
>> PFA alternate method using formula & help sheet.
>>
>> Thanks
>>
>>
>> On Tue, Apr 29, 2014 at 8:57 PM, renuka chari  wrote:
>>
>>> Dear sir,
>>>
>>> Thank you so much for your time and effort into problem.
>>>
>>> my dashboard having huge no of sheets and if i make pivot sheet then my 
>>> workbook size is increasing more i was applied your formula earlier itself. 
>>> but i need even better solution. and my dash board data range is not 
>>> constant if this data set count increase or decrease on daily basis. that 
>>> scenario  every time we are going to apply refresh or expand data option 
>>> for PIVOT it is time consuming process  
>>>
>>>
>>> so kindly think even better output for this problem..
>>>
>>>
>>> On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote:
>>>
 Its not possible to do without any help column.

 Another way out is shown in attached file. Ref col E & F.

 Thx


 On Tue, Apr 29, 2014 at 2:34 PM, renuka chari wrote:

> Dear sir,
>  
> i dont want to use pivot. i need only formula for offset or index is 
> it possible...
>
> On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
>
>> Hi 
>>
>> You can do using Pivot Table, see attached file.
>>
>>  
>>1. In the Pivot Table, click the drop down arrow in the RowLabels 
>>field heading. 
>>2. In the pop-up menu, click Value Filters, then click Top 10 & 
>>change it to 5.
>>
>> You can sort on Descending on Output by going thru More Sort option 
>> under filter
>>
>> Cheers!
>>
>>
>> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee <
>> jva@gmail.com> wrote:
>>
>>> Dear experts,
>>>
>>> please help me
>>>
>>>
>>> Thanks & Regards´¨)
>>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>>
>>> P Let us do our best to save nature, save water, plant trees, protect
>>> greenery, keep our surroundings clean, reduce usage of plastics, and
>>> use renewable energy sources.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE  : Don't ever post confidential data in a workbook. Forum 
>>> owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, 
>>> send an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like 
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners 
> and members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the G

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear sir,

thank you so much.your given a great help..


On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:
>
> Hi
>
> PFA alternate method using formula & help sheet.
>
> Thanks
>
>
> On Tue, Apr 29, 2014 at 8:57 PM, renuka chari 
> > wrote:
>
>> Dear sir,
>>
>> Thank you so much for your time and effort into problem.
>>
>> my dashboard having huge no of sheets and if i make pivot sheet then my 
>> workbook size is increasing more i was applied your formula earlier itself. 
>> but i need even better solution. and my dash board data range is not 
>> constant if this data set count increase or decrease on daily basis. that 
>> scenario  every time we are going to apply refresh or expand data option 
>> for PIVOT it is time consuming process  
>>
>>
>> so kindly think even better output for this problem..
>>
>>
>> On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote:
>>
>>> Its not possible to do without any help column.
>>>
>>> Another way out is shown in attached file. Ref col E & F.
>>>
>>> Thx
>>>
>>>
>>> On Tue, Apr 29, 2014 at 2:34 PM, renuka chari  wrote:
>>>
 Dear sir,
  
 i dont want to use pivot. i need only formula for offset or index is it 
 possible...

 On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:

> Hi 
>
> You can do using Pivot Table, see attached file.
>
>  
>1. In the Pivot Table, click the drop down arrow in the RowLabels 
>field heading. 
>2. In the pop-up menu, click Value Filters, then click Top 10 & 
>change it to 5.
>
> You can sort on Descending on Output by going thru More Sort option 
> under filter
>
> Cheers!
>
>
> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee  > wrote:
>
>> Dear experts,
>>
>> please help me
>>
>>
>> Thanks & Regards´¨)
>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>
>> P Let us do our best to save nature, save water, plant trees, protect
>> greenery, keep our surroundings clean, reduce usage of plastics, and
>> use renewable energy sources.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners 
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google 
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, 
>> send an email to excel-macros...@googlegroups.com.
>> To post to this group, send email to excel-...@googlegroups.com.
>>
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners 
 and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>  

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear sir,

Thank you so much for your time and effort into problem.

my dashboard having huge no of sheets and if i make pivot sheet then my 
workbook size is increasing more i was applied your formula earlier itself. 
but i need even better solution. and my dash board data range is not 
constant if this data set count increase or decrease on daily basis. that 
scenario  every time we are going to apply refresh or expand data option 
for PIVOT it is time consuming process  


so kindly think even better output for this problem..

On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote:
>
> Its not possible to do without any help column.
>
> Another way out is shown in attached file. Ref col E & F.
>
> Thx
>
>
> On Tue, Apr 29, 2014 at 2:34 PM, renuka chari 
> > wrote:
>
>> Dear sir,
>>  
>> i dont want to use pivot. i need only formula for offset or index is it 
>> possible...
>>
>> On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
>>
>>> Hi 
>>>
>>> You can do using Pivot Table, see attached file.
>>>
>>>  
>>>1. In the Pivot Table, click the drop down arrow in the RowLabels 
>>>field heading. 
>>>2. In the pop-up menu, click Value Filters, then click Top 10 & 
>>>change it to 5.
>>>
>>> You can sort on Descending on Output by going thru More Sort option 
>>> under filter
>>>
>>> Cheers!
>>>
>>>
>>> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee 
>>> wrote:
>>>
 Dear experts,

 please help me


 Thanks & Regards´¨)
   ¸ •´ ¸.•*´¨)   ¸.•*¨)
  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪

 P Let us do our best to save nature, save water, plant trees, protect
 greenery, keep our surroundings clean, reduce usage of plastics, and
 use renewable energy sources.

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

 FORUM RULES

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

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

 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

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

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any sec

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[Vaibhav Joshi]

Its not possible to do without any help column.

Another way out is shown in attached file. Ref col E & F.

Thx


On Tue, Apr 29, 2014 at 2:34 PM, renuka chari  wrote:

> Dear sir,
>
> i dont want to use pivot. i need only formula for offset or index is it
> possible...
>
> On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
>
>> Hi
>>
>> You can do using Pivot Table, see attached file.
>>
>>
>>1. In the Pivot Table, click the drop down arrow in the RowLabels
>>field heading.
>>2. In the pop-up menu, click Value Filters, then click Top 10 &
>>change it to 5.
>>
>> You can sort on Descending on Output by going thru More Sort option under
>> filter
>>
>> Cheers!
>>
>>
>> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee wrote:
>>
>>> Dear experts,
>>>
>>> please help me
>>>
>>>
>>> Thanks & Regards´¨)
>>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>>
>>> P Let us do our best to save nature, save water, plant trees, protect
>>> greenery, keep our surroundings clean, reduce usage of plastics, and
>>> use renewable energy sources.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE  : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


Return Top5.xlsx
Description:

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear sir,
 
i dont want to use pivot. i need only formula for offset or index is it 
possible...
On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:

> Hi 
>
> You can do using Pivot Table, see attached file.
>
>  
>1. In the Pivot Table, click the drop down arrow in the RowLabels 
>field heading. 
>2. In the pop-up menu, click Value Filters, then click Top 10 & change 
>it to 5.
>
> You can sort on Descending on Output by going thru More Sort option under 
> filter
>
> Cheers!
>
>
> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee 
> 
> > wrote:
>
>> Dear experts,
>>
>> please help me
>>
>>
>> Thanks & Regards´¨)
>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>
>> P Let us do our best to save nature, save water, plant trees, protect
>> greenery, keep our surroundings clean, reduce usage of plastics, and
>> use renewable energy sources.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[Vaibhav Joshi]

Hi

You can do using Pivot Table, see attached file.


   1. In the Pivot Table, click the drop down arrow in the RowLabels field
   heading.
   2. In the pop-up menu, click Value Filters, then click Top 10 & change
   it to 5.

You can sort on Descending on Output by going thru More Sort option under
filter

Cheers!


On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee wrote:

> Dear experts,
>
> please help me
>
>
> Thanks & Regards´¨)
>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>
> P Let us do our best to save nature, save water, plant trees, protect
> greenery, keep our surroundings clean, reduce usage of plastics, and
> use renewable energy sources.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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


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

$$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[Renukachari Kasee]

Dear experts,

please help me


Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪

P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and
use renewable energy sources.

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

FORUM RULES

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

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


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

$$Excel-Macros$$ Please help me adding variables to my macro

[Mccue]

I am attaching a macro that I recorded. But I need the variables to be 
updated
 
Basically this macro is going thru several tabs and update the pivot tables 
by simply changing the dates.
 
So everytime I run the macro, I want dates in these pivot tables to be 
updated to today.
 
Please look at the attached.
Thanks

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

FORUM RULES

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

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




Book3.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

[Aindril De]

Dear GRKNAIDU,

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

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

Regards,
Aindril

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

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



-- 

Warm Regards,
Aindril De
Ph: 9811300157

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

[vba]

Hi

Download this extension and Install.

www.microsoft.com/en-us/download/details.aspx?id=7

Rgds//Vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Constantin Zamfir 
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Oct 2012 20:58:18 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help me to set default folder for print 
PDF's.

Yes, but in the combobox "Save as type:" I don't have PDF format.

Best regards,
*Constantin ZAMFIR*
Service engineer,
Euritmic Grup SRL <http://www.euritmicgrup.ro/> - Romania
Mobil: +40 741-105-012  (Orange)
Mobil: +40 726-226-021  (Cosmote)
*Before printing this e-mail please consider environment protection*
*
---
*
*
*



2012/10/19 

> **
> Hi,
>
> Insted of printing with the help of Nitro PDF you can save file as PDF.
>
> Rgds//Vabs
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Constantin Zamfir 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 19 Oct 2012 10:35:38 -0700 (PDT)
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Please help me to set default folder for
> print PDF's.
>
> I have a macro in an Excel document that print 5 sheets in different
> folders with different names. Always have to navigate to the desired folder
> and write the desired name, which slows my work, since I'm doing this for
> 30-50 times per day.
> I want to automate this in my macro, but I do not know how to change the
> default print folder for NitroPDF 7 and the default name for the file to be
> printed.
>
> --
> 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 receiv

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

[Constantin Zamfir]

Yes, but in the combobox "Save as type:" I don't have PDF format.

Best regards,
*Constantin ZAMFIR*
Service engineer,
Euritmic Grup SRL <http://www.euritmicgrup.ro/> - Romania
Mobil: +40 741-105-012  (Orange)
Mobil: +40 726-226-021  (Cosmote)
*Before printing this e-mail please consider environment protection*
*
---
*
*
*



2012/10/19 

> **
> Hi,
>
> Insted of printing with the help of Nitro PDF you can save file as PDF.
>
> Rgds//Vabs
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Constantin Zamfir 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 19 Oct 2012 10:35:38 -0700 (PDT)
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Please help me to set default folder for
> print PDF's.
>
> I have a macro in an Excel document that print 5 sheets in different
> folders with different names. Always have to navigate to the desired folder
> and write the desired name, which slows my work, since I'm doing this for
> 30-50 times per day.
> I want to automate this in my macro, but I do not know how to change the
> default print folder for NitroPDF 7 and the default name for the file to be
> printed.
>
> --
> 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$$ Please help me to set default folder for print PDF's.

[vba]

Hi,

Insted of printing with the help of Nitro PDF you can save file as PDF.

Rgds//Vabs

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Constantin Zamfir 
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Oct 2012 10:35:38 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

I have a macro in an Excel document that print 5 sheets in different 
folders with different names. Always have to navigate to the desired folder 
and write the desired name, which slows my work, since I'm doing this for 
30-50 times per day. 
I want to automate this in my macro, but I do not know how to change the 
default print folder for NitroPDF 7 and the default name for the file to be 
printed.

-- 
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$$ Please help me to set default folder for print PDF's.

[Constantin Zamfir]

I have a macro in an Excel document that print 5 sheets in different 
folders with different names. Always have to navigate to the desired folder 
and write the desired name, which slows my work, since I'm doing this for 
30-50 times per day. 
I want to automate this in my macro, but I do not know how to change the 
default print folder for NitroPDF 7 and the default name for the file to be 
printed.

-- 
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$$ please help me to solve this question it's very urgent

[dguillett1]

The "team" will be happier to help if you use a meaningful subject line and 
lose the URGENT!!!




Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: PRAVESH KUMAR

Sent: Friday, August 31, 2012 1:09 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ please help me to solve this question it's 
very urgent


Hi team,


Thanks so much for help me and give best to best Suggestions

Thanks
Pravesh Kumar


On 8/30/12, Kuldeep Singh  wrote:

Dear Preavesh,

04 solutions of you. for any query please see attachment.

=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
=VLOOKUP(H3,$C$3:$D$9,2,0)
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Regards,
Kuldeep Singh

On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
wrote:


Hi Pravesh,

Find the attached solved file.

=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Reagrds
Amresh

On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
vaishpriyanka2...@gmail.com> wrote:


Hi Pravesh,

  =VLOOKUP($H3,$C$3:$D$9,2,0)

I think this formula would solve your question.

On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
 wrote:


Hi Team,

please help me to solve this question it's very urgent


waiting your response



--

Thanks & Regards

Pravesh Kumar

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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

[PRAVESH KUMAR]

Hi amresh,

Thanks! for help me


On 8/30/12, Amresh Maurya  wrote:
> Hi Pravesh,
>
> Find the attached solved file.
>
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Reagrds
> Amresh
>
> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
> vaishpriyanka2...@gmail.com> wrote:
>
>> Hi Pravesh,
>>
>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>
>> I think this formula would solve your question.
>>
>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
>> wrote:
>>
>>> Hi Team,
>>>
>>> please help me to solve this question it's very urgent
>>>
>>>
>>> waiting your response
>>>
>>>
>>>
>>> --
>>>
>>> Thanks & Regards
>>>
>>> Pravesh Kumar
>>>
>>> --
>>> 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.
>
>
>


-- 

Thanks & Regards

Pravesh Kumar

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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

[Kuldeep Singh]

Dear Pravesh,

Your most welcome.

Regards,
Kuldeep Singh

On Fri, Aug 31, 2012 at 11:39 PM, PRAVESH KUMAR wrote:

> Hi team,
>
>
> Thanks so much for help me and give best to best Suggestions
>
> Thanks
> Pravesh Kumar
>
>
> On 8/30/12, Kuldeep Singh  wrote:
> > Dear Preavesh,
> >
> > 04 solutions of you. for any query please see attachment.
> >
> > =LOOKUP(H3,$C$3:$D$9)
> > =VLOOKUP(H3:H6,$C$3:$D$9,2,0)
> > =VLOOKUP(H3,$C$3:$D$9,2,0)
> > =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
> >
> > Regards,
> > Kuldeep Singh
> >
> > On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
> > wrote:
> >
> >> Hi Pravesh,
> >>
> >> Find the attached solved file.
> >>
> >> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
> >>
> >> Reagrds
> >> Amresh
> >>
> >> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
> >> vaishpriyanka2...@gmail.com> wrote:
> >>
> >>> Hi Pravesh,
> >>>
> >>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
> >>>
> >>> I think this formula would solve your question.
> >>>
> >>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
> >>>  >>> > wrote:
> >>>
>  Hi Team,
> 
>  please help me to solve this question it's very urgent
> 
> 
>  waiting your response
> 
> 
> 
>  --
> 
>  Thanks & Regards
> 
>  Pravesh Kumar
> 
>  --
>  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
> >> o

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

[PRAVESH KUMAR]

Hi team,


Thanks so much for help me and give best to best Suggestions

Thanks
Pravesh Kumar


On 8/30/12, Kuldeep Singh  wrote:
> Dear Preavesh,
>
> 04 solutions of you. for any query please see attachment.
>
> =LOOKUP(H3,$C$3:$D$9)
> =VLOOKUP(H3:H6,$C$3:$D$9,2,0)
> =VLOOKUP(H3,$C$3:$D$9,2,0)
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Regards,
> Kuldeep Singh
>
> On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
> wrote:
>
>> Hi Pravesh,
>>
>> Find the attached solved file.
>>
>> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>>
>> Reagrds
>> Amresh
>>
>> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
>> vaishpriyanka2...@gmail.com> wrote:
>>
>>> Hi Pravesh,
>>>
>>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>>
>>> I think this formula would solve your question.
>>>
>>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
>>> >> > wrote:
>>>
 Hi Team,

 please help me to solve this question it's very urgent


 waiting your response



 --

 Thanks & Regards

 Pravesh Kumar

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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

[dguillett1]

I see you have answers but why is YOUR request more URGENT than any other?
Also, use a meaningful subject line and explain your question in the email 
and in the file.

etc.



Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: PRAVESH KUMAR

Sent: Wednesday, August 29, 2012 11:30 PM
To: excel-macros ; excelvbaclinic
Subject: $$Excel-Macros$$ please help me to solve this question it's very 
urgent


Hi Team,

please help me to solve this question it's very urgent


waiting your response



--

Thanks & Regards

Pravesh Kumar

--
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$$ please help me to solve this question it's very urgent

[अनिल नारायण गवली]

Dear Pravesh,

Enclosed herewith your query solu

Regards,
Gawli Anil
On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh wrote:

>
> Dear Preavesh,
>
> 04 solutions of you. for any query please see attachment.
>
> =LOOKUP(H3,$C$3:$D$9)
> =VLOOKUP(H3:H6,$C$3:$D$9,2,0)
> =VLOOKUP(H3,$C$3:$D$9,2,0)
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Regards,
> Kuldeep Singh
>
>
> On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya 
> wrote:
>
>> Hi Pravesh,
>>
>> Find the attached solved file.
>>
>> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>>
>> Reagrds
>> Amresh
>>
>>  On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
>> vaishpriyanka2...@gmail.com> wrote:
>>
>>> Hi Pravesh,
>>>
>>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>>
>>> I think this formula would solve your question.
>>>
>>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR <
>>> praveshkash...@gmail.com> wrote:
>>>
 Hi Team,

 please help me to solve this question it's very urgent


 waiting your response



 --

 Thanks & Regards

 Pravesh Kumar

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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

[Kuldeep Singh]

Dear Preavesh,

04 solutions of you. for any query please see attachment.

=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
=VLOOKUP(H3,$C$3:$D$9,2,0)
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Regards,
Kuldeep Singh

On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya wrote:

> Hi Pravesh,
>
> Find the attached solved file.
>
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Reagrds
> Amresh
>
> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
> vaishpriyanka2...@gmail.com> wrote:
>
>> Hi Pravesh,
>>
>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>
>> I think this formula would solve your question.
>>
>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR > > wrote:
>>
>>> Hi Team,
>>>
>>> please help me to solve this question it's very urgent
>>>
>>>
>>> waiting your response
>>>
>>>
>>>
>>> --
>>>
>>> Thanks & Regards
>>>
>>> Pravesh Kumar
>>>
>>> --
>>> 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 thread of another member.

3) Don't post 

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

[Amresh Maurya]

Hi Pravesh,

Find the attached solved file.

=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Reagrds
Amresh

On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
vaishpriyanka2...@gmail.com> wrote:

> Hi Pravesh,
>
>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>
> I think this formula would solve your question.
>
> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR 
> wrote:
>
>> Hi Team,
>>
>> please help me to solve this question it's very urgent
>>
>>
>> waiting your response
>>
>>
>>
>> --
>>
>> Thanks & Regards
>>
>> Pravesh Kumar
>>
>> --
>> 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.




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

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

[Priyanka Vaish]

Hi Pravesh,

  =VLOOKUP($H3,$C$3:$D$9,2,0)

I think this formula would solve your question.

On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR wrote:

> Hi Team,
>
> please help me to solve this question it's very urgent
>
>
> waiting your response
>
>
>
> --
>
> Thanks & Regards
>
> Pravesh Kumar
>
> --
> 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$$ please help me to solve this question it's very urgent

[Ashish Bhalara]

Mr. Pravesh

See the attached file and kindly refer the forum rules, the subject line
must be clear regarding your query

Ashish

On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR wrote:

> Hi Team,
>
> please help me to solve this question it's very urgent
>
>
> waiting your response
>
>
>
> --
>
> Thanks & Regards
>
> Pravesh Kumar
>
> --
> 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.
>
>
>


-- 
Thanks & regards.

Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

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




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

$$Excel-Macros$$ please help me to solve this question it's very urgent

[PRAVESH KUMAR]

Hi Team,

please help me to solve this question it's very urgent


waiting your response



-- 

Thanks & Regards

Pravesh Kumar

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




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

Re: $$Excel-Macros$$ Please help me.

[Mangesh Vimay]

Thanks Deba. Its very nice even before using it I never know that Excel
could do all these stuff so nicely.
Thanks again Dear.

On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan  wrote:

> Dear Mangesh,
>
> To create this calendar in the range B2:H9, follow these steps:
>
>
> 1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge &
> Center.
>
> 2. Enter a date into the merged range. The day of the month isn’t
> important.
>
> 3. Enter the abbreviated day names in the range B3:H3.
>
> Performing Magic with Array Formulas
>
> 4. Select B4:H9 and enter this array formula. Remember: To enter an array
> formula, press
> Ctrl+Shift+Enter (not just Enter).
>
> {=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))<>MONTH(DATE(YEAR(B2),
> MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+
> {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,
> DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT
> H(B2),1))-1)+
>
> {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)}
>
>
> 5. Format the range B4:H9 to use this custom number format: d. This step
> formats the
> dates to show only the day. Use the Custom category in the Number tab of
> the Format
> Cells dialog box to specify this custom number format.
>
> 6. Adjust the column widths and format the cells as you like.
>
>
> 7. Change the month and year in cell B2. The calendar updates
> automatically.
> After creating this calendar, you can copy the range to any other
> worksheet or workbook.
>
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
>
>
> On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay wrote:
>
>> Please tell us so that we can edit and learn it. How to make ?
>> calender_Simple.xls file
>>
>>
>> On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Manoj,
>>>
>>> Please find attached simple Calender.
>>>
>>> You can create it simply.
>>>
>>> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar <
>>> kumarmanoj.11...@gmail.com> wrote:
>>>
 Dear Expert,


 I want to make Calender on excel

 when i enter year & month in a coll it show me date wise calender...



 Regard
 Manoj

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

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

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

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

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

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

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


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

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

Re: $$Excel-Macros$$ Please help me.

[Deba Ranjan]

Dear Mangesh,

To create this calendar in the range B2:H9, follow these steps:


1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge &
Center.

2. Enter a date into the merged range. The day of the month isn’t important.

3. Enter the abbreviated day names in the range B3:H3.

Performing Magic with Array Formulas

4. Select B4:H9 and enter this array formula. Remember: To enter an array
formula, press
Ctrl+Shift+Enter (not just Enter).

{=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))<>MONTH(DATE(YEAR(B2),
MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,
DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT
H(B2),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)}


5. Format the range B4:H9 to use this custom number format: d. This step
formats the
dates to show only the day. Use the Custom category in the Number tab of
the Format
Cells dialog box to specify this custom number format.

6. Adjust the column widths and format the cells as you like.


7. Change the month and year in cell B2. The calendar updates
automatically.
After creating this calendar, you can copy the range to any other worksheet
or workbook.




Thanks & Regards,
*Deba Ranjan P*





On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay wrote:

> Please tell us so that we can edit and learn it. How to make ?
> calender_Simple.xls file
>
>
> On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI  > wrote:
>
>> Dear Manoj,
>>
>> Please find attached simple Calender.
>>
>> You can create it simply.
>>
>> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar > > wrote:
>>
>>> Dear Expert,
>>>
>>>
>>> I want to make Calender on excel
>>>
>>> when i enter year & month in a coll it show me date wise calender...
>>>
>>>
>>>
>>> Regard
>>> Manoj
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
-- 
FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Please help me.

[Mangesh Vimay]

Please tell us so that we can edit and learn it. How to make ?
calender_Simple.xls file

On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI
wrote:

> Dear Manoj,
>
> Please find attached simple Calender.
>
> You can create it simply.
>
> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar 
> wrote:
>
>> Dear Expert,
>>
>>
>> I want to make Calender on excel
>>
>> when i enter year & month in a coll it show me date wise calender...
>>
>>
>>
>> Regard
>> Manoj
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Please help me.

[Deba Ranjan]

Dear Manoj,

Calender in excel can be prepared by Array formula too, its purely full
array for whole the months and years.

=IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)


Thanks & Regards,
*Deba Ranjan P*





On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar wrote:

> Dear Expert,
>
>
> I want to make Calender on excel
>
> when i enter year & month in a coll it show me date wise calender...
>
>
>
> Regard
> Manoj
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

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

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

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

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

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

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

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

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

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

RE: $$Excel-Macros$$ Please help me.

[Rajan_Verma]

 

 

=IFERROR(FIND([@Particulars],[@[Specification Marks, If Any]],1)>0,FALSE)

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 11 July 2012 2:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help me.

 

Dear Suman,

It is working fine with table, Pls see the attached sheet.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com

 <http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.com

 

On Wed, Jul 11, 2012 at 1:43 PM, Suman  wrote:

Hi,
Guru Ji,
Its not working when i applying in table. Please guide...!!

Regards,
@Suman
Send on the move with Galexy y.

On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI"  wrote:

Dear Manoj,

You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
wrote:

Dear Expert.

 

i have 2 Coll A1 & B2

 

A1 Contain (Foto Fast Elec)

B1 Contain (Fast)

 

I want khow B1 is in A1 or not...

 

Regard

Manoj

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> 



 

 

 

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> 

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

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com> 




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com

 <http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.com

 



 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited

Re: $$Excel-Macros$$ Please help me.

[NOORAIN ANSARI]

Dear Suman,

It is working fine with table, Pls see the attached sheet.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Wed, Jul 11, 2012 at 1:43 PM, Suman  wrote:

> Hi,
> Guru Ji,
> Its not working when i applying in table. Please guide...!!
>
> Regards,
> @Suman
> Send on the move with Galexy y.
> On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI" 
> wrote:
>
>> Dear Manoj,
>>
>> You can also try
>> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>>
>> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
>> wrote:
>>
>>> Dear Expert.
>>>
>>> i have 2 Coll A1 & B2
>>>
>>> A1 Contain (Foto Fast Elec)
>>> B1 Contain (Fast)
>>>
>>> I want khow B1 is in A1 or not...
>>>
>>> Regard
>>> Manoj
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

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

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

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

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

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

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

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

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

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

Suman(test).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help me.

[Suman]

Hi,
Guru Ji,
Its not working when i applying in table. Please guide...!!

Regards,
@Suman
Send on the move with Galexy y.
On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI"  wrote:

> Dear Manoj,
>
> You can also try
> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>
> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
> wrote:
>
>> Dear Expert.
>>
>> i have 2 Coll A1 & B2
>>
>> A1 Contain (Foto Fast Elec)
>> B1 Contain (Fast)
>>
>> I want khow B1 is in A1 or not...
>>
>> Regard
>> Manoj
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Please help me.

[Manoj Kumar]

Thanks Noorain Ji...
its working..


On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI wrote:

> Dear Manoj,
>
> You can also try
> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>
> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
> wrote:
>
>> Dear Expert.
>>
>> i have 2 Coll A1 & B2
>>
>> A1 Contain (Foto Fast Elec)
>> B1 Contain (Fast)
>>
>> I want khow B1 is in A1 or not...
>>
>> Regard
>> Manoj
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Please help me.

[NOORAIN ANSARI]

Dear Manoj,

You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar wrote:

> Dear Expert.
>
> i have 2 Coll A1 & B2
>
> A1 Contain (Foto Fast Elec)
> B1 Contain (Fast)
>
> I want khow B1 is in A1 or not...
>
> Regard
> Manoj
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Please help me.

[Amresh Maurya]

Hi,

use below formula

=find(B1,A1)

Regards
Amresh

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar  wrote:
> Dear Expert.
>
> i have 2 Coll A1 & B2
>
> A1 Contain (Foto Fast Elec)
> B1 Contain (Fast)
>
> I want khow B1 is in A1 or not...
>
> Regard
> Manoj
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Please Help me to create summary and Macro.

[Avinash Patil]

thank you so much thnx thnx thnx thnx thnx it works awesome gre8 work thank
u once again.

On Monday, January 30, 2012, dguillett1  wrote:
> The formula simply reformats your entry to an entry that excel will use
and then uses INDIRECT. Google or look in the help index for EXCEL:INDIRECT
> See attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
>
> Dear Don,
>
>
>
> Thanks for your help but can u please explain me how this formula works I
have tried to search for the information on Google
>
> but I din understand anything so can u please explain.
>
> and by the u have given exact solution for my query. I just want another
addition in the results.
>
>
>
> like hyperlink to that day it means if the data is for 4 Jan then there
should b a link which will be useful to navigate to that sheet
>
> but it should not be in default hyperlink format like blue font and
underline it should be in red font.
>
> please reply if it is possible attached is the sample of the result and
>
>
>
> Results Based On Links but not useful if I have to show details for 10
days
>
>
>
> it means if I create a link for total product 05 (='Jan 04'!B14)   then I
have to use same technique for every result and if I there will be data for
10 days then It will take a lot of time.
>
> please see the attachment.
>
>
>
> Thanks for your help and u r genius man.
>
>
>
> Regards,
>
>
>
> Avinash
>
>
>
> On Sun, Jan 29, 2012 at 8:20 PM, dguillett1  wrote:
>
> Since ALL requests are important and serious, please do NOT mention that
in your post as it offends some of us.
> See attached using
>
> '=INDIRECT("'" & TEXT($C$7,"MMM DD") & "'!B14")
>
> Don’t understand this request
> Results Basssed On Links but not usefull if I have to show details for 10
days
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Friday, January 27, 2012 7:41 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
> Hi Experts,
>
>
> i am currently facing very serious problem cuz every day i have to
generate data from various workbooks wich is bassed on the daily reports.
>
> and i have to show any increase or decrease on any perticular day
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
>
>
--
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
Sent from Gmail Mobile

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

[Avinash Patil]

thank you so much thnx thnx thnx thnx thnx it works awesome gre8 work thank
u once again.

On Monday, January 30, 2012, dguillett1  wrote:
> The formula simply reformats your entry to an entry that excel will use
and then uses INDIRECT. Google or look in the help index for EXCEL:INDIRECT
> See attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
>
> Dear Don,
>
>
>
> Thanks for your help but can u please explain me how this formula works I
have tried to search for the information on Google
>
> but I din understand anything so can u please explain.
>
> and by the u have given exact solution for my query. I just want another
addition in the results.
>
>
>
> like hyperlink to that day it means if the data is for 4 Jan then there
should b a link which will be useful to navigate to that sheet
>
> but it should not be in default hyperlink format like blue font and
underline it should be in red font.
>
> please reply if it is possible attached is the sample of the result and
>
>
>
> Results Based On Links but not useful if I have to show details for 10
days
>
>
>
> it means if I create a link for total product 05 (='Jan 04'!B14)   then I
have to use same technique for every result and if I there will be data for
10 days then It will take a lot of time.
>
> please see the attachment.
>
>
>
> Thanks for your help and u r genius man.
>
>
>
> Regards,
>
>
>
> Avinash
>
>
>
> On Sun, Jan 29, 2012 at 8:20 PM, dguillett1  wrote:
>
> Since ALL requests are important and serious, please do NOT mention that
in your post as it offends some of us.
> See attached using
>
> '=INDIRECT("'" & TEXT($C$7,"MMM DD") & "'!B14")
>
> Don’t understand this request
> Results Basssed On Links but not usefull if I have to show details for 10
days
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Friday, January 27, 2012 7:41 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Please Help me to create summary and Macro.
>
> Hi Experts,
>
>
> i am currently facing very serious problem cuz every day i have to
generate data from various workbooks wich is bassed on the daily reports.
>
> and i have to show any increase or decrease on any perticular day
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
>
>
--
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
Sent from Gmail Mobile

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

[Avinash Patil]

yes dilip, i guess u r  right. i want the results as per the results
highlighted in red border. and hyperlink format in red font.

regards,
Avinash



On Sun, Jan 29, 2012 at 12:31 PM, Dilip Pandey  wrote:

> Hi Avinash,
>
> Not entirely getting your point.
> Please confirm if you need following < which I can understand per your
> post> :)
>
> 1) Following results as per Date in first field < this you have
> already attached>
>
> DateTotal Product   Actual PriceTotal Number Of Products
>  Grand
> Total   Sheet Location
>
> 2) Hyperlink in last field to each row entered
> ?
>
> I believe either you are explained too much in your post or missed to
> put the crux of your issue in lime light.  :)
>
> Regards,
> DILIPandey
>
> On 1/27/12, Avinash Patil  wrote:
> > Hi Experts,
> >
> >
> > i am currently facing very serious problem cuz every day i have to
> generate
> > data from various workbooks wich is bassed on the daily reports.
> >
> > and i have to show any increase or decrease on any perticular day
> >
> > to get this done i have to insert 1 sheet called summary it contains
> > following details like day wise details.
> >
> > but to show the day wise performance i have to link specific cells
> >
> >
> > e.g
> >
> > sheet name jan 01
> >
> >
> > total products = 06  (D14)
> >
> > so if the client wants to see performance for the specific day i have to
> > vlookup for the results
> >
> > and the lookup is bassed on summary sheet
> >
> >
> > plus if there there will be uncertain increase or decrease in the data i
> > have to create link for that specific day.
> >
> > but link should not be in hyperlink format it should b  in normal format
> > but only highlited in red font.
> >
> >
> > and by the way i have to create summary sheet for my refrence not for
> client
> >
> > client want result only for specific day like for increase and decrease.
> >
> > client result is using red border.
> >
> >
> > i have attached the sheet for your refrence
> >
> > please see the attached file and kindly help me in this regards.
> >
> >
> > if possible can anyone please prepare a macro/formula  to get the details
> >
> > --
> >
> > Thanks and Regards,
> >
> >  Avinash
> >
> > "Love does not happen its a choice. Its not magic or fate, but it is
> when a
> > person takes their natural affinity/attraction for someone and translates
> > it into commitment and actions that express love."
> >
> >
> > Disclaimer: The information transmitted is intended only for the
> person(s)
> > or entity to which it is addressed and may contain confidential and/or
> > privileged material. If you are not the intended recipient of this
> message
> > you are hereby notified that any use, review, retransmission,
> > dissemination, distribution, reproduction or any action taken in reliance
> > upon this message is prohibited. If you receive this in error, please
> > contact the sender
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Thanks and Regards,

 Avinash Patil

"Love does not happen it

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

[Dilip Pandey]

Hi Avinash,

Not entirely getting your point.
Please confirm if you need following < which I can understand per your post> :)

1) Following results as per Date in first field < this you have
already attached>

DateTotal Product   Actual PriceTotal Number Of ProductsGrand
Total   Sheet Location

2) Hyperlink in last field to each row entered
?

I believe either you are explained too much in your post or missed to
put the crux of your issue in lime light.  :)

Regards,
DILIPandey

On 1/27/12, Avinash Patil  wrote:
> Hi Experts,
>
>
> i am currently facing very serious problem cuz every day i have to generate
> data from various workbooks wich is bassed on the daily reports.
>
> and i have to show any increase or decrease on any perticular day
>
> to get this done i have to insert 1 sheet called summary it contains
> following details like day wise details.
>
> but to show the day wise performance i have to link specific cells
>
>
> e.g
>
> sheet name jan 01
>
>
> total products = 06  (D14)
>
> so if the client wants to see performance for the specific day i have to
> vlookup for the results
>
> and the lookup is bassed on summary sheet
>
>
> plus if there there will be uncertain increase or decrease in the data i
> have to create link for that specific day.
>
> but link should not be in hyperlink format it should b  in normal format
> but only highlited in red font.
>
>
> and by the way i have to create summary sheet for my refrence not for client
>
> client want result only for specific day like for increase and decrease.
>
> client result is using red border.
>
>
> i have attached the sheet for your refrence
>
> please see the attached file and kindly help me in this regards.
>
>
> if possible can anyone please prepare a macro/formula  to get the details
>
> --
>
> Thanks and Regards,
>
>  Avinash
>
> "Love does not happen its a choice. Its not magic or fate, but it is when a
> person takes their natural affinity/attraction for someone and translates
> it into commitment and actions that express love."
>
>
> Disclaimer: The information transmitted is intended only for the person(s)
> or entity to which it is addressed and may contain confidential and/or
> privileged material. If you are not the intended recipient of this message
> you are hereby notified that any use, review, retransmission,
> dissemination, distribution, reproduction or any action taken in reliance
> upon this message is prohibited. If you receive this in error, please
> contact the sender
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ PLEASE HELP ME

[dguillett1]

You need to tell us what you want and why
This cell _on this sheet___in this file_
needs to come from
This cell _on this sheet___in this file_
and WHY

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Chandra Singh Bora 
Sent: Friday, December 09, 2011 11:40 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ PLEASE HELP ME

DEAR ALL MY EXCEL FRND.
PLEASE SEND SOME FORMULA FOR MEDAL TALLY & CHAMPIANSHIP


 


Chandra Singh Bohra
Champawat
Uttrakhand



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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Please help me(Combo box)

[always online]

Dear Friends

Thank your very much for your great reply.
may u define this formula. I can not find any source for *Groups* . I am
using that other place that function is not working.

Thanks again
Sanjay Kumar Maurya

On Thu, Aug 4, 2011 at 5:18 AM, XLS S  wrote:

> Hey Sanjay
>
> Try to use Indirect Functionplease find the attachment
>
>
>
> On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya 
> wrote:
> > Dear Frd
> >
> > Thanks for your reply and solution but I have more data so pivot table
> > is not possible for it. if u have any easy format please tell me.
> >
> > Thanks
> > Sanjay Kumar Maurya
> >
> > On 8/3/11, sreejith k.s  wrote:
> >> hi Sanjay,
> >>
> >> just see whether this helps...i created a pivot according to my
> >> understanding of the quwestion...just get back to me if it is not enough
> >>
> >> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
> >> wrote:
> >>
> >>> Hi frds
> >>>
> >>> Please help me.
> >>>
> >>> --
> >>> ***Thanks
> >>> Sanjay Kumar Maurya*
> >>>
> >>> --
> >>>
> >>>
> --
> >>> Some important links for excel users:
> >>> 1. Follow us on TWITTER for tips tricks and links :
> >>> http://twitter.com/exceldailytip
> >>> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>>
> >>> To post to this group, send email to excel-macros@googlegroups.com
> >>>
> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >>> Like our page on facebook , Just follow below link
> >>> http://www.facebook.com/discussexcel
> >>>
> >>
> >> --
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
> >>
> >
> >
> > --
> > ***Thanks
> > Sanjay Kumar Maurya*
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
>
> --
> .
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Please help me(Combo box)

[XLS S]

Hey Sanjay

Try to use Indirect Functionplease find the attachment



On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya  wrote:
> Dear Frd
>
> Thanks for your reply and solution but I have more data so pivot table
> is not possible for it. if u have any easy format please tell me.
>
> Thanks
> Sanjay Kumar Maurya
>
> On 8/3/11, sreejith k.s  wrote:
>> hi Sanjay,
>>
>> just see whether this helps...i created a pivot according to my
>> understanding of the quwestion...just get back to me if it is not enough
>>
>> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
>> wrote:
>>
>>> Hi frds
>>>
>>> Please help me.
>>>
>>> --
>>> ***Thanks
>>> Sanjay Kumar Maurya*
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

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

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


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

Re: $$Excel-Macros$$ Please help me(Combo box)

[Sanjay Maurya]

Dear Frd

Thanks for your reply and solution but I have more data so pivot table
is not possible for it. if u have any easy format please tell me.

Thanks
Sanjay Kumar Maurya

On 8/3/11, sreejith k.s  wrote:
> hi Sanjay,
>
> just see whether this helps...i created a pivot according to my
> understanding of the quwestion...just get back to me if it is not enough
>
> On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya
> wrote:
>
>> Hi frds
>>
>> Please help me.
>>
>> --
>> ***Thanks
>> Sanjay Kumar Maurya*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
***Thanks
Sanjay Kumar Maurya*

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

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

Re: $$Excel-Macros$$ Please help me(Combo box)

[Rupesh Shrivastava]

Hi,
Please find the attached sheet with solution.

Thanks
Rupesh Kr.

On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:

> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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


Copy of problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help me(Combo box)

[sreejith k.s]

hi Sanjay,

just see whether this helps...i created a pivot according to my
understanding of the quwestion...just get back to me if it is not enough

On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:

> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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


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

Re: $$Excel-Macros$$ Please help me(Combo box)

[ashish koul]

see if it helps

On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote:

> Hi frds
>
> Please help me.
>
> --
> ***Thanks
> Sanjay Kumar Maurya*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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


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

$$Excel-Macros$$ Please help me(Combo box)

[Sanjay Maurya]

Hi frds

Please help me.

-- 
***Thanks
Sanjay Kumar Maurya*

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

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


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

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

[Sixthsense]

Hi Sukumar,

I am not sure whether this is what you are looking for.. Have a look in the
attached file whether it suits your requirement.

---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*


On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote:

> Hi,
>
> Students English maths sceience   Grades
> suresha 45 80 90 90-100 A
> srinivas 25 36 60 80-90  b
> sunyana 38 65 70   60-80c
> sunitha 80 90 68 36-60  d
> vinay 40 28 60  0-35  fail
> Need to slove using multiple ifs (please give some more examples like this)
>
> pls see the attached file
>
>
>
> Thanks in advance
>
>
> sukumar
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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


Solution File - Student Mark.xls
Description: MS-Excel spreadsheet

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

[mohd saber]

hi sukumar,

please find attached.

regards,
saber

On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote:

> Hi,
>
> Students English maths sceience   Grades
> suresha 45 80 90 90-100 A
> srinivas 25 36 60 80-90  b
> sunyana 38 65 70   60-80c
> sunitha 80 90 68 36-60  d
> vinay 40 28 60  0-35  fail
> Need to slove using multiple ifs (please give some more examples like this)
>
> pls see the attached file
>
>
>
> Thanks in advance
>
>
> sukumar
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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


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

$$Excel-Macros$$ please help me Urgent

[vijayajith VA]

Hi,

Students English maths sceience   Grades
suresha 45 80 90 90-100 A
srinivas 25 36 60 80-90  b
sunyana 38 65 70   60-80c
sunitha 80 90 68 36-60  d
vinay 40 28 60  0-35  fail
Need to slove using multiple ifs (please give some more examples like this)

pls see the attached file



Thanks in advance


sukumar

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

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


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

$$Excel-Macros$$ please help me

[Satish Bandaru]

hi experts

please help me to get my requirements to maintain my drugdata.please find
the attachment.if it possible in excel please helpme.

thanx in advance.

regards
jasmin

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

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


drugdata.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please help me

[Anubhav Somani]

Dear Sudhir,

Just would like to mention that the cells should be in date format, only
then this function will work.

Regards,
Anubhav

On Wed, Jan 19, 2011 at 2:59 PM, Manoj kumar  wrote:

> use either of them :-
>
>  =(B1-A1)+1
>  =DATEDIF(A1,B1,"d")+1
>
>
> Regards,
> Manoj Kumar
>
>
> On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar wrote:
>
>> Hi
>>
>> All Dear members
>>
>> Plz help on the following point.
>>
>> I want count no. of Days between two Dates.
>>
>> Example
>>
>> 1-12-10   31-12-1031
>>
>> thanx
>>
>>
>> --
>> Sudhir Verma
>> Asstt. Mngr. A/c's
>> 9818479722
>> *
>> P think Before you print
>> *
>> *
>> **
>> Life is Very beautiful !!!
>> *
>> *
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>>  `•.¸.•´.
>> *
>> *
>>  *
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Please help me

[Manoj kumar]

use either of them :-

 =(B1-A1)+1
 =DATEDIF(A1,B1,"d")+1


Regards,
Manoj Kumar

On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar  wrote:

> Hi
>
> All Dear members
>
> Plz help on the following point.
>
> I want count no. of Days between two Dates.
>
> Example
>
> 1-12-10   31-12-1031
>
> thanx
>
>
> --
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9818479722
> *
> P think Before you print
> *
> *
> **
> Life is Very beautiful !!!
> *
> *
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
>  `•.¸.•´.
> *
> *
>  *
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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


GG- Total number of days between two dates.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help me

[lucky singh]

Hi Sudhir,

PFA...

Regards,
Lucky

On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar  wrote:

> Hi
>
> All Dear members
>
> Plz help on the following point.
>
> I want count no. of Days between two Dates.
>
> Example
>
> 1-12-10   31-12-1031
>
> thanx
>
>
> --
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9818479722
> *
> P think Before you print
> *
> *
> **
> Life is Very beautiful !!!
> *
> *
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
>  `•.¸.•´.
> *
> *
> *
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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


number of days.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Please help me

[sudhir kumar]

Hi

All Dear members

Plz help on the following point.

I want count no. of Days between two Dates.

Example

1-12-10   31-12-1031

thanx


-- 
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before you print
*
*
**
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
 `•.¸.•´.
*
*
*

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

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

Re: $$Excel-Macros$$ Please Help me its urgent//Not able to apply count if function in Attached sheet.

[Born to Win]

Thanks for ur support sumit.

Thanks,
Chandrabhan Singh



On Tue, May 11, 2010 at 7:19 PM, sumit kumar  wrote:

> Dear Chandra
>
> here is the attached sheet probably you were looking for.
>
> Sumit
>
> On Tue, May 11, 2010 at 2:54 PM, Born to Win  wrote:
>
>> Hi All,
>>
>> Please Help me its urgent.
>>
>> Thanks,
>> Chandrabhan Singh
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

Re: $$Excel-Macros$$ Please help me

[sidhantha suchit]

can any one help me out i m waiting for your response ..otherwise i have to
apply these thing in all thousand company and its a time taking

On Wed, May 5, 2010 at 9:57 AM, Vikas Chouhan  wrote:

> Harry..
>
>
> 2003 format
>
>
> On Tue, May 4, 2010 at 10:11 AM, Harpreet Singh Gujral <
> harpreetguj...@gmail.com> wrote:
>
>> Sidhantha,
>>
>> Is it possible for you to provide Excel 2003 version
>>
>> Harry
>>
>> On May 3, 4:33 pm, sidhantha suchit  wrote:
>> > hi
>> >
>> > attach one of the sheet and thereis 1000 of such kind of sheet were i
>> have
>> > to do this wrk please help me.
>> > On Mon, May 3, 2010 at 9:36 AM, Rahul Gandhi. > >wrote:
>> >
>> >
>> >
>> >
>> >
>> > > Can you please give me the example so that we can atleast try to help
>> > > you out with query.
>> >
>> > > On May 2, 6:58 pm, sidhantha suchit  wrote:
>> > > > hi
>> >
>> > > > sir
>> >
>> > > > I m new to this group right now i m doing a project on stock market
>> and i
>> > > > have to do lot of calculation ,I know its my duty but can if any one
>> help
>> > > me
>> > > > its reduce my task because i have to apply in 1000 BSE listed
>> company .
>> >
>> > > > what i have to calculate
>> >
>> > > > Volatility (daily)
>> > > > Jump in script
>> > > > Mean
>> > > > Return with sensex
>> > > > co relation
>> >
>> > > > I download all the data of 1000 company for 248 days trading .
>> >
>> > > > please if any one help me
>> > > > --
>> > > > Sidhantha Suchit
>> > > > (248592)
>> > > > BBM
>> > > > “Dream the impossible dream, Fight the unbeatable foe, Strive with
>> your
>> > > last
>> > > > once of courage To reach the unreachable star.”
>> >
>> > > > --
>> >
>> > >
>> ---­---
>> > > > Some important links for excel users:
>> > > > 1. Follow us on TWITTER for tips tricks and links :
>> > >http://twitter.com/exceldailytip
>> > > > 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>> >
>> > > > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > > > <><><><><><><><><><><><><><><><><><><><><><>
>> > > > HELP US GROW !!
>> >
>> > > > We reach over 6,800 subscribers worldwide and receive many nice
>> notes
>> > > about the learning and support from the group.Let friends and
>> co-workers
>> > > know they can subscribe to group athttp://
>> > > groups.google.com/group/excel-macros/subscribe
>> >
>> > > --
>> >
>> > >
>> ---­---
>> > > Some important links for excel users:
>> > > 1. Follow us on TWITTER for tips tricks and links :
>> > >http://twitter.com/exceldailytip
>> > > 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>> >
>> > > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > > <><><><><><><><><><><><><><><><><><><><><><>
>> > > HELP US GROW !!
>> >
>> > > We reach over 6,800 subscribers worldwide and receive many nice notes
>> about
>> > > the learning and support from the group.Let friends and co-workers
>> know they
>> > > can subscribe to group at
>> > >http://groups.google.com/group/excel-macros/subscribe
>> >
>> > --
>> > Sidhantha Suchit
>> > (248592)
>> > BBM,MBF
>> > “Dream the impossible dream, Fight the unbeatable foe, Strive with your
>> last
>> > once of courage To reach the unreachable star.”
>> >
>> > --
>> >
>> ---­---
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > HELP US GROW !!
>> >
>> > We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group athttp://
>> groups.google.com/group/excel-macros/subscribe
>> >
>> >  52.xlsx
>> > 71KViewDownload- Hide quoted text -
>> >
>> > - Show quoted text -
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> h

Re: $$Excel-Macros$$ Please help me

[Harpreet Singh Gujral]

Sidhantha,

Is it possible for you to provide Excel 2003 version

Harry

On May 3, 4:33 pm, sidhantha suchit  wrote:
> hi
>
> attach one of the sheet and thereis 1000 of such kind of sheet were i have
> to do this wrk please help me.
> On Mon, May 3, 2010 at 9:36 AM, Rahul Gandhi. wrote:
>
>
>
>
>
> > Can you please give me the example so that we can atleast try to help
> > you out with query.
>
> > On May 2, 6:58 pm, sidhantha suchit  wrote:
> > > hi
>
> > > sir
>
> > > I m new to this group right now i m doing a project on stock market and i
> > > have to do lot of calculation ,I know its my duty but can if any one help
> > me
> > > its reduce my task because i have to apply in 1000 BSE listed company .
>
> > > what i have to calculate
>
> > > Volatility (daily)
> > > Jump in script
> > > Mean
> > > Return with sensex
> > > co relation
>
> > > I download all the data of 1000 company for 248 days trading .
>
> > > please if any one help me
> > > --
> > > Sidhantha Suchit
> > > (248592)
> > > BBM
> > > “Dream the impossible dream, Fight the unbeatable foe, Strive with your
> > last
> > > once of courage To reach the unreachable star.”
>
> > > --
>
> > ---­---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > > To post to this group, send email to excel-macros@googlegroups.com
>
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > HELP US GROW !!
>
> > > We reach over 6,800 subscribers worldwide and receive many nice notes
> > about the learning and support from the group.Let friends and co-workers
> > know they can subscribe to group athttp://
> > groups.google.com/group/excel-macros/subscribe
>
> > --
>
> > ---­---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,800 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
> --
> Sidhantha Suchit
> (248592)
> BBM,MBF
> “Dream the impossible dream, Fight the unbeatable foe, Strive with your last
> once of courage To reach the unreachable star.”
>
> --
> ---­---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe
>
>  52.xlsx
> 71KViewDownload- Hide quoted text -
>
> - Show quoted text -

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

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

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

Re: $$Excel-Macros$$ Please help me

[Rahul Gandhi.]

Can you please give me the example so that we can atleast try to help
you out with query.

On May 2, 6:58 pm, sidhantha suchit  wrote:
> hi
>
> sir
>
> I m new to this group right now i m doing a project on stock market and i
> have to do lot of calculation ,I know its my duty but can if any one help me
> its reduce my task because i have to apply in 1000 BSE listed company .
>
> what i have to calculate
>
> Volatility (daily)
> Jump in script
> Mean
> Return with sensex
> co relation
>
> I download all the data of 1000 company for 248 days trading .
>
> please if any one help me
> --
> Sidhantha Suchit
> (248592)
> BBM
> “Dream the impossible dream, Fight the unbeatable foe, Strive with your last
> once of courage To reach the unreachable star.”
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe

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

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

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

Re: $$Excel-Macros$$ Please help me

[Rahul Gandhi.]

Can you please give me the example so that we can atleast try to help
you out with query.

On May 2, 6:58 pm, sidhantha suchit  wrote:
> hi
>
> sir
>
> I m new to this group right now i m doing a project on stock market and i
> have to do lot of calculation ,I know its my duty but can if any one help me
> its reduce my task because i have to apply in 1000 BSE listed company .
>
> what i have to calculate
>
> Volatility (daily)
> Jump in script
> Mean
> Return with sensex
> co relation
>
> I download all the data of 1000 company for 248 days trading .
>
> please if any one help me
> --
> Sidhantha Suchit
> (248592)
> BBM
> “Dream the impossible dream, Fight the unbeatable foe, Strive with your last
> once of courage To reach the unreachable star.”
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe

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

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

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

Re: $$Excel-Macros$$ Please help me

[Harpreet Singh Gujral]

Sidhantha,

I can give it a try, as i am also studying some things related to
Stock Market...
Let me know

Harry

On May 2, 6:58 pm, sidhantha suchit  wrote:
> hi
>
> sir
>
> I m new to this group right now i m doing a project on stock market and i
> have to do lot of calculation ,I know its my duty but can if any one help me
> its reduce my task because i have to apply in 1000 BSE listed company .
>
> what i have to calculate
>
> Volatility (daily)
> Jump in script
> Mean
> Return with sensex
> co relation
>
> I download all the data of 1000 company for 248 days trading .
>
> please if any one help me
> --
> Sidhantha Suchit
> (248592)
> BBM
> “Dream the impossible dream, Fight the unbeatable foe, Strive with your last
> once of courage To reach the unreachable star.”
>
> --
> ---­---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe

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

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

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

$$Excel-Macros$$ Please help me

[sidhantha suchit]

hi

sir

I m new to this group right now i m doing a project on stock market and i
have to do lot of calculation ,I know its my duty but can if any one help me
its reduce my task because i have to apply in 1000 BSE listed company .

what i have to calculate

Volatility (daily)
Jump in script
Mean
Return with sensex
co relation

I download all the data of 1000 company for 248 days trading .

please if any one help me
-- 
Sidhantha Suchit
(248592)
BBM
“Dream the impossible dream, Fight the unbeatable foe, Strive with your last
once of courage To reach the unreachable star.”

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

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

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

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

[Harpreet Singh Gujral]

Hi Sudhir,

Would it be possible for you to attach both the sheets, i will try to work
on it.

If possible, please specify which sheet would serve as the master against
which the other sheet will be compared.

Cheers!

Harry

On Tue, Apr 27, 2010 at 9:25 PM, sudhir kumar  wrote:

> Thanks Harpreetji, for your valuable solution
> I have an another problem,
>   I have two excel sheets, both are having same format, and
> contain huge
> amount of data.
> now i want to compare them, old one with the new one. and i want to
> find out which data is deleted, which one is added, and which one is
> changed. plz help me.
>
> Thanks.
>
> On Sun, Apr 25, 2010 at 9:58 AM, Harpreet Singh Gujral <
> harpreetguj...@gmail.com> wrote:
>
>> Hi Sudhir,
>>
>> I think you are looking for "How to group rows and columns?".
>>
>> Please find attached some information sourced from the net, i think this
>> will give you complete details about it.
>>
>> Cheers!
>>
>> Harry
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> Regards-
> Sudhir Kumar
> Design Engineer,
> Conceptia Software Technologies Pvt. Ltd.
> Email id-sudhir.p...@gmail.com,
>
>

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

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

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

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

[sudhir kumar]

Thanks Harpreetji, for your valuable solution
I have an another problem,
  I have two excel sheets, both are having same format, and
contain huge
amount of data.
now i want to compare them, old one with the new one. and i want to
find out which data is deleted, which one is added, and which one is
changed. plz help me.

Thanks.

On Sun, Apr 25, 2010 at 9:58 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:

> Hi Sudhir,
>
> I think you are looking for "How to group rows and columns?".
>
> Please find attached some information sourced from the net, i think this
> will give you complete details about it.
>
> Cheers!
>
> Harry
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



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

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

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

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

RE: $$Excel-Macros$$ please help me for Excel Conditional formula with example

[Dave Bonallack]

Huh?
 


Date: Mon, 26 Apr 2010 21:18:44 -0700
Subject: $$Excel-Macros$$ please help me for Excel Conditional formula with 
example
From: vikask...@gmail.com
To: excel-macros@googlegroups.com

Dear All,


Please help me for excel condition formula's, pls send formula with example 
...pls it's a urgent. 


One Team One Dream One Goal 

Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U" 

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.


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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
New, Used, Demo, Dealer or Private? Find it at CarPoint.com.au
http://clk.atdmt.com/NMN/go/206222968/direct/01/

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

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

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

$$Excel-Macros$$ please help me for Excel Conditional formula with example

[Vikas Chouhan]

Dear All,


Please help me for excel condition formula's, pls send formula with example
...pls it's a urgent.


One Team One Dream One Goal

Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

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

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

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

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

[sravani loly]

Hi Sudhir,
 
Try this,,,
hope u r talking abut grouping and ungrouping
 
    Rows("1:2").Select
    Selection.Rows.Group

--- On Sat, 24/4/10, sudhir  wrote:


From: sudhir 
Subject: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide 
the subheading in excel
To: "MS EXCEL AND VBA MACROS" 
Date: Saturday, 24 April, 2010, 8:53 AM


Dear friends,

I want a macro for hide and unhide the sub headings in excel, like we
can do in MS project with +mark, when we click on + symbol it
highlights the subtask available in that particular task.
Is it possible??., pleas help me

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

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

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

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


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

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

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

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

[sudhir kumar]

hi harpreet ji ,
thank u very much , thats the thing i want





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

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

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

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

$$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

[sudhir]

Dear friends,

I want a macro for hide and unhide the sub headings in excel, like we
can do in MS project with +mark, when we click on + symbol it
highlights the subtask available in that particular task.
Is it possible??., pleas help me

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

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

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

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

[Paul]

Decided to go to the GoogleGroups site so that I can see the whole
discussion thread.
I'll explain in detail.


To create a change event:
Right-click on the sheet "tab"and select "View Code"
At the top of the editor "code" window is a set of pull-downs.
In the left pull-down, select "WorkSheet".

It will create a default selection change event:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

in the Right-hand pull-down, select "change"
It will create a worksheet Change event, you can put your code there:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("b2").Value < Range("c1").Value Then
   Range("b2").Value = Range("c1").Value
End If
If Range("b3").Value > Range("d1").Value Then
   Range("b3").Value = Range("d1").Value
End If
End Sub

hope this helps

On Mar 5, 7:35 am, Paul Schreiner  wrote:
> You could:
> store initial values in a hidden cell.
> Create a change event for the worksheet
> that compares the cell contents to the hidden cells
> and update if the contents meet the criteria.
>
> (if a1 > H1 then H1 = a1)
> (if a2 < H2 then H2 = a2)
>
> let me know if you need help with the change events.
>
> Paul
>
> 
> From: Sach1810 
> To: MS EXCEL AND VBA MACROS 
> Sent: Fri, March 5, 2010 3:39:40 AM
> Subject: $$Excel-Macros$$ Please help me print a the highest number that 
> appears from a cell with continuously streaming data
>
> Hi,
>
> I have two cells lets say a1 and a2 both of which are continually
> updating from a live feed.  I would like to be able to track what the
> highest number of a1 has been and what the lowest number of cell a2
> has been.
>
> Your help would be much appreciated as I am new to programming
>
> Many Thanks
>
> Sacha David
>
> --
> ---­---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our Facebook Group @http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe

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

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

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

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

[Paul Schreiner]

You could:
store initial values in a hidden cell.
Create a change event for the worksheet 
that compares the cell contents to the hidden cells
and update if the contents meet the criteria.

(if a1 > H1 then H1 = a1)
(if a2 < H2 then H2 = a2)

let me know if you need help with the change events.

Paul




From: Sach1810 
To: MS EXCEL AND VBA MACROS 
Sent: Fri, March 5, 2010 3:39:40 AM
Subject: $$Excel-Macros$$ Please help me print a the highest number that 
appears from a cell with continuously streaming data

Hi,

I have two cells lets say a1 and a2 both of which are continually
updating from a live feed.  I would like to be able to track what the
highest number of a1 has been and what the lowest number of cell a2
has been.

Your help would be much appreciated as I am new to programming

Many Thanks

Sacha David

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

[rf1234 rf1234]

Hello Dear
Have you Tried MAX()

Please let me know,if more help required.


Hope it will Help
Happy To Help
:)
Shyam



On Fri, Mar 5, 2010 at 2:09 PM, Sach1810  wrote:

> Hi,
>
> I have two cells lets say a1 and a2 both of which are continually
> updating from a live feed.  I would like to be able to track what the
> highest number of a1 has been and what the lowest number of cell a2
> has been.
>
> Your help would be much appreciated as I am new to programming
>
> Many Thanks
>
> Sacha David
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

[Abhishek Jain]

Can you send an example file ? That would help to understand better.

Thanks,

On Fri, Mar 5, 2010 at 2:09 PM, Sach1810  wrote:

> Hi,
>
> I have two cells lets say a1 and a2 both of which are continually
> updating from a live feed.  I would like to be able to track what the
> highest number of a1 has been and what the lowest number of cell a2
> has been.
>
> Your help would be much appreciated as I am new to programming
>
> Many Thanks
>
> Sacha David
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

$$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

[Sach1810]

Hi,

I have two cells lets say a1 and a2 both of which are continually
updating from a live feed.  I would like to be able to track what the
highest number of a1 has been and what the lowest number of cell a2
has been.

Your help would be much appreciated as I am new to programming

Many Thanks

Sacha David

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

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

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

Re: $$Excel-Macros$$ Please help me fourmula

[ankur]

hi Subhash

where is file ?

On 01/02/2010, Dilip Pandey  wrote:
> Hi Subhash,
>
> You have forgot to attach the files.  Please attach the file and explain
> your query as well.  Thanks.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B Com(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>
> On Mon, Feb 1, 2010 at 4:15 PM, subhash tambe
> wrote:
>
>> Dear All,
>>
>>
>> please give me count  fourmula  in thes sheet
>>
>> --
>>   Subhash
>> Pratham Mumbai Education Initiative
>>
>> 9870914252
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about
>> the learning and support from the group.Let friends and co-workers know
>> they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>


-- 
Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~

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

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

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

Re: $$Excel-Macros$$ Please help me fourmula

[Dilip Pandey]

Hi Subhash,

You have forgot to attach the files.  Please attach the file and explain
your query as well.  Thanks.

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


On Mon, Feb 1, 2010 at 4:15 PM, subhash tambe wrote:

> Dear All,
>
>
> please give me count  fourmula  in thes sheet
>
> --
>   Subhash
> Pratham Mumbai Education Initiative
>
> 9870914252
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

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

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

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

$$Excel-Macros$$ Please help me fourmula

[subhash tambe]

Dear All,


please give me count  fourmula  in thes sheet

-- 
  Subhash
Pratham Mumbai Education Initiative

9870914252

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

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

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

$$Excel-Macros$$ Please Help Me !!!!!!!!

[amresh kumar]

Dear Freinds,

please help me 


i have a workbook in word there are many pages in  workbook but i want Separate
workbook for every pages.

Regards
Amresh

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

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

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

$$Excel-Macros$$ Please Help Me!!!

[jonell]

On Mon, Aug 10, 2009 at 12:07 PM, Sandeep http://groups.google.com/groups/unlock?hl=en&_done=/group/e
xcel-macros/browse_thread/thread/2c83a1e4f9fe5b55%3Fhl%3Den&
msg=3b640b5678417efb> @gmail.com> wrote: 
>  I Need to calculate the range as per the criteria
mentioned in attached 
> file please help me. 
 
Hi Sandeep,
 
I don't think you can do what you want without a VBA macro.
You can hide the column with the values you want to rank, if
you only want to show the
total of marks, like in my solution attached.
I have not used array formulas to calculate the "loaded"
marks values and I have put some
comments in red text for your consideration.
 
Hope this helps.
 
Regards,
Jonell

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

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

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



Anil+jonell.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Please Help Me!!!

[Sandeep]

I Need to calculate the range as per the criteria mentioned in attached file 
please help me.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

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

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



Anil.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Please help me to solve this problem

[Swapnil Palande]

Hi All,

I want to do conditional formatting on selected cells based on values
inserted in other cells.

I have explained the problem in attached excel. If you still have any query
let me know I will try to explain it again.

Thanks and Best regards,

Swapnil.

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

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

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



Book3.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Please help me to solve the problm

[shijomon joseph]

Dear Friends,

I am looking for the use of “vlookup” function for getting the below
criteria

· To find the description & details from the database if I enter the
Iem code on the working sheet.

· Also cross check the location, because same item code has
different description according to different areas.

For example

Location   Item code   Description Details

Area 1   05.01 Excavation  1.5-2.0
mtr depth.

Area 4   05.01 Excavation  2.0-2.5
mtr depth.

Area 1   06.02 Backfilling
   1.5-2.0
mtr depth.

Area 4   06.02 sand filling
   2.0-2.5
mtr depth.

Please help me to solve this problem.

Thanks in advance

Best regards

shijo

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

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

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

$$Excel-Macros$$ please help me with count function !!!URGENT!!!

[shay shay]

please help me with count function
-- 
Shay

A Thinker tends to use reason and logic

A feeler tends to use values and subjective Judgement.

Be a Thinker in Life.

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit & Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---



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

$$Excel-Macros$$ Please Help me

[Ajay Kumar]

I cannot use hyperlink in my pc, when I try to click the link computer
showing the following message.

*"the operation has been canceled due to restriction in effect on this
computer, Please contact your system administrator"*

I'm working on administrative mode. Please help me.


-- 
aJaY :) (R)™

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit & Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~--~~~~--~~--~--~---