Anne Troy wrote:

NO extra (blank) rows and NO extra (blank) columns in the data. If you
delete a name, delete the entire row, not just the contents of the cells.
When you have blank rows or columns WITHIN your data, the sort ranges
CHANGE.

Thanks. I know the leave some of the various categories blank for
different clients. Will that apply in any row? perhaps they should just
leave a character in there for unknown or NA.

And it is possible that they might accidentally delete names. I don't
think they leave any of those blank intentionally, but it wouldn't
surprise me if they click on it, and then do something else, not
realizing the error.