$$Excel-Macros$$ lookup based on multiple dates.
Hi All, I have a question, looking for solution through formula (but VBA is fine if not possible through formula :) )...I have 2 sheets in a workbook i.e Cust data and Review... In the Cust data sheet I have start date of the project i.e column B, column C is First review date and Column D is second review date of project and Review Sheet is the lookup table Question 1 (Column E): I need to find out how many times the particular end customer id has occurred between “Start date” and “First Review date” using Review Sheet tab. For example : end customer id “1-168WAQL” occured once between Start date (3/1/2011) and First Review date (7/31/2011) so the output in column E should be 1. Question 2 (Column f); on the similar line as previous question I need to find out how many times the particular end customer id has occurred between “*First Review Date”* and “*Second Review date”* using Review Sheet tab. For example : end customer id “1-168WAQL” occur once between *First Review date* (7/31/2011) and *Second Review date* (2/29/2012) so the output in column F should be 1. Sample data is attached for reference. Note : date format is MM/DD/. -- Regards, AK -- 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. Sample Data _AK.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ lookup based on multiple dates.
Try something like this COUNTIFS(Review!A:A,'Cust data'!A2,Review!B:B,=#'Cust data'!B2#,Review!B:B,=#'Cust data'!C2#) On Mon, Dec 3, 2012 at 8:10 PM, AK exce...@gmail.com wrote: Hi All, I have a question, looking for solution through formula (but VBA is fine if not possible through formula :) )...I have 2 sheets in a workbook i.e Cust data and Review... In the Cust data sheet I have start date of the project i.e column B, column C is First review date and Column D is second review date of project and Review Sheet is the lookup table Question 1 (Column E): I need to find out how many times the particular end customer id has occurred between “Start date” and “First Review date” using Review Sheet tab. For example : end customer id “1-168WAQL” occured once between Start date (3/1/2011) and First Review date (7/31/2011) so the output in column E should be 1. Question 2 (Column f); on the similar line as previous question I need to find out how many times the particular end customer id has occurred between “*First Review Date”* and “*Second Review date”* using Review Sheet tab. For example : end customer id “1-168WAQL” occur once between *First Review date* (7/31/2011) and *Second Review date* (2/29/2012) so the output in column F should be 1. Sample data is attached for reference. Note : date format is MM/DD/. -- Regards, AK -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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$$ lookup based on multiple dates.
Hi, please see the attachment. On Mon, Dec 3, 2012 at 8:10 PM, AK exce...@gmail.com wrote: Hi All, I have a question, looking for solution through formula (but VBA is fine if not possible through formula :) )...I have 2 sheets in a workbook i.e Cust data and Review... In the Cust data sheet I have start date of the project i.e column B, column C is First review date and Column D is second review date of project and Review Sheet is the lookup table Question 1 (Column E): I need to find out how many times the particular end customer id has occurred between “Start date” and “First Review date” using Review Sheet tab. For example : end customer id “1-168WAQL” occured once between Start date (3/1/2011) and First Review date (7/31/2011) so the output in column E should be 1. Question 2 (Column f); on the similar line as previous question I need to find out how many times the particular end customer id has occurred between “*First Review Date”* and “*Second Review date”* using Review Sheet tab. For example : end customer id “1-168WAQL” occur once between *First Review date* (7/31/2011) and *Second Review date* (2/29/2012) so the output in column F should be 1. Sample data is attached for reference. Note : date format is MM/DD/. -- Regards, AK -- 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. -- ** * Best Regards, Ms Excel User * ** -- 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. Sample Data _AK (Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
