Assuming I have a drop-down box in A1 with a list of the subjects in the grid below, how would I return the bottom three values for that subject in B1, B2 and B3? I'm not able to use a pivot table for this - it needs to be a formula, please. If there are duplicate values, they should not be ignored. My table is longer with values ranging from 3 to 8.
Excel 2016 (Windows) 32 bit
JC JD JE JF JG JH JI JJ JK JL JM JN 3 Academic PE Art Biology BTEC IT Business Studies Chemistry Classical Civilisation Drama Design Technology Economics English Literature English Language 4 5 5 5 5 6 7 8 8 7 9 7 10 4 11 5 5 12 4 4 13 4 14 5 6 15 7 6 7 16 5 17 6 3 18 7 5 19 4 4 20 6 6 6 21 7 7
Sheet: Pupils Dashboard
Bookmarks