I have a report that groups by response level then by department. Due to our directory structure our departments are not standardized. I have for example MIS, MIS Application Support, MIS Operations, etc.., what i would like to do is create a formula that would group and count all department fields that contain "MIS" and group them into a title group of MIS with total number of times it was listed. What will be best way to do this? Any information will be greatly appreciated.

Edited by jessecar - 07 Apr 2009 at 9:05am

NOte that the above assumes you do not have any non MIS departments that start with the string of "mis" like "mistake department" or "misery department".