leefletcher
New Member
- Joined
- Mar 22, 2018
- Messages
- 27
- Office Version
- 2019
- Platform
- Windows
I have searched all over for a solution to this and I am beyond flummoxed. Don't let me down...
My data is in two columns (Diagnosis and Date) and I need to know the 1st - 3rd most common Diagnoses within a particular date range.
Diagnosis Date
Autism 1/31/18
Down's Syn 12/5/17
Asthma 12/12/17
ID 1/4/18
Autism 1/2/18
Autism 12/5/17
Asthma 12/2/17
Down's Syn 1/17/18
Autism 1/8/18
Autism 1/3/18
Down's Syn 12/15/17
Asthma 12/2/17
ID 1/6/18
Autism 1/21/18
Autism 12/15/17
Asthma 12/12/17
Down's Syn 1/1/18
Autism 1/8/18
Most common diagnosis in January?
2nd most common diagnosis in January?
3rd ....?
My data is in two columns (Diagnosis and Date) and I need to know the 1st - 3rd most common Diagnoses within a particular date range.
Diagnosis Date
Autism 1/31/18
Down's Syn 12/5/17
Asthma 12/12/17
ID 1/4/18
Autism 1/2/18
Autism 12/5/17
Asthma 12/2/17
Down's Syn 1/17/18
Autism 1/8/18
Autism 1/3/18
Down's Syn 12/15/17
Asthma 12/2/17
ID 1/6/18
Autism 1/21/18
Autism 12/15/17
Asthma 12/12/17
Down's Syn 1/1/18
Autism 1/8/18
Most common diagnosis in January?
2nd most common diagnosis in January?
3rd ....?