Help with array formula

76chickens

New Member
Joined
Apr 27, 2015
Messages
14
Looking for advice on array formulas.
I'm a school teacher making a spreadsheet for my school that plots children's progress in different subjects across the year. Someone helped me write this formula which I have been able to apply to different terms in the same subject (columns A:N in one table per term). What I am struggling with is adapting the formula for the tables where data is represented in columns P:AC. My array formulae are gathering the data correctly, displaying accurately but I can't get it to be in the right place. What part do I need to tweak to get the information to show in columns P:AC??
=IFERROR(INDEX(names,SMALL(IF(A$3=RscoresBaseline,ROW(names)-4,""),ROW()-3)),"")
Thanks in advance from a teacher with no Excel training who is working it out as I go along thanks to the kindness and support of members of this group... I love you guys!!
❤️
❤️
❤️
❤️
❤️
 

Attachments

  • 82492414_10156997706667633_7662483958306701312_n.jpg
    82492414_10156997706667633_7662483958306701312_n.jpg
    66.6 KB · Views: 15
  • 101602466_10156997399612633_6239802614469361664_o.jpg
    101602466_10156997399612633_6239802614469361664_o.jpg
    154.2 KB · Views: 14
RScoresBaseline is set to $BS$5:$BS$34 which is the range for WScoresBaseline. RScoresBaseline is actually in $BO$5:$BO$34. Once corrected, your formula should work.

Just so you know for later, the #REF! errors that you said to ignore are a consequence of using right click and delete.
Thanks, that's worked, always right under my nose when I'm looking for something more complicated! Sorry for the delay replying, I replied last night but I think there was site maintenance taking place.
 
Upvote 0

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top