can you describe what you mean by group?
Perhaps you could provide an example file.
i never saw your sample sheet.
Did you upload here. Note all I see from you is.
"In an excel spreadsheet which formula should be used to group department ID numbers?"
"I haven't yet received an answer to my question."
"I sent a sample spreadsheet along with additional information."
It would be difficult to provide an answer without first seeing an example of what you would like to do.
you requested a call. did you mean to do that?
well, I don't know what you want.
not sure why I am not seeing your replies
If you reply here I can help you further.