In Column A I have a date I did work for a customer.
In Column B I have the customer Area.
In Column C I have the customer #.
Now in Column E & F I have the Area & customer #.
In Column G I want to find the oldest date based on the customer # in the Area.
In Column H I want to find the newest date based on the customer # in the Area.
Some times the oldest date and newest date will match if I only worked for the customer once.
I know I can sort, to figure this out, but these figure are in different books.
I need to find these dates without opening multi books and sorting and retyping dates.
Bookmarks