Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a report that lists the following columns:
Month Port# Name April 123 Smith April 123 Smith April 234 Smith April 345 Taylor April 456 Taylor May 567 Cox I need a summary report from this that counts for each month and name how many occurences. However, if the port# field is the same it counts it once. So for April, Smith would have 2, Taylor would have 2. I tried to use a PivotTable, but can't figure out how to not get it to count 123 twice. Any suggestions would be greatly appreciated. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spreadsheet Summary Report | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Summary Report (OLAP kind) | Charts and Charting in Excel | |||
How to create summary of expense report? | Excel Worksheet Functions | |||
Can I create an order summary report in Excel? | Excel Worksheet Functions |