Hi excel experts,
In sheet1 in column A i have a list of so numbers and in column s and T i have Subscription Starting Date and Subscription End Date
in sheet2 in column A i have a list of unique so numbers.What I would like to do is this:in sheet2 in column I i want newest date from
sheet2 from column S and also in j column in sheet2 i want oldest date from sheet2 from column T for particular so number.
E.G=When i apply filter in sheet1 using frist so number present in sheet2 (99A/15-16/787407) in range A1 then i found multiple dates from these multiple dated
i want newest date(4/1/2016) from s column and oldest date from T column.
Please find the attached sample file.
sheet1 having raw data and sheet2 having output data.
Regards
Bookmarks