Hi,
In the attached workbook I am trying to perform an INDEX/MATCH type calculation to return 1 ... nth occurrence into separate columns for these.
How can this be done using dynamic array functions that yields a spill range for each (or one spill range for all)?
Best regards,
Marbleking
Bookmarks