Re: $$Excel-Macros$$ query for finding maximum and minimum values
Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B70,B1:B7)) =MIN(IF(A1:A70,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote: hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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$$ query for finding maximum and minimum values
Dear Kenil, Without using ctrl+shfit+enter You can also use.. =SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2))) =SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2))) On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.comwrote: On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B70,B1:B7)) =MIN(IF(A1:A70,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote: hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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$$ query for finding maximum and minimum values
thank u vijayajith and noorain ansari for your reply, but i think u have mis understood my query. i have written my query with a comment in another cell again, Thanks and Regards. --- On Tue, 8/14/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: From: NOORAIN ANSARI noorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 12:27 PM Dear Kenil, Without using ctrl+shfit+enter You can also use.. =SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2))) =SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2))) On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.com wrote: On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B70,B1:B7)) =MIN(IF(A1:A70,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote: hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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. -- With Regards, Noorain Ansari http://noorainansari.com http://excelvbaclinic.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick
Re: $$Excel-Macros$$ query for finding maximum and minimum values
Dear Kenil, There is no attachment with this mail. Please send attachment with comment. On Tue, Aug 14, 2012 at 6:19 PM, Kenil Gala keni...@yahoo.com wrote: thank u vijayajith and noorain ansari for your reply, but i think u have mis understood my query. i have written my query with a comment in another cell again, Thanks and Regards. --- On *Tue, 8/14/12, NOORAIN ANSARI noorain.ans...@gmail.com* wrote: From: NOORAIN ANSARI noorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 12:27 PM Dear Kenil, Without using ctrl+shfit+enter You can also use.. =SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2))) =SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2))) On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=vijayajith...@gmail.com wrote: On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA vijayajith...@gmail.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=vijayajith...@gmail.com wrote: Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B70,B1:B7)) =MIN(IF(A1:A70,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=keni...@yahoo.com wrote: hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com . To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com . To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com . -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ -- 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
Re: $$Excel-Macros$$ query for finding maximum and minimum values
Yes Sir, Perfect Thanks a Ton. Thanks Regards, --- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote: From: dguillett1 dguille...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 5:05 PM Should do it Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 10:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values Hello sir , i have explained my query more clearly again in the excel sheet. i hope u'll be able to understand the query. Thanks and Regards, --- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote: From: dguillett1 dguille...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 3:02 PM This is your question in i4 comment hi, I have daily data of high , low and close of a specific stock (BSE). But I want weekly high,low,close and also monthly high, low, close in their respective sheets. Eg. Stock market has 5 working days, so any value which can be highest and lowest withing the week and the closing price of friday. i tried doing this by taking 5 set of data( monday - friday) but at times of holiday, markets remain working only 4 or 3 days. so, can you help me finding weekly high, low, close and also monthly high, low, close( from 1st to 31st or 30th or 28th as per month) and also TO and from date i.e the time span of that week or month. that i have mentioned in the table in sheet 2 and sheet 3. i have taken all this data from www.nseindia.com Thanks. === Your query is not understandable. If you want the minimum low and the maximum high and the average close for the week, see attached. Maybe you really want the min CLOSE?? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 6:54 AM To: excel macros Subject: $$Excel-Macros$$ query for finding maximum and minimum values hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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
Re: $$Excel-Macros$$ query for finding maximum and minimum values
I am available for custom excel projects at only $75 hourly . Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 12:20 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values Yes Sir, Perfect Thanks a Ton. Thanks Regards, --- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote: From: dguillett1 dguille...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 5:05 PM Should do it Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 10:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values Hello sir , i have explained my query more clearly again in the excel sheet. i hope u'll be able to understand the query. Thanks and Regards, --- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote: From: dguillett1 dguille...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 3:02 PM This is your question in i4 comment hi, I have daily data of high , low and close of a specific stock (BSE). But I want weekly high,low,close and also monthly high, low, close in their respective sheets. Eg. Stock market has 5 working days, so any value which can be highest and lowest withing the week and the closing price of friday. i tried doing this by taking 5 set of data( monday - friday) but at times of holiday, markets remain working only 4 or 3 days. so, can you help me finding weekly high, low, close and also monthly high, low, close( from 1st to 31st or 30th or 28th as per month) and also TO and from date i.e the time span of that week or month. that i have mentioned in the table in sheet 2 and sheet 3. i have taken all this data from www.nseindia.com Thanks. === Your query is not understandable. If you want the minimum low and the maximum high and the average close for the week, see attached. Maybe you really want the min CLOSE?? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 6:54 AM To: excel macros Subject: $$Excel-Macros$$ query for finding maximum and minimum values hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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