After you filter the rows in a list, you can use the AGGREGATE function to count the visible rows. This function was introduced in Excel 2010, and is similar to SUBTOTAL, but it has 19 functions, compared to SUBTOTAL's 11 functions.
A Medical Social Worker is a social worker who works in a medical setting such as a hospital, outpatient clinic, hospice, long-term care facility, or community health agency.
social worker a professional trained in the treatment of psychosocial problems of patients and their families. Family social workers practice social case work. Psychiatric social workers practice various forms of counseling and group or individual psychotherapy. Most social workers have a master's degree in social work (M.S.W.). There are also bachelor's (B.S.W.) and doctoral (D.S.W.) degrees in social work.