THANK YOU RON!

Well yes!thats a big help..which got me wondering is there a way to do it
without using a pivot table..n perhaps even maintaining the result in
another sheet within the same workbook?