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.
Get Credentialed. Social workers must obtain at least a bachelor's degree for some positions and a master's degree for others. To work in a clinical environment, such as a hospital, you typically need a master's degree and either two years or 3,000 hours of clinical experience.ocial workers help clients adapt to change and overcome challenges. You advocate for resources, assess needs and monitor the effectiveness of treatment. This requires compassion, dedication and time, and many new social workers tend to immerse themselves fully in their clients' cases. This can lead to burnout, however.