Good Morning
I would like to transfer this formula to a macro, any help with this would be myuch apreciated
=IFERROR(INDEX('[Holidays 2014_2015.xlsm]Holidays'!$E$13:$E$300,SMALL(IF(""=OFFSET('[Holidays 2014_2015.xlsm]Holidays'!$O$12,1,MATCH($B$4,'[Holidays 2014_2015.xlsm]Holidays'!$P$12:$NS$12,0),ROWS('[Holidays 2014_2015.xlsm]Holidays'!$E$13:$E$300)), ROW('[Holidays 2014_2015.xlsm]Holidays'!$E$13:$E$300)-ROW('[Holidays 2014_2015.xlsm]Holidays'!$E$13)+1, ""), ROW(A1))),"")
Bookmarks