Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have just been given a task of producing an asset list The list compile and habded to me has Two Colums Column A is the site wher ethe asset is sited Column B is the Model Number of the Asset I need to be able to sort this list into Model Numbers and the produce a total of how many of each serial number we have across our sites, Any ideas how to accomplish this, |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Look at using DataSubtotals
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "flumpuk" wrote in message ps.com... Hi I have just been given a task of producing an asset list The list compile and habded to me has Two Colums Column A is the site wher ethe asset is sited Column B is the Model Number of the Asset I need to be able to sort this list into Model Numbers and the produce a total of how many of each serial number we have across our sites, Any ideas how to accomplish this, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count occurances | Excel Discussion (Misc queries) | |||
Count consecutive occurances | Excel Worksheet Functions | |||
Count Occurances of String in a Column? | Excel Discussion (Misc queries) | |||
Count occurances Problem | Excel Worksheet Functions | |||
Counting multiple occurances of a specific string | Excel Worksheet Functions |