Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,180
- Office Version
- 365
- 2019
- Platform
- Windows
Basically what I have is a breakdown in test scores 1 = got answer right 0= got answer wrong. I am trying to do some item analysis. I want to split up the scores counting the top 33.3% and the bottom 33.3% which I have done using the formulas
=COUNT(SMALL(B8:K8,ROW(INDIRECT("1:"&INT(COUNT(B8:K8)*33.3%)))))
and
=COUNT(LARGE(B8:K8,ROW(INDIRECT("1:"&INT(COUNT(B8:K8)*33.3%)))))
They both came back with a count of 3.
Now what I am trying to do is to find out which headings are they refering to?
All hypothetical below (Example)
For the top
i.e Q3, Q2, Q7????
and for the bottom
Q9, Q1, Q4???
Hope this makes sence. Thanks in advance Stephen.
=COUNT(SMALL(B8:K8,ROW(INDIRECT("1:"&INT(COUNT(B8:K8)*33.3%)))))
and
=COUNT(LARGE(B8:K8,ROW(INDIRECT("1:"&INT(COUNT(B8:K8)*33.3%)))))
They both came back with a count of 3.
Now what I am trying to do is to find out which headings are they refering to?
All hypothetical below (Example)
For the top
i.e Q3, Q2, Q7????
and for the bottom
Q9, Q1, Q4???
Hope this makes sence. Thanks in advance Stephen.