Hi, Everyone.
i've been looking a formulo for so long but found nothing, i really appreciate your help.
i'm trying to make a lists indexing a column that contain labor numbers and each labor contain multiple Materials, the formula work for the first Labor Selected but no continue to the next cell
The array formula is
{=IFERROR(INDEX($A$2:$B$19,SMALL(IF($A$2:$B$19=$I$2,ROW($A$2:$B$19)-1),ROW(A1)),2),"")}
thanks to every
sorry if this was solved on another Thread.... i make some search but not found.
Bookmarks