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

[Rajesh kumar]

Hi ,

Please Check. I have attached excel.

On Saturday, 6 October 2018 14:27:11 UTC+5:30, rajeyssh wrote:
>
> Dear Sir
> Formula required as per the attachment in sheet "2".
> Thanks in advance for your help.
>
> Regards
>
> -- 
> *Rajesh Kumar Agarwal*
> *9811063001*
>

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


formula required query.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ If formula Required

[amar takale]

Dear Paul Sir

Please accept my apologies (G10 & G11 Cell). I had made an error on my part
in accidentally.And Overall formula is perfect as per mind.And this is
sumif formula & put in subject If formula also apologies for that.
Thanks again.

Regards
Amar


On Wed, Feb 24, 2016 at 7:29 PM, Paul Schreiner 
wrote:

> You keep mentioning an "IF" formula, but I don't see one.
> I'm not sure what "test" you're expecting for an "if" formula.
> It looks like you're trying to simply add the values in the two columns (C
> and D)
> for each of the values in column B.
>
> This can be done with the Sumif() function.
>
> See attached.
>
> although, you have values in rows 10 and 11 for product "AAA".
> Your output seems to expect a value of 40.
> But I only see one previous entry of 20.00.
>
> All the other calculations match your expectation, so I'm not sure where
> the error lies.
>
>
> *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*
> -
>
>
> On Wednesday, February 24, 2016 4:46 AM, amar takale 
> wrote:
>
>
>
> Dear Paul Sir thanks very much for this, but if there are another (column
> criteria) add in formula then how to modified IF formula?.
> Pls check sheet for sample
> Regrads
> Amar
>
> On Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner 
> wrote:
>
> In cell G4, enter formula:
> =SUMIF(C$4:C4,F4,D$4:D4)
> and copy the formula down through column G.
>
> The "$" means that the beginning row of the range is "anchored"
> which means that the first row of each range is 4,
> but the ending row of each range will increment to match the "current" row.
> *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*
> -
>
>
> On Tuesday, February 23, 2016 8:30 AM, amar takale 
> wrote:
>
>
>
>
> --
> 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 

Re: $$Excel-Macros$$ If formula Required

[Paul Schreiner]

You keep mentioning an "IF" formula, but I don't see one.I'm not sure what 
"test" you're expecting for an "if" formula.It looks like you're trying to 
simply add the values in the two columns (C and D)for each of the values in 
column B.
This can be done with the Sumif() function.
See attached.
although, you have values in rows 10 and 11 for product "AAA".Your output seems 
to expect a value of 40.But I only see one previous entry of 20.00.
All the other calculations match your expectation, so I'm not sure where the 
error lies.
 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
- 

On Wednesday, February 24, 2016 4:46 AM, amar takale  
wrote:
 
 

 Dear Paul Sir thanks very much for this, but if there are another (column 
criteria) add in formula then how to modified IF formula?.
Pls check sheet for sample
Regrads
Amar

On Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner  wrote:

In cell G4, enter formula:=SUMIF(C$4:C4,F4,D$4:D4)and copy the formula down 
through column G.
The "$" means that the beginning row of the range is "anchored" which means 
that the first row of each range is 4,but the ending row of each range will 
increment to match the "current" 
row.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
- 

On Tuesday, February 23, 2016 8:30 AM, amar takale  
wrote:
 
 

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

Re: $$Excel-Macros$$ If formula Required

[amar takale]

Dear Paul Sir thanks very much for this, but if there are another (column
criteria) add in formula then how to modified IF formula?.
Pls check sheet for sample
Regrads
Amar

On Tue, Feb 23, 2016 at 10:41 PM, Paul Schreiner 
wrote:

> In cell G4, enter formula:
> =SUMIF(C$4:C4,F4,D$4:D4)
> and copy the formula down through column G.
>
> The "$" means that the beginning row of the range is "anchored"
> which means that the first row of each range is 4,
> but the ending row of each range will increment to match the "current" row.
> *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*
> -
>
>
> On Tuesday, February 23, 2016 8:30 AM, amar takale 
> wrote:
>
>
>
>
> --
> 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.


Sample.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ If formula Required

[Paul Schreiner]

In cell G4, enter formula:=SUMIF(C$4:C4,F4,D$4:D4)and copy the formula down 
through column G.
The "$" means that the beginning row of the range is "anchored" which means 
that the first row of each range is 4,but the ending row of each range will 
increment to match the "current" 
row.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
- 

On Tuesday, February 23, 2016 8:30 AM, amar takale  
wrote:
 
 

 
-- 
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$$ If formula Required

[amar takale]

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


If formula.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: FORMULA REQUIRED

[GENIUS]

Thank you Mr Paul that's really great

On Saturday, 24 October 2015 17:07:35 UTC+5, GENIUS wrote:
>
> Thanks for your reply, but let me clear as you may see if we put more data 
> in the rows we may have the sum of all the rows at one place, look at the 
> sheet, but i need only row wise sum not the sum of the different rows at 
> one place i.e. if we sum row three in J3 and K3, the sum must be of row 3 
> only not the others. 
>
> On Friday, 23 October 2015 20:38:38 UTC+5, GENIUS wrote:
>>
>>
>> As you may see I have already used different cell reference for summing 
>> up the UNIT and COST  but I need a formula from which when I type and take 
>> the reference of all the cell i.e. A3:H3 under the heading of UNIT and same 
>> under the heading of COST, there must be a sum of the respective field in 
>> the respective heading,  not the whole I know about the subtotal but I 
>> think subtotal cannot be used over here, if yes then how can I used 
>> subtotal or some other formula.
>> Thanks in advance
>> -- 
>> *Izhar Ul Haq*
>>
>>
>>
>> Cell# 009203069072597
>>
>

-- 
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$$ Re: FORMULA REQUIRED

[Paul Schreiner]

I think I see your issue.Your example has (4) products (Product A, B, C, D)Your 
formula "manually" adds the Unit volumes for eachand the costs for each.
But if you have more Products, this calculation becomes harder to manage.
You want a sum of the Unit volume of ALL products, not EACH product.
In cell J3, I would use:
=SUMIF($A$2:I$2,J$2,$A3:I3)
Copy it to Column K and down.
(see attached) 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: GENIUS <izharra...@gmail.com>
 To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> 
 Sent: Saturday, October 24, 2015 8:07 AM
 Subject: $$Excel-Macros$$ Re: FORMULA REQUIRED
   
Thanks for your reply, but let me clear as you may see if we put more data in 
the rows we may have the sum of all the rows at one place, look at the sheet, 
but i need only row wise sum not the sum of the different rows at one place 
i.e. if we sum row three in J3 and K3, the sum must be of row 3 only not the 
others. 

On Friday, 23 October 2015 20:38:38 UTC+5, GENIUS wrote:

As you may see I have already used different cell reference for summing up the 
UNIT and COST  but I need a formula from which when I type and take the 
reference of all the cell i.e. A3:H3 under the heading of UNIT and same under 
the heading of COST, there must be a sum of the respective field in the 
respective heading,  not the whole I know about the subtotal but I think 
subtotal cannot be used over here, if yes then how can I used subtotal or some 
other formula.
Thanks in advance
-- 
Izhar Ul Haq



Cell# 009203069072597

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


Book1.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: FORMULA REQUIRED

[GENIUS]

Thanks for your reply, but let me clear as you may see if we put more data 
in the rows we may have the sum of all the rows at one place, look at the 
sheet, but i need only row wise sum not the sum of the different rows at 
one place i.e. if we sum row three in J3 and K3, the sum must be of row 3 
only not the others. 

On Friday, 23 October 2015 20:38:38 UTC+5, GENIUS wrote:
>
>
> As you may see I have already used different cell reference for summing up 
> the UNIT and COST  but I need a formula from which when I type and take the 
> reference of all the cell i.e. A3:H3 under the heading of UNIT and same 
> under the heading of COST, there must be a sum of the respective field in 
> the respective heading,  not the whole I know about the subtotal but I 
> think subtotal cannot be used over here, if yes then how can I used 
> subtotal or some other formula.
> Thanks in advance
> -- 
> *Izhar Ul Haq*
>
>
>
> Cell# 009203069072597
>

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


