This worked!

Thanks!

"Gary''s Student" wrote in message
...
Consider using a Pivot Table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200764


"Alex Cohen" wrote:

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