What you will find attached is a sample of data from a pivot table. There are several ID numbers (BA1008, BA10010, etc), each of which is associated with 1 or more dates. I would like to accomplish 2 tasks:
1- include only oldest date for each unique member ID
2- determine the number of days between the most recent and oldest dates for each unique member ID
Top (bold) output= ID in rows and date in values. If I attempt to change count to MIN I get a "0" value for each ID- same thing happens if I change count to MAX. The formatting of the date values in the original dataset has been set to "date".
Bottom (not bold) output= both ID and date in the values section
Hopefully my query is clear- these things are difficult to describe sometimes
Bookmarks