Book1.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: formula required in column D E

[mpatram]

Did not understand your requirement. also, FYI, I can not see anything in 
this attachemnt.

On Tuesday, April 21, 2015 at 11:03:22 PM UTC+5:30, rajeyssh wrote:

 Hello Sir
 formula required in both the column matching.

 -- 
 *Rajesh Kumar Agarwal*
 *9811063001*
  

-- 
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$$ Re: formula required in column c excluding Zero

[Chandan Bisht]

Hi

i think your are looking for this..file also attached

=IFERROR(SMALL($B$2:$B$375,COUNTIF($B$2:$B$375,=0)+ROW(A1)),)

Thankx  Rgds,

Chandra Singh Bisht



On Wed, Apr 22, 2015 at 10:11 AM, Rajesh Agarwal rajey...@gmail.com wrote:

 Sorry. now find the attachment.

 On Tue, Apr 21, 2015 at 10:53 PM, Rajesh Agarwal rajey...@gmail.com
 wrote:

 Hello Sir
 formula required

 --
 *Rajesh Kumar Agarwal*
 *9811063001*




 --
 *Rajesh Kumar Agarwal*
 *9811063001*

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


low excluding 0.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: formula required in column c excluding Zero

[Rajesh Agarwal]

Sorry. now find the attachment.

On Tue, Apr 21, 2015 at 10:53 PM, Rajesh Agarwal rajey...@gmail.com wrote:

 Hello Sir
 formula required

 --
 *Rajesh Kumar Agarwal*
 *9811063001*




-- 
*Rajesh Kumar Agarwal*
*9811063001*

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


low excluding 0.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: formula required in column c excluding Zero

[Ashish Kumar]

Elaborate more!!



Regards
Ashish

-- 
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$$ Fwd: formula required in both the sheets

[Swapnil Palande]

Hi Rajesh,

It is not cleare what exactly you want. Please explain more with expected
results.

Regards,

Swapnil.

On Fri, Apr 17, 2015 at 10:05 AM, Rajesh Agarwal rajey...@gmail.com wrote:

 Dear Sir
 Formula required in both the sheets as per mentioned in sheet 1.

 --
 *Rajesh Kumar Agarwal*
 *9811063001*

  --
 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$$ Fwd: formula required in both the sheets

[Rajesh Agarwal]

Dear Sir
Formula required in both the sheets as per mentioned in sheet 1.

-- 
*Rajesh Kumar Agarwal*
*9811063001*

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


required formula in sheet 1n2.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Look formula required

[Rajesh thrissur]

Hi Experts
please check the attached table , there i have to select a value from one
table to another based on the criteria given. pls help me

Regards
Rajesh

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


PT.xlsx
Description: MS-Excel 2007 spreadsheet

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

[Vaibhav Joshi]

Hi

You can use simple vlookup formula, but you need to reverse the table,
check attachment  formula is in col G.

Cheers!!

On Fri, Mar 27, 2015 at 11:41 AM, Rajesh thrissur 
rajeshkainikk...@gmail.com wrote:

 Hi Experts
 please check the attached table , there i have to select a value from one
 table to another based on the criteria given. pls help me

 Regards
 Rajesh

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


PT.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ combined formula required.

[xlstime]

still not clear

what is a exact condition for RED,BLUE and yellow

for example

5000-5500 RED
5500-600 GREEN




.

Enjoy
Team XLS



On Sun, Sep 8, 2013 at 5:30 PM, Kenil Gala keni...@yahoo.com wrote:

 Hope this helps,

 Thanks in Adv.

   --
  *From:* xlstime xlst...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Sunday, September 8, 2013 3:47 PM
 *Subject:* Re: $$Excel-Macros$$ combined formula required.

 can u please share full condition

 .

 Enjoy
 Team XLS

 On Sun, Sep 8, 2013 at 1:48 PM, Kenil Gala keni...@yahoo.com wrote:

 Hi group,

 I want a combination of IF and AND formula, or any other other
 suitable formula for inserting some indicators between fixed set of values.

 Pls find the file attached.

 Thanks  Regards,
 --

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

 FORUM RULES

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

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


-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ combined formula required.

[Kenil Gala]

I have explained it from start again,
Hope if i have explain it properly this time.

Thanks in Adv.


 From: xlstime xlst...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Monday, September 9, 2013 10:38 AM
Subject: Re: $$Excel-Macros$$ combined formula required.
 


still not clear


what is a exact condition for RED,BLUE and yellow 


for example 


5000-5500 RED

5500-600 GREEN






.

Enjoy
Team XLS




On Sun, Sep 8, 2013 at 5:30 PM, Kenil Gala keni...@yahoo.com wrote:

Hope this helps,


Thanks in Adv.




 From: xlstime xlst...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Sunday, September 8, 2013 3:47 PM
Subject: Re: $$Excel-Macros$$ combined formula required.
 


can u please share full condition 


.

Enjoy
Team XLS


On Sun, Sep 8, 2013 at 1:48 PM, Kenil Gala keni...@yahoo.com wrote:

Hi group,


I want a combination of IF and AND formula, or any other other suitable 
formula for inserting some indicators between fixed set of values.


Pls find the file attached.


Thanks  Regards,
-- 

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


-- 
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/groups/opt_out.

-- 
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/groups/opt_out.


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

$$Excel-Macros$$ combined formula required.

[Kenil Gala]

Hi group,

I want a combination of IF and AND formula, or any other other suitable 
formula for inserting some indicators between fixed set of values.

Pls find the file attached.

Thanks  Regards,

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

FORUM RULES

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

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


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

Re: $$Excel-Macros$$ combined formula required.

[xlstime]

can u please share full condition



.

Enjoy
Team XLS



On Sun, Sep 8, 2013 at 1:48 PM, Kenil Gala keni...@yahoo.com wrote:

 Hi group,

 I want a combination of IF and AND formula, or any other other
 suitable formula for inserting some indicators between fixed set of values.

 Pls find the file attached.

 Thanks  Regards,

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

 FORUM RULES

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

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


-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ combined formula required.

[Kenil Gala]

Hope this helps,

Thanks in Adv.



 From: xlstime xlst...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Sunday, September 8, 2013 3:47 PM
Subject: Re: $$Excel-Macros$$ combined formula required.
 


can u please share full condition 

.

Enjoy
Team XLS


On Sun, Sep 8, 2013 at 1:48 PM, Kenil Gala keni...@yahoo.com wrote:

Hi group,


I want a combination of IF and AND formula, or any other other suitable 
formula for inserting some indicators between fixed set of values.


Pls find the file attached.


Thanks  Regards,
-- 


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

FORUM RULES

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

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


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

$$Excel-Macros$$ Re: formula required to update values form one sheet to another sheet with date criteria

[Probyn Cope]

Not clear what you are trying to do but if your master sheet has different 
names and you are trying to sum for your report sheet try the following:
 
=SUMIF(MASTER!$B$5:$B$35,Raman Choudary,MASTER!C5:C35)
 
That goes into B9 of your report sheet. You can then copy across. If B10 is 
a different name copy the above formula to B10 and change the Raman 
Choudary to that name. Hope this is of some help.
 
Regards.
 

On Friday, July 19, 2013 12:50:57 AM UTC-4, excel lerner wrote:

 Hi Experts

 Good morning Every Body.

 I have Two sheets in excel 2003 file.One is master sheet and 2nd one 
 reprot sheet.

 daily i have to send report to HO.I enter values in master sheet date wise.
 In report sheet if i select or enter date data to be update from master 
 sheet with name.only one name will be in master sheet.
 Please help me any formula?
 i am attaching. test file.

 Thanks in advance


-- 
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/groups/opt_out.

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

[Anil Kumar]

 From: amar takale amartak...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Tuesday, 4 September 2012 2:01 PM
Subject: $$Excel-Macros$$ Simple formula required
 



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

-- 
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/groups/opt_out.




Copy of Formula Required.xls
Description: MS-Excel spreadsheet

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

