Dear Gawli Thanks for your advice, but still problem I tried apply on my sheet, So the fomular catch on max date of forecast date My requirement are catch on max date Which it have number
Rdgs Attapan Chainarongboon Production control Dept (Compressor) Calsonic Kansei (Thailand) E-mail : attapan_chainarongb...@ck-mail.com Phone : (+66) 038-210-129 #101 Mobile phone: (+66) 086-824-5045 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anil Gawli Sent: Friday, June 15, 2012 1:36 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup fomular Find Attached Sheet On Fri, Jun 15, 2012 at 10:55 AM, <attapan_chainarongb...@ck-mail.com<mailto:attapan_chainarongb...@ck-mail.com>> wrote: Dear all experts I've some questions to ask in my sheet The sheet put for the forecast date and quantity each per forecast date I need to get the lastest forecast date and the quantity of that, So, the result which fomular which I use are "Ok", but I think may be have better way to do that Please advice Rdgs Attapan Chainarongboon E-mail : attapan_chainarongb...@ck-mail.com<mailto:attapan_chainarongb...@ck-mail.com> Phone : (+66) 038-210-129<tel:%28%2B66%29%20038-210-129> #101 Mobile phone: (+66) 086-824-5045<tel:%28%2B66%29%20086-824-5045> -- 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<mailto:excel-macros@googlegroups.com> To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com> -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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<mailto:excel-macros@googlegroups.com> To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<mailto: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
order.xlsx
Description: order.xlsx
