Hi All, looking to change this formula from an array to NOT array formula:
The purpose of the formula is to retrieve all values in $H on '2018CSV' in a list according to the $A$9 value. But since it's an array formula I cannot reorder the rows.
=IFERROR(INDEX('2018CSV'!$H$1:$H$100000,SMALL(INDEX(($A$9='2018CSV'!$A$1:$A$100000)*(MATCH(ROW('2018CSV'!$A$1:$A$100000), ROW('2018CSV'!$A$1:$A$100000)))+($A$9<>'2018CSV'!$A$1:$A$100000)*1048577,),ROWS('2018CSV'!$A$1:A1))), "-")
Any help would be awesome.
Thanks!
Bookmarks