[Prafull Jadhav]

Dear Amar,

find the same with easy...by using mid function.
Regards
Prafull

On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar kumarmaury...@yahoo.com wrote:


   --
  *From:* amar takale amartak...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Tuesday, 4 September 2012 2:01 PM
 *Subject:* $$Excel-Macros$$ Simple formula required


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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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




   --
 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/groups/opt_out.




-- 
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/groups/opt_out.




Formula Required_.xls
Description: MS-Excel spreadsheet

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

[ashish koul]

=TRIM(RIGHT(D3,LEN(D3)-FIND(),D3)))


Regards
Ashish Koul


On Wed, Jul 10, 2013 at 4:20 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:

 Dear Amar,

 find the same with easy...by using mid function.
 Regards
 Prafull


 On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar kumarmaury...@yahoo.comwrote:


   --
  *From:* amar takale amartak...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Tuesday, 4 September 2012 2:01 PM
 *Subject:* $$Excel-Macros$$ Simple formula required


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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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




   --
 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/groups/opt_out.




  --
 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/groups/opt_out.






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on 
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/


P Before printing, think about the environment.

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

$$Excel-Macros$$ Re: formula required

[Prince]

Hi Ganesh,

PFA.

Regards
Prince

On Sunday, February 10, 2013 8:50:17 AM UTC+5:30, GANESH wrote:

  Hi   I want the J8 show me the total of rim of which I highilighted in 
 Green color  all the user in Column E   
  Column B has user Name  Column c has the total of amount 
 Please find the attached file.

 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 javascript:.
 To post to this group, send email to excel-...@googlegroups.comjavascript:
 .
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out. 

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




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

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

[viking4u]

Hi prince 


Will you please help me. 
I have three different excel file and each excel file have three different wrk 
sheet. I need to link or copy  all data in one excel file from these different 
wrk sheet. How do I do this.  

In advance thnks for help.  
Sent from my BlackBerry® Smartphone on Loop Mobile.

-Original Message-
From: Prince prince141...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 13 Jan 2013 23:02:48 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: formula required

Hi Prashant,

I hope it may help you: 

=SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell O2

Regards
Prince

On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote:

 Dear Team,

 Need a formula to look up a filed  give sum of figure , sample file 
 attached

 Regards,

 Prashant


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

FORUM RULES

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

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



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

FORUM RULES

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

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

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

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

pl share a worksheet with us

On Tue, Jan 15, 2013 at 1:45 PM, vikin...@gmail.com wrote:

 **
 Hi prince


 Will you please help me.
 I have three different excel file and each excel file have three different
 wrk sheet. I need to link or copy all data in one excel file from these
 different wrk sheet. How do I do this.

 In advance thnks for help.
 Sent from my BlackBerry® Smartphone on Loop Mobile.
 --
 *From: * Prince prince141...@gmail.com
 *Sender: * excel-macros@googlegroups.com
 *Date: *Sun, 13 Jan 2013 23:02:48 -0800 (PST)
 *To: *excel-macros@googlegroups.com
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *$$Excel-Macros$$ Re: formula required

 Hi Prashant,

 I hope it may help you:

 =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell O2

 Regards
 Prince

 On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote:

 Dear Team,

 Need a formula to look up a filed  give sum of figure , sample file
 attached

 Regards,

 Prashant

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

 FORUM RULES

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

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



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

 FORUM RULES

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

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






-- 
Thanks  Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

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

FORUM RULES

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

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

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

[Prince]

Hi Vikas,

Here is the macro than can combine data from multiple filse in to a single 
file
 

Public Sub CombineDataFromFiles()

Dim varArrFile  As Variant
Dim intCtr  As Integer
Dim strFilesAs String
Dim wbk As Workbook
Dim wbkFinalAs Workbook
Dim rngData As Range

Set wbkFinal = Workbooks.Add(1)
varArrFile = Application.GetOpenFilename(*.xls,*.xlsx, , Select 
Files, , True)
If IsArray(varArrFile) = False Then
MsgBox Select File...
Exit Sub
Else
For intCtr = LBound(varArrFile) To UBound(varArrFile)
Set wbk = Workbooks.Open(varArrFile(intCtr))
With wbk.Worksheets(1)
Set rngData = .UsedRange
End With
With wbkFinal.Worksheets(1)
rngData.Copy
.Range(A  .Range(A  Rows.Count).End(xlUp).Row + 
1).PasteSpecial
Application.CutCopyMode = False
End With
wbk.Close
Set wbk = Nothing
Next
End If
MsgBox All data combile into resultant file Please save!!!
End Sub


Here you can select multple file by using CTRL key and selecting multiple 
files.

regards
Prince

On Tuesday, January 15, 2013 1:45:48 PM UTC+5:30, vikas wrote:

 Hi prince 


 Will you please help me. 
 I have three different excel file and each excel file have three different 
 wrk sheet. I need to link or copy all data in one excel file from these 
 different wrk sheet. How do I do this. 

 In advance thnks for help. 
 Sent from my BlackBerry® Smartphone on Loop Mobile.
 --
 *From: * Prince prince...@gmail.com javascript: 
 *Sender: * excel-...@googlegroups.com javascript: 
 *Date: *Sun, 13 Jan 2013 23:02:48 -0800 (PST)
 *To: *excel-...@googlegroups.com javascript:
 *ReplyTo: * excel-...@googlegroups.com javascript: 
 *Subject: *$$Excel-Macros$$ Re: formula required

 Hi Prashant,

 I hope it may help you: 

 =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell O2

 Regards
 Prince

 On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote:

 Dear Team,

 Need a formula to look up a filed  give sum of figure , sample file 
 attached

 Regards,

 Prashant

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


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

FORUM RULES

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

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

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

[Ms-Exl-Learner]

@ Prince,

Do you think is it a quality answer? and Dont you think you are 
re-directing the OP in wrong approach?


=SUM(($D$2:D5=D2)**1**(G2:M2))*with CSE*in Cell O2

Could you please explain what is the need of **1* *and what is the need 
ofCSE here* *why not then one (Non Array Approach) which Manoj 
suggested before your post*?

*

On 14-01-2013 12:32 PM, Prince wrote:

Hi Prashant,

I hope it may help you:

=SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell O2

Regards
Prince

On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote:

Dear Team,

Need a formula to look up a filed  give sum of figure , sample
file attached

Regards,

Prashant

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


FORUM RULES

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

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

---
You received this message because you are subscribed to the Google 
Groups MS EXCEL AND VBA MACROS group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros?hl=en.




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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

$$Excel-Macros$$ Re: formula required

[Prince]

Hi Prashant,

I hope it may help you: 

=SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell O2

Regards
Prince

On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote:

 Dear Team,

 Need a formula to look up a filed  give sum of figure , sample file 
 attached

 Regards,

 Prashant


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

FORUM RULES

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

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

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

[Aindril De]

Dear Amar,

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


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

 Hi All,
 Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but it
 is so long  Confusing.Pls suggest me simple formula for solution

 Regards
 Amar

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

 FORUM RULES

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

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






-- 

Warm Regards,
Aindril De
Ph: 9811300157

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

FORUM RULES

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

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

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

[amar takale]

No problem hide row delete,no matter.

On Fri, Jan 11, 2013 at 1:59 PM, Aindril De aind...@gmail.com wrote:

 Dear Amar,

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


   ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
 PHARMA ADVANCED RESEARCH 33 #VALUE!

 On Fri, Jan 11, 2013 at 12:15 PM, amar takale amartak...@gmail.comwrote:

 Hi All,
 Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but
 it is so long  Confusing.Pls suggest me simple formula for solution

 Regards
 Amar

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

 FORUM RULES

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

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






 --

 Warm Regards,
 Aindril De
 Ph: 9811300157

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

 FORUM RULES

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

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




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

FORUM RULES

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

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

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

[Aindril De]

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

