Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Row Count
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Row Count
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single Row Count
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count based on single number | Excel Worksheet Functions | |||
Count if on Single Criteria with multiply conditions | Excel Worksheet Functions | |||
get a single count after looking up a set of values | Excel Worksheet Functions | |||
count of tab characters in a single cell | Excel Worksheet Functions | |||
COUNT.IF, how to include single cells | Excel Worksheet Functions |