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!!
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!!