On Fri, Jan 11, 2013 at 2:09 PM, amar takale amartak...@gmail.com wrote:

 No problem hide row delete,no matter.


 On Fri, Jan 11, 2013 at 1:59 PM, Aindril De aind...@gmail.com wrote:

 Dear Amar,

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


   ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
 PHARMA ADVANCED RESEARCH 33 #VALUE!

 On Fri, Jan 11, 2013 at 12:15 PM, amar takale amartak...@gmail.comwrote:

 Hi All,
 Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but
 it is so long  Confusing.Pls suggest me simple formula for solution

 Regards
 Amar

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

 FORUM RULES

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

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






 --

 Warm Regards,
 Aindril De
 Ph: 9811300157

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






-- 

Warm Regards,
Aindril De
Ph: 9811300157

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

FORUM RULES

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

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

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

[ashish koul]

 edit the formula in cells D163 and below and add =IFERROR(AX8/V8,0) . add
If error in all to avoid value errors

Or try this
=SUM(IF(ISNUMBER($C$163:$C$182+$D$163:$D$182),$C$163:$C$182*$D$163:$D$182,0))/C183
 with Ctrl+shift+ Enter

or
Visit this link
http://www.mrexcel.com/forum/excel-questions/289317-sumproduct-ignore-errors.html






On Fri, Jan 11, 2013 at 2:33 PM, Aindril De aind...@gmail.com wrote:

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


 On Fri, Jan 11, 2013 at 2:09 PM, amar takale amartak...@gmail.com wrote:

 No problem hide row delete,no matter.


 On Fri, Jan 11, 2013 at 1:59 PM, Aindril De aind...@gmail.com wrote:

 Dear Amar,

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


   ASTRAZENECA PHARMA INDIA LTD 36 #VALUE!  PFIZER LIMITED 35 17.6  SUN
 PHARMA ADVANCED RESEARCH 33 #VALUE!

 On Fri, Jan 11, 2013 at 12:15 PM, amar takale amartak...@gmail.comwrote:

 Hi All,
 Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but
 it is so long  Confusing.Pls suggest me simple formula for solution

 Regards
 Amar

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

 FORUM RULES

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

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






 --

 Warm Regards,
 Aindril De
 Ph: 9811300157

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






 --

 Warm Regards,
 Aindril De
 Ph: 9811300157

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

Re: $$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry

[ashish damor]

Dear Sir,

Thanks will try and get back to you.

On Wed, Oct 10, 2012 at 11:17 AM, Prince prince141...@gmail.com wrote:
 Hi Ashish,

 Please use sumifs formula for getting total GROSS  and TDS amount for each
 vendor.

 Regards
 Prince

 On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote:

 Dear All,

 I have an excel sheet wherein commission is generated for each
 business placed by our intermediary. I need to have a formula for
 monthly consolidated amount for Gross Amount (Column E) and TDS
 Deduction (Column I) of each intermediary without first sorting and
 subsequently adding each entry.

 I am enclosing the sample worksheet.

 Thanks in advance.

 --
 Thanking you.

 With regards,

 Ashish Damor

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





-- 
Thanking you.

With regards,

Ashish Damor

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Re: formula required for addition of amount for duplicate entry

[ashish damor]

Dear Sir,

If possible can you please send me the example of the formula.

On Wed, Oct 10, 2012 at 11:17 AM, Prince prince141...@gmail.com wrote:
 Hi Ashish,

 Please use sumifs formula for getting total GROSS  and TDS amount for each
 vendor.

 Regards
 Prince

 On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote:

 Dear All,

 I have an excel sheet wherein commission is generated for each
 business placed by our intermediary. I need to have a formula for
 monthly consolidated amount for Gross Amount (Column E) and TDS
 Deduction (Column I) of each intermediary without first sorting and
 subsequently adding each entry.

 I am enclosing the sample worksheet.

 Thanks in advance.

 --
 Thanking you.

 With regards,

 Ashish Damor

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





-- 
Thanking you.

With regards,

Ashish Damor

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Simple formula required

[amar takale]

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




Formula Required.xls
Description: MS-Excel spreadsheet

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

[amar takale]

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

On Tue, Sep 4, 2012 at 2:28 PM, Amresh Maurya amreshkushw...@gmail.comwrote:

 find the attached solution  - 1

 solution  - 2 you can use this formula

 =TRIM(SUBSTITUTE(D4,LEFTB(D4,FIND(),D4,1)),))

 find the attached solved excel sheet also.

 Regards
 Amresh

 Regards
 Amresh Maurya


 On Tue, Sep 4, 2012 at 2:01 PM, amar takale amartak...@gmail.com wrote:


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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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




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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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




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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

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

[Rajan_Verma]

 

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

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

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

 

 

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

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

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

[Ms-Exl-Learner .]

Or

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


*Ms.Exl.Learner*


---


On Tue, Sep 4, 2012 at 2:01 PM, amar takale amartak...@gmail.com wrote:


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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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




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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Appropriate formula required

[Dhanesh Verma]

Dear Friends,

 

In the attached list the total monthly allocations is more than the
total amount to be allocated, please suggest a suitable formula to
compute the same.

 

R'gds

 

Dhanesh

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

Book2.xlsx
Description: Book2.xlsx

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

[dguillett1]

I don’t understand your example but here is a formula you can adapt if you have 
the analysis toolpak
=MAX(0, MIN(EOMONTH(F$1,0), $B2) - MAX(F$1, $A2) + 1) * $C2 / $D2

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

From: Dhanesh Verma 
Sent: Monday, May 21, 2012 7:13 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Appropriate formula required

Dear Friends,

 

In the attached list the total monthly allocations is more than the total 
amount to be allocated, please suggest a suitable formula to compute the same.

 

R’gds

 

Dhanesh

DISCLAIMER AND PRIVILEGE NOTICE : This e-mail and any files transmitted with it 
contain confidential, copyright, proprietary and legally privileged 
information. It should not be used by anyone who is not the original intended 
recipient. Any use, distribution, copying or disclosure by any other person is 
strictly prohibited. If you receive this transmission in error, please notify 
the sender by reply email and then destroy the message. Opinions, conclusions 
and other information in this message that do not relate to official business 
of DEN Networks Ltd., its subsidiaries, holding companies i.e. DEN shall be 
understood to be neither given nor endorsed by DEN. Internet communications 
cannot be guaranteed to be timely, Secure, error or virus-free. The sender does 
not accept liability for any errors or omissions.

-- 
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$$ Re: formula required for count or count if

[Rajan_Verma]

Hi 

Please find attached Sheet

 

=SUM(1/COUNTIF(OFFSET(INDEX(Range,MATCH(A2,Range,0),1),,1,COUNTIF(Range,A2),
COUNTA(D1:AC1)-1),OFFSET(INDEX(Range,MATCH(A2,Range,0),1),,1,COUNTIF(Range,A
2),COUNTA(D1:AC1)-1)))-1

 

Rajan

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of CoRe
Sent: Apr/Fri/2012 12:58
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: formula required for count or count if

 

Hello Lee,

 

PFA!

 

If you have any queries ,give a shout ...


On Friday, April 27, 2012 7:30:32 AM UTC+3, lee wrote:

hi

i have data as in the attached data. i need count of unique values of column
A i.e i need output as in column AB, AC... pls advise a formula thanks

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

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

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

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

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

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

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

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

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

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


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

$$Excel-Macros$$ Re: formula required for count or count if

[Haseeb A]

Hello Lee,

This should work with just ENTER.

in AC2, then drag down.

=SUMPRODUCT((A$2:A$23=AB2)*(B$2:Z$23)/COUNTIF(B$2:Z$23,B$2:Z$23))

Adjust the ranges. See the attached.

Regards,
Haseeb

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


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

Re: $$Excel-Macros$$ Rank Formula required

[Mahesh parab]

Hi  Pankaj

PFA,
Try :
=RANK(E2,E$2:E$9)+SUMPRODUCT(--(E$2:E$9=E2),--(A2A$2:A$9))


HTH
Mahesh

