Hi,
I know how to use Advance filter but would like to extract using a formula which will automatically extract unique values between Column A (Client Name) and Column D (Policy Name)
I also need to find out the Longest and shortest duration based on column A and Column D from Column G (Duration). If there is only one Client Name then both will have same time. Please refer to attachment for raw data and result the management would like to have.
This is just a sample data but there are 300,000 over records to compare from 3 different files (divided by month). Is there a way to check the other files as well?
Really need your expertise to solve this issue. Thank you.
Bookmarks