Quote Originally Posted by incidentals View Post

suggestion 1 ( programming aside ) a new column e is introduced and returns the countif() of the rest of the row.
This is the route I ended up taking. It's not as technically clean as I usually like to do things, but I simply picked the next unused column, filled it down with a "countA" formula, then set the text in that column to invisible and locked it for editing.

The macro knows it's there and uses the employee count from that column, but the end user (i.e. my employees) don't and never see it.

I'm convinced (without any real justification) that there is a way to do this programming-wise, but hell....if it works, it works.

I'll sleep at night, even though I know it's there.

Thanks for the suggestions.