On Mon, Mar 19, 2012 at 3:27 AM, dguillett1 dguille...@gmail.com wrote:

 Shorter. Also enter using CSE (ctrl+shift+enter)

 =COUNTIF($F$2:$F$9,F2)+**SUM(IF(F2=$F$2:F2,1,0))




 Don Guillett
 Microsoft MVP Excel
 SalesAid Software
 dguille...@gmail.com
 -Original Message- From: Secret Shot
 Sent: Sunday, March 18, 2012 4:02 PM
 To: excel-macros@googlegroups.com
 Subject: $$Excel-Macros$$ Rank Formula required

 Dear Expert,

 I want any formula to find Rank in Excel but that rank should be
 Unique.. if the value are same for ranking its should check second
 pereority. attach is the file for understanding the problme.

 Kindly help pls. i have tried with rank formula but it dosent work.
 --
 Pankaj Pandey
 Bhopal

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

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

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

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

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

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

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

 --**--**
 --**
 To post to this group, send email to excel-macros@googlegroups.com
 --
 FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.
 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

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


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

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

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

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

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

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

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

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


Ranking required_19032012.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Rank Formula required

[Secret Shot]

Dear Expert,

I want any formula to find Rank in Excel but that rank should be
Unique.. if the value are same for ranking its should check second
pereority. attach is the file for understanding the problme.

Kindly help pls. i have tried with rank formula but it dosent work.
-- 
Pankaj Pandey
Bhopal

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


anking required.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Rank Formula required

[dguillett1]

