I have created an array and from which I wish to select all instances of a string (entered in $A$304 in that array.
I need help in adjusting the following array formula to ignore any blank cells it finds in the array
{=INDEX($B$1:$AU$302,SMALL(IF($B$1:$AU$302=$A$304*($B$1:$AU$302<>""),ROW($B$1:$AU$302)-ROW(INDEX($B$1:$AU$302,1,1))+1),1))}
Are you able to guide me in the right direction please?
Regards Bryce
Bookmarks