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

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

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