See attached
=SUM(1*(F2$F$2:$F$9))+1+IF(ROW(F2)-ROW($F$2)=0,0,SUM(1*(F2=OFFSET($F$2,0,0,INDEX(ROW(F2)-ROW($F$2)+1,1)-1,1



Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Secret Shot

Sent: Sunday, March 18, 2012 4:02 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Rank Formula required

Dear Expert,

I want any formula to find Rank in Excel but that rank should be
Unique.. if the value are same for ranking its should check second
pereority. attach is the file for understanding the problme.

Kindly help pls. i have tried with rank formula but it dosent work.
--
Pankaj Pandey
Bhopal

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

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


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

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


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

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


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


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


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

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

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

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

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

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


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

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


anking required.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Rank Formula required

[dguillett1]

Shorter. Also enter using CSE (ctrl+shift+enter)

=COUNTIF($F$2:$F$9,F2)+SUM(IF(F2=$F$2:F2,1,0))



Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Secret Shot

Sent: Sunday, March 18, 2012 4:02 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Rank Formula required

Dear Expert,

I want any formula to find Rank in Excel but that rank should be
Unique.. if the value are same for ranking its should check second
pereority. attach is the file for understanding the problme.

Kindly help pls. i have tried with rank formula but it dosent work.
--
Pankaj Pandey
Bhopal

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

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


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

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


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

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


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


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


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

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

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

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

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

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


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

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

Re: $$Excel-Macros$$ Excel Formula Required - Sum data for every month for respective year.

[KAUSHIK SAVLA]

Thanks All.
It works excellent.

Regards,
Kaushik

On Wed, Jul 27, 2011 at 1:18 PM, Haseeb Avarakkan 
haseeb.avarak...@gmail.com wrote:

 If you need a formula use SUMPRODUCT or SUMIF

 See the attached.


 HTH
 Haseeb

 For Tips visit;
 http://www.excelfox.com/forum/forum.php

 --

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

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

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


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


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

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[deval desai]

U can Use Mid Function for the same
=Mid(Cell Reference, Starting Num, No of Chars)
For eg

Ur Orignal Code is 8900765

U want 765 then fromula is
=mid(cell Ref, 5,3)

Hope this will get result as u want.


On Apr 1, 6:55 pm, Puttu * puttu...@gmail.com wrote:
 Can you please please help any one





 On Fri, Apr 1, 2011 at 5:40 PM, Puttu * puttu...@gmail.com wrote:
  sorry again, please hep me in the formula

  On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote:

  awaiting for your replay please.

  On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:

  Experts please help me on this it's bit urgent sorry to bother.

  On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote:

  Hi Experts,

  I have list of items which have not full codes. I need them to convert
  full code. Could you please help me.

  Item code column has either 3, 2, 4  5 digits no. but by default they
  should be either 6 or 7 or 8 digits code. What best formul I need to use 
  to
  get that output. Item Full Code output column has the correct answers
  which I manually entered. I want the same way answer using the formulas

  Item Full Code output

  Give the formula for output

  Item Code

  200990

   990

  200991

   991

     300011

   11

  300014

   14

  300104

   104

     520901

   20901

  520902

   20902

  500450

   450

  500451

   451

     203529

   3529

  203538

   3538

     8515959

   15959

  8516271

   16271

     8203892

   3892

  8203893

   3893

     1620224

   224

  1620225

   225

  --
  Putta

  --

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

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

  --
  Putta

  --
  Putta

  --
  Putta

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


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

$$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

Hi Experts,

I have list of items which have not full codes. I need them to convert full
code. Could you please help me.

Item code column has either 3, 2, 4  5 digits no. but by default they
should be either 6 or 7 or 8 digits code. What best formul I need to use to
get that output. Item Full Code output column has the correct answers
which I manually entered. I want the same way answer using the formulas


Item Full Code output

Give the formula for output

Item Code

200990

 990

200991

 991

   300011

 11

300014

 14

300104

 104

   520901

 20901

520902

 20902

500450

 450

500451

 451

   203529

 3529

203538

 3538

   8515959

 15959

8516271

 16271

   8203892

 3892

8203893

 3893

   1620224

 224

1620225

 225


-- 
Putta

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


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

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

awaiting for your replay please.

On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:

 Experts please help me on this it's bit urgent sorry to bother.


 On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote:

 Hi Experts,

 I have list of items which have not full codes. I need them to convert
 full code. Could you please help me.

 Item code column has either 3, 2, 4  5 digits no. but by default they
 should be either 6 or 7 or 8 digits code. What best formul I need to use to
 get that output. Item Full Code output column has the correct answers
 which I manually entered. I want the same way answer using the formulas


 Item Full Code output

 Give the formula for output

 Item Code

 200990

  990

 200991

  991

300011

  11

 300014

  14

 300104

  104

520901

  20901

 520902

  20902

 500450

  450

 500451

  451

203529

  3529

 203538

  3538

8515959

  15959

 8516271

  16271

8203892

  3892

 8203893

  3893

1620224

  224

 1620225

  225


 --
 Putta

 --

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




 --
 Putta




-- 
Putta

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


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

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

sorry again, please hep me in the formula

On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote:

 awaiting for your replay please.


 On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:

 Experts please help me on this it's bit urgent sorry to bother.


 On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote:

 Hi Experts,

 I have list of items which have not full codes. I need them to convert
 full code. Could you please help me.

 Item code column has either 3, 2, 4  5 digits no. but by default they
 should be either 6 or 7 or 8 digits code. What best formul I need to use to
 get that output. Item Full Code output column has the correct answers
 which I manually entered. I want the same way answer using the formulas


 Item Full Code output

 Give the formula for output

 Item Code

 200990

  990

 200991

  991

300011

  11

 300014

  14

 300104

  104

520901

  20901

 520902

  20902

 500450

  450

 500451

  451

203529

  3529

 203538

  3538

8515959

  15959

 8516271

  16271

8203892

  3892

 8203893

  3893

1620224

  224

 1620225

  225


 --
 Putta

 --

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




 --
 Putta




 --
 Putta




-- 
Putta

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


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

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Bhushan Sabbani]

attach the sample file so we can help you.


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


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

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Umesh Dev]

Hi Puttu,

explain it in excel sheet and also mention all the possibilities.

Regards
Umesh

On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote:

 awaiting for your replay please.


 On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:

 Experts please help me on this it's bit urgent sorry to bother.


 On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote:

 Hi Experts,

 I have list of items which have not full codes. I need them to convert
 full code. Could you please help me.

 Item code column has either 3, 2, 4  5 digits no. but by default they
 should be either 6 or 7 or 8 digits code. What best formul I need to use to
 get that output. Item Full Code output column has the correct answers
 which I manually entered. I want the same way answer using the formulas


 Item Full Code output

 Give the formula for output

 Item Code

 200990

  990

 200991

  991

300011

  11

 300014

  14

 300104

  104

520901

  20901

 520902

  20902

 500450

  450

 500451

  451

203529

  3529

 203538

  3538

8515959

  15959

 8516271

  16271

8203892

  3892

 8203893

  3893

1620224

  224

 1620225

  225


 --
 Putta

 --

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




 --
 Putta




 --
 Putta

 --

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

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

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


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


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

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[sunny k]

why r u using 200 for 990 or 300 for 11 any reason

On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:

 Experts please help me on this it's bit urgent sorry to bother.


 On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote:

 Hi Experts,

 I have list of items which have not full codes. I need them to convert
 full code. Could you please help me.

 Item code column has either 3, 2, 4  5 digits no. but by default they
 should be either 6 or 7 or 8 digits code. What best formul I need to use to
 get that output. Item Full Code output column has the correct answers
 which I manually entered. I want the same way answer using the formulas


 Item Full Code output

 Give the formula for output

 Item Code

 200990

  990

 200991

  991

300011

  11

 300014

  14

 300104

  104

520901

  20901

 520902

  20902

 500450

  450

 500451

  451

203529

  3529

 203538

  3538

8515959

  15959

 8516271

  16271

8203892

  3892

 8203893

  3893

1620224

  224

 1620225

  225


 --
 Putta

 --

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




 --
 Putta

 --

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

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

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


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


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

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[Puttu *]

Can you please please help any one

On Fri, Apr 1, 2011 at 5:40 PM, Puttu * puttu...@gmail.com wrote:

 sorry again, please hep me in the formula


 On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote:

 awaiting for your replay please.


 On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:

 Experts please help me on this it's bit urgent sorry to bother.


 On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote:

 Hi Experts,

 I have list of items which have not full codes. I need them to convert
 full code. Could you please help me.

 Item code column has either 3, 2, 4  5 digits no. but by default they
 should be either 6 or 7 or 8 digits code. What best formul I need to use to
 get that output. Item Full Code output column has the correct answers
 which I manually entered. I want the same way answer using the formulas


 Item Full Code output

 Give the formula for output

 Item Code

 200990

  990

 200991

  991

300011

  11

 300014

  14

 300104

  104

520901

  20901

 520902

  20902

 500450

  450

 500451

  451

203529

  3529

 203538

  3538

8515959

  15959

 8516271

  16271

8203892

  3892

 8203893

  3893

1620224

  224

 1620225

  225


 --
 Putta

 --

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




 --
 Putta




 --
 Putta




 --
 Putta




-- 
Putta

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


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

Re: $$Excel-Macros$$ Urgent Formula Required Help me

[rajan verma]

Item Full Code output

 Give the formula for output

 Item Code

 200990
 =Text(item_Code,000)

  990

 200991

  991

300011

  11

 300014

  14

 300104

  104

520901

  20901

 520902

  20902

 500450

  450

 500451

  451

203529

  3529

 203538

  3538

8515959

  15959

 8516271

  16271

8203892

  3892

 8203893

  3893

1620224

  224

 1620225

  225


 --
 Putta

 --

 --
 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
Rajan verma
+91 9158998701

-- 
--
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$$ Help : Formula Required

[rajan verma]

=IF(OR(HOUR(M14)7,HOUR(M14)21),Yes,No)

Rajan

On Wed, Mar 30, 2011 at 5:23 PM, zinknax.zin...@gmail.com wrote:

 Hi All,

 I need formula to update column C,  value if the time is between 7:00 AM to
 9:00 PM YES else NO
 Find attached for the same.

 Column AColumn BColumn C
 DateTime (MST)  7:00 AM 9:00 PM
 3/28/2011   6:26 AM YES IF LESS THAN 7:00:00 AM THEN YES
 3/28/2011   6:47 AM YES IF GREATER THAN 9:00:00 PM THEN YES
 3/28/2011   6:51 AM YES Between 7:00 Am to 9:00 Pm, Cell
 value NO
 3/28/2011   6:59 AM YES
 3/28/2011   7:13 AM NO
 3/28/2011   7:32 AM NO
 3/28/2011   7:45 AM NO
 3/28/2011   7:46 AM NO
 3/28/2011   1:29 PM NO
 3/28/2011   1:42 PM NO
 3/28/2011   1:42 PM NO
 3/28/2011   1:42 PM NO
 3/28/2011   1:43 PM NO
 3/28/2011   1:43 PM NO
 3/28/2011   1:49 PM NO
 3/28/2011   1:56 PM NO
 3/28/2011   2:06 PM NO
 3/28/2011   2:08 PM NO
 3/28/2011   2:12 PM NO
 3/28/2011   2:18 PM NO
 3/28/2011   2:23 PM NO
 3/28/2011   2:32 PM NO
 3/28/2011   2:35 PM NO
 3/28/2011   2:37 PM NO
 3/28/2011   2:41 PM NO
 3/28/2011   2:46 PM NO
 3/28/2011   2:50 PM NO
 3/28/2011   2:50 PM NO
 3/28/2011   2:55 PM NO
 3/28/2011   3:02 PM NO
 3/28/2011   3:02 PM NO
 3/28/2011   3:15 PM NO
 3/28/2011   3:18 PM NO
 3/28/2011   3:21 PM NO
 3/28/2011   3:30 PM NO
 3/28/2011   3:31 PM NO
 3/28/2011   3:33 PM NO
 3/28/2011   3:39 PM NO
 3/28/2011   3:43 PM NO
 3/28/2011   3:59 PM NO
 3/28/2011   4:00 PM NO
 3/28/2011   4:03 PM NO
 3/28/2011   4:05 PM NO
 3/28/2011   4:07 PM NO
 3/28/2011   4:20 PM NO
 3/28/2011   4:28 PM NO
 3/28/2011   4:28 PM NO
 3/28/2011   4:28 PM NO
 3/28/2011   4:38 PM NO
 3/28/2011   4:39 PM NO
 3/28/2011   4:45 PM NO
 3/28/2011   4:46 PM NO
 3/28/2011   4:48 PM NO
 3/28/2011   4:49 PM NO
 3/28/2011   4:49 PM NO
 3/28/2011   4:49 PM NO
 3/28/2011   4:51 PM NO
 3/28/2011   4:52 PM NO
 3/28/2011   4:54 PM NO
 3/28/2011   5:05 PM NO
 3/28/2011   5:31 PM NO
 3/28/2011   5:49 PM NO
 3/28/2011   5:58 PM NO
 3/28/2011   6:04 PM NO
 3/28/2011   6:10 PM NO
 3/28/2011   6:16 PM NO
 3/28/2011   6:26 PM NO
 3/28/2011   6:27 PM NO
 3/28/2011   6:28 PM NO
 3/28/2011   6:44 PM NO
 3/28/2011   6:57 PM NO
 3/28/2011   7:03 PM NO
 3/28/2011   7:10 PM NO
 3/28/2011   7:15 PM NO
 3/28/2011   7:18 PM NO
 3/28/2011   7:18 PM NO
 3/28/2011   7:20 PM NO
 3/28/2011   7:26 PM NO
 3/28/2011   7:34 PM NO
 3/28/2011   7:35 PM NO
 3/28/2011   7:39 PM NO
 3/28/2011   7:44 PM NO
 3/28/2011   8:06 PM NO
 3/28/2011   8:12 PM NO
 3/28/2011   8:20 PM NO
 3/28/2011   8:22 PM NO
 3/28/2011   8:23 PM NO
 3/28/2011   8:23 PM NO
 3/28/2011   8:24 PM NO
 3/28/2011   8:28 PM NO
 3/28/2011   8:37 PM NO
 3/28/2011   8:43 PM NO
 3/28/2011   8:53 PM NO
 3/28/2011   8:57 PM NO
 3/28/2011   9:02 PM YES
 3/28/2011   9:05 PM YES
 3/28/2011   9:16 PM YES
 3/28/2011   9:24 PM YES
 3/28/2011   9:29 PM YES
 3/28/2011   9:40 PM YES
 3/28/2011   10:02 PMYES
 3/28/2011   10:02 PMYES
 3/28/2011   10:23 PMYES



 Thanks,
 Mayur

 --
 Sent by http://webuzz.im/mail/ web mail client

 --

 --
 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
Rajan verma
+91 9158998701

-- 
--
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$$ Help : Formula Required

[JsinSk]

On my response I screwed up the 24 hour time format! Should be 21:00
instead of 17:00.

On Mar 30, 1:17 pm, STDEV(i) setiyowati.d...@gmail.com wrote:
 Try this formula

 =IF((B2=7/24)*(B2=9/24),NO,YES)

 On Wed, Mar 30, 2011 at 6:53 PM, zinknax.zin...@gmail.com wrote:
  Hi All,

  I need formula to update column C,  value if the time is between 7:00 AM to
  9:00 PM YES else NO
  Find attached for the same.

  Column A        Column B        Column C
  Date    Time (MST)                      7:00 AM 9:00 PM
  3/28/2011       6:26 AM YES             IF LESS THAN 7:00:00 AM THEN YES
  3/28/2011       6:47 AM YES             IF GREATER THAN 9:00:00 PM THEN YES
  3/28/2011       6:51 AM YES             Between 7:00 Am to 9:00 Pm, Cell
  value NO
  3/28/2011       6:59 AM YES
  3/28/2011       7:13 AM NO
  3/28/2011       7:32 AM NO
  3/28/2011       7:45 AM NO
  3/28/2011       7:46 AM NO

  Thanks,
  Mayur

-- 
--
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$$ Help : Formula Required

[STDEV(i)]

so... make it simplest

=IF((B2=7/24)*(B2=*21*/24),NO,YES)


On Thu, Mar 31, 2011 at 12:23 AM, JsinSk jsin...@gmail.com wrote:

 On my response I screwed up the 24 hour time format! Should be 21:00
 instead of 17:00.

 On Mar 30, 1:17 pm, STDEV(i) setiyowati.d...@gmail.com wrote:
  Try this formula
 
  *=IF((B2=7/24)*(B2=9/24),NO,YES)*
 
  On Wed, Mar 30, 2011 at 6:53 PM, zinknax.zin...@gmail.com wrote:
   Hi All,
 
   I need formula to update column C,  value if the time is between 7:00
 AM to
   9:00 PM YES else NO
   Find attached for the same.
 
   Column AColumn BColumn C
   DateTime (MST)  7:00 AM 9:00 PM
   3/28/2011   6:26 AM YES IF LESS THAN 7:00:00 AM THEN
 YES
   3/28/2011   6:47 AM YES IF GREATER THAN 9:00:00 PM THEN
 YES
   3/28/2011   6:51 AM YES Between 7:00 Am to 9:00 Pm,
 Cell
   value NO
   3/28/2011   6:59 AM YES
   3/28/2011   7:13 AM NO
   3/28/2011   7:32 AM NO
   3/28/2011   7:45 AM NO
   3/28/2011   7:46 AM NO
 
   Thanks,
   Mayur



-- 
--
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$$ Help : Formula Required

[Surendra saxena]

here is the formula

=IF(B2=(7/24),Yes,IF(B2=(21/24),Yes,No))

On Wed, Mar 30, 2011 at 5:23 PM, zinknax.zin...@gmail.com wrote:

 Hi All,

 I need formula to update column C,  value if the time is between 7:00 AM to
 9:00 PM YES else NO
 Find attached for the same.

 Column AColumn BColumn C
 DateTime (MST)  7:00 AM 9:00 PM
 3/28/2011   6:26 AM YES IF LESS THAN 7:00:00 AM THEN YES
 3/28/2011   6:47 AM YES IF GREATER THAN 9:00:00 PM THEN YES
 3/28/2011   6:51 AM YES Between 7:00 Am to 9:00 Pm, Cell
 value NO
 3/28/2011   6:59 AM YES
 3/28/2011   7:13 AM NO
 3/28/2011   7:32 AM NO
 3/28/2011   7:45 AM NO
 3/28/2011   7:46 AM NO
 3/28/2011   1:29 PM NO
 3/28/2011   1:42 PM NO
 3/28/2011   1:42 PM NO
 3/28/2011   1:42 PM NO
 3/28/2011   1:43 PM NO
 3/28/2011   1:43 PM NO
 3/28/2011   1:49 PM NO
 3/28/2011   1:56 PM NO
 3/28/2011   2:06 PM NO
 3/28/2011   2:08 PM NO
 3/28/2011   2:12 PM NO
 3/28/2011   2:18 PM NO
 3/28/2011   2:23 PM NO
 3/28/2011   2:32 PM NO
 3/28/2011   2:35 PM NO
 3/28/2011   2:37 PM NO
 3/28/2011   2:41 PM NO
 3/28/2011   2:46 PM NO
 3/28/2011   2:50 PM NO
 3/28/2011   2:50 PM NO
 3/28/2011   2:55 PM NO
 3/28/2011   3:02 PM NO
 3/28/2011   3:02 PM NO
 3/28/2011   3:15 PM NO
 3/28/2011   3:18 PM NO
 3/28/2011   3:21 PM NO
 3/28/2011   3:30 PM NO
 3/28/2011   3:31 PM NO
 3/28/2011   3:33 PM NO
 3/28/2011   3:39 PM NO
 3/28/2011   3:43 PM NO
 3/28/2011   3:59 PM NO
 3/28/2011   4:00 PM NO
 3/28/2011   4:03 PM NO
 3/28/2011   4:05 PM NO
 3/28/2011   4:07 PM NO
 3/28/2011   4:20 PM NO
 3/28/2011   4:28 PM NO
 3/28/2011   4:28 PM NO
 3/28/2011   4:28 PM NO
 3/28/2011   4:38 PM NO
 3/28/2011   4:39 PM NO
 3/28/2011   4:45 PM NO
 3/28/2011   4:46 PM NO
 3/28/2011   4:48 PM NO
 3/28/2011   4:49 PM NO
 3/28/2011   4:49 PM NO
 3/28/2011   4:49 PM NO
 3/28/2011   4:51 PM NO
 3/28/2011   4:52 PM NO
 3/28/2011   4:54 PM NO
 3/28/2011   5:05 PM NO
 3/28/2011   5:31 PM NO
 3/28/2011   5:49 PM NO
 3/28/2011   5:58 PM NO
 3/28/2011   6:04 PM NO
 3/28/2011   6:10 PM NO
 3/28/2011   6:16 PM NO
 3/28/2011   6:26 PM NO
 3/28/2011   6:27 PM NO
 3/28/2011   6:28 PM NO
 3/28/2011   6:44 PM NO
 3/28/2011   6:57 PM NO
 3/28/2011   7:03 PM NO
 3/28/2011   7:10 PM NO
 3/28/2011   7:15 PM NO
 3/28/2011   7:18 PM NO
 3/28/2011   7:18 PM NO
 3/28/2011   7:20 PM NO
 3/28/2011   7:26 PM NO
 3/28/2011   7:34 PM NO
 3/28/2011   7:35 PM NO
 3/28/2011   7:39 PM NO
 3/28/2011   7:44 PM NO
 3/28/2011   8:06 PM NO
 3/28/2011   8:12 PM NO
 3/28/2011   8:20 PM NO
 3/28/2011   8:22 PM NO
 3/28/2011   8:23 PM NO
 3/28/2011   8:23 PM NO
 3/28/2011   8:24 PM NO
 3/28/2011   8:28 PM NO
 3/28/2011   8:37 PM NO
 3/28/2011   8:43 PM NO
 3/28/2011   8:53 PM NO
 3/28/2011   8:57 PM NO
 3/28/2011   9:02 PM YES
 3/28/2011   9:05 PM YES
 3/28/2011   9:16 PM YES
 3/28/2011   9:24 PM YES
 3/28/2011   9:29 PM YES
 3/28/2011   9:40 PM YES
 3/28/2011   10:02 PMYES
 3/28/2011   10:02 PMYES
 3/28/2011   10:23 PMYES



 Thanks,
 Mayur

 --
 Sent by http://webuzz.im/mail/ web mail client

 --

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




-- 
Your's
Surendra

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

$$Excel-Macros$$ Help : Formula Required

[zinknax . zinkli]

Hi All,

I need formula to update column C,  value if the time is between 7:00 AM to 
9:00 PM YES else NO
Find attached for the same.

Column AColumn BColumn C
DateTime (MST)  7:00 AM 9:00 PM
3/28/2011   6:26 AM YES IF LESS THAN 7:00:00 AM THEN YES
3/28/2011   6:47 AM YES IF GREATER THAN 9:00:00 PM THEN YES 
3/28/2011   6:51 AM YES Between 7:00 Am to 9:00 Pm, Cell value 
NO 
3/28/2011   6:59 AM YES 
3/28/2011   7:13 AM NO  
3/28/2011   7:32 AM NO  
3/28/2011   7:45 AM NO  
3/28/2011   7:46 AM NO  
3/28/2011   1:29 PM NO  
3/28/2011   1:42 PM NO  
3/28/2011   1:42 PM NO  
3/28/2011   1:42 PM NO  
3/28/2011   1:43 PM NO  
3/28/2011   1:43 PM NO  
3/28/2011   1:49 PM NO  
3/28/2011   1:56 PM NO  
3/28/2011   2:06 PM NO  
3/28/2011   2:08 PM NO  
3/28/2011   2:12 PM NO  
3/28/2011   2:18 PM NO  
3/28/2011   2:23 PM NO  
3/28/2011   2:32 PM NO  
3/28/2011   2:35 PM NO  
3/28/2011   2:37 PM NO  
3/28/2011   2:41 PM NO  
3/28/2011   2:46 PM NO  
3/28/2011   2:50 PM NO  
3/28/2011   2:50 PM NO  
3/28/2011   2:55 PM NO  
3/28/2011   3:02 PM NO  
3/28/2011   3:02 PM NO  
3/28/2011   3:15 PM NO  
3/28/2011   3:18 PM NO  
3/28/2011   3:21 PM NO  
3/28/2011   3:30 PM NO  
3/28/2011   3:31 PM NO  
3/28/2011   3:33 PM NO  
3/28/2011   3:39 PM NO  
3/28/2011   3:43 PM NO  
3/28/2011   3:59 PM NO  
3/28/2011   4:00 PM NO  
3/28/2011   4:03 PM NO  
3/28/2011   4:05 PM NO  
3/28/2011   4:07 PM NO  
3/28/2011   4:20 PM NO  
3/28/2011   4:28 PM NO  
3/28/2011   4:28 PM NO  
3/28/2011   4:28 PM NO  
3/28/2011   4:38 PM NO  
3/28/2011   4:39 PM NO  
3/28/2011   4:45 PM NO  
3/28/2011   4:46 PM NO  
3/28/2011   4:48 PM NO  
3/28/2011   4:49 PM NO  
3/28/2011   4:49 PM NO  
3/28/2011   4:49 PM NO  
3/28/2011   4:51 PM NO  
3/28/2011   4:52 PM NO  
3/28/2011   4:54 PM NO  
3/28/2011   5:05 PM NO  
3/28/2011   5:31 PM NO  
3/28/2011   5:49 PM NO  
3/28/2011   5:58 PM NO  
3/28/2011   6:04 PM NO  
3/28/2011   6:10 PM NO  
3/28/2011   6:16 PM NO  
3/28/2011   6:26 PM NO  
3/28/2011   6:27 PM NO  
3/28/2011   6:28 PM NO  
3/28/2011   6:44 PM NO  
3/28/2011   6:57 PM NO  
3/28/2011   7:03 PM NO  
3/28/2011   7:10 PM NO  
3/28/2011   7:15 PM NO  
3/28/2011   7:18 PM NO  
3/28/2011   7:18 PM NO  
3/28/2011   7:20 PM NO  
3/28/2011   7:26 PM NO  
3/28/2011   7:34 PM NO  
3/28/2011   7:35 PM NO  
3/28/2011   7:39 PM NO  
3/28/2011   7:44 PM NO  
3/28/2011   8:06 PM NO  
3/28/2011   8:12 PM NO  
3/28/2011   8:20 PM NO  
3/28/2011   8:22 PM NO  
3/28/2011   8:23 PM NO  
3/28/2011   8:23 PM NO  
3/28/2011   8:24 PM NO  
3/28/2011   8:28 PM NO  
3/28/2011   8:37 PM NO  
3/28/2011   8:43 PM NO  
3/28/2011   8:53 PM NO  
3/28/2011   8:57 PM NO  
3/28/2011   9:02 PM YES   

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

[STDEV(i)]

Try this formula

=IF((B2=7/24)*(B2=9/24),NO,YES)



On Wed, Mar 30, 2011 at 6:53 PM, zinknax.zin...@gmail.com wrote:

 Hi All,

 I need formula to update column C,  value if the time is between 7:00 AM to
 9:00 PM YES else NO
 Find attached for the same.

 Column AColumn BColumn C
 DateTime (MST)  7:00 AM 9:00 PM
 3/28/2011   6:26 AM YES IF LESS THAN 7:00:00 AM THEN YES
 3/28/2011   6:47 AM YES IF GREATER THAN 9:00:00 PM THEN YES
 3/28/2011   6:51 AM YES Between 7:00 Am to 9:00 Pm, Cell
 value NO
 3/28/2011   6:59 AM YES
 3/28/2011   7:13 AM NO
 3/28/2011   7:32 AM NO
 3/28/2011   7:45 AM NO
 3/28/2011   7:46 AM NO

 Thanks,
 Mayur



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

$$Excel-Macros$$ Urgent formula required for Stock forecasting...

[lucky singh]

Hi All,

urgent help required for forecasting stock in warehouse

I have 8 products in my warehouse month on month the balance get deducted
from it as and when it get sale

However I need to know the available stock because it takes 50 days for my
order

Regards,
Jay S
9987337414

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


HELP US GROW !!

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


Forcast.xls
Description: MS-Excel spreadsheet

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

[Venkatesh Narla]

Hi,
Can u explain me what is ur query

i did some this pls have a look




On Thu, Mar 18, 2010 at 2:31 PM, Venkatesan c venkat1@gmail.com wrote:
 Dear All,

 Any one can Assist me attached file query It's something like reverse Lookup

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

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
REMOVE ME as the subject.


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

$$Excel-Macros$$ Excel Formula Required

[Venkatesan c]

Dear All,

Any one can Assist me attached file query It's something like reverse Lookup

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

Query.xls
Description: MS-Excel spreadsheet

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

[Norman May]

Try the following attached file
This is a left lookup

On Thu, Mar 18, 2010 at 5:01 AM, Venkatesan c venkat1@gmail.com wrote:

 Dear All,

 Any one can Assist me attached file query It's something like reverse
 Lookup

 --

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

Query(2).xls
Description: MS-Excel spreadsheet

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

[Dilip Pandey]

Dear Venkatesan,

Attached file has two solutions for your query.
Let me know in case of any challenge(s).


-- 
Thanks  Regards,

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


On Thu, Mar 18, 2010 at 2:31 PM, Venkatesan c venkat1@gmail.com wrote:

 Dear All,

 Any one can Assist me attached file query It's something like reverse
 Lookup

 --

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

Query-Reverse Vlookup by DILipandey.xls
Description: MS-Excel spreadsheet

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

[Sandeep Kumar Maurya]

Simplest possible. But needed unique list (no duplication).

Regards
Sandeep

On Thu, Mar 18, 2010 at 8:37 PM, Dilip Pandey dilipan...@gmail.com wrote:

 Dear Venkatesan,

 Attached file has two solutions for your query.
 Let me know in case of any challenge(s).


 --
 Thanks  Regards,

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


 On Thu, Mar 18, 2010 at 2:31 PM, Venkatesan c venkat1@gmail.comwrote:

 Dear All,

 Any one can Assist me attached file query It's something like reverse
 Lookup

 --

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


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

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
REMOVE ME as the subject.


Query-Reverse Vlookup by DILipandey.xls
Description: MS-Excel spreadsheet