Hey Everyone, I have a spreadsheet that lists a list of applications for
every department. I have duplicate entries for departments and multiple
entries for applications in each department. What is the best approach to
narrow this down to 1 application PER department. I want to visit each dept
and show them the applications they are using.

Is this possible using excel?

Thanks in advance.
Alex