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.
Some aspiring social workers complete a one- or two-year master's degree on top of their undergrad. Licensed clinical social workers are usually required to have a master's degree. Some states make exceptions for those who work for government agencies. On top of the advanced degree, a clinical social worker also normally needs to spend two years or 3,000 hours working in a supervised environment. Learn more about Career Aspirations Sources: