Excel PivotTables and QI Macros

If you have comment fields filled with text, use Excel's COUNTIF function. COUNTIF will count the number of times a text expression occurs in a range of cells. The following data shows comments about insurance billing problems. Maybe we’d like to know how many are related to Medicare or how many are related to overlapping dates of stay (DOS). The ................
................

In order to avoid copyright disputes, this page is only a partial summary.