Hi all,
I have an array formula which looks up data from within the range AA219:AA2217
What I would like is that this formula works in the same way but every other row and not consecutive rows
If I use this formula and drag down it works fine, but if I use this formula every other row it misses out half the data I actually need it to show
=IF($R$2<>"",IFERROR(INDEX($AF$219:$AF$2217,SMALL(IF($AA$219:$AA$2217=$R$2,ROW($AA$219:$AA$2217)-ROW($AA$219)+1),ROWS(B$10:B10))),""),"")
Many Thanks for any help
I have an array formula which looks up data from within the range AA219:AA2217
What I would like is that this formula works in the same way but every other row and not consecutive rows
If I use this formula and drag down it works fine, but if I use this formula every other row it misses out half the data I actually need it to show
=IF($R$2<>"",IFERROR(INDEX($AF$219:$AF$2217,SMALL(IF($AA$219:$AA$2217=$R$2,ROW($AA$219:$AA$2217)-ROW($AA$219)+1),ROWS(B$10:B10))),""),"")
Many Thanks for any help