Excel Experts, I need your help. I have a spreadsheet where I have unique ID, Log Types, and a Key Value. The Key Value represents a Boolean code (1,0) that suggests the Log Type equals the data I want to analyze. I want to take the most recent date for each unique lead ID where the key value = 1.
If you copy and past the data into a spreadsheet, it should deliminate correctly. In this example, I have 4 unique lead ID's but many rows of data. Lead 994469 should have a date of 11/19/2011, Lead 994500 should have 11/16/2011, Lead 994610 should have 11/18/2011 and Lead 994626 should have 11/14/2011. Any help would be greatly appreciated!!!! Id Log Type Log Date Key Value 994626 Left VM 11/22/2011 0 994626 TP - College Transcript Request Form (CCC) 11/21/2011 0 994626 TP - HS Transcript Request Form (CCC) 11/21/2011 0 994626 TP - FERPA (CCC) 11/21/2011 0 994626 TP - GHE Permission Form (CCC) 11/21/2011 0 994626 TP - Application (CCC) 11/21/2011 0 994626 CCC Application Email Sent 11/19/2011 0 994626 Interview Complete 11/19/2011 1 994610 Left VM 11/21/2011 0 994610 SS - AC/TP Comments 11/18/2011 0 994610 SA Comments 11/18/2011 0 994610 FA Comments 11/17/2011 0 994610 TP - College Transcript Request Form (CCC) 11/17/2011 0 994610 TP - HS Transcript Request Form (CCC) 11/17/2011 0 994610 TP - FERPA (CCC) 11/17/2011 0 994610 TP - GHE Permission Form (CCC) 11/17/2011 0 994610 TP - Application (CCC) 11/17/2011 0 994610 CCC Application Email Sent 11/16/2011 0 994610 Interview Complete 11/16/2011 1 994500 FA Comments 11/22/2011 0 994500 FA Comments 11/21/2011 0 994500 Spoke to Prospect 11/18/2011 1 994500 FA - FAFSA (CCC) 11/14/2011 0 994500 FA - Estimate Signed (CCC) 11/14/2011 0 994500 Spoke to Prospect 11/14/2011 1 994500 SA Comments 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 SS - AC/TP Comments 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 TP - HS Transcript Request Form (CCC) 11/14/2011 0 994500 TP - FERPA (CCC) 11/14/2011 0 994500 TP - GHE Permission Form (CCC) 11/14/2011 0 994500 TP - Application (CCC) 11/14/2011 0 994500 FA Comments 11/14/2011 0 994500 FA Comments 11/14/2011 0 994500 SA Comments 11/14/2011 0 994500 CCC Application Email Sent 11/14/2011 0 994500 Interview Complete 11/14/2011 1 994500 Spoke to Prospect 11/14/2011 1 994500 Left VM 11/11/2011 0 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
