I cant habituated in Excel

Hi I am not habituated in Excel and face a problem. If anyone help me This will be beneficial for me. I want to try the number of IDs numbers who are engaged in same kinds of department. So anyone he...