Add a (hidden) column, where you calculate remark group for every entry depending on what is entered as remark. Then you can use this column as last condition.
Of-course this works only, when a remark belongs to single group. I suspect you may want to filter on specific strings in Remark field. When this is case, you have to make the hidden column dynamic based on come general counting criteria you/user select(s) on worksheet.
|