LinkBack URL
About LinkBacks
Is there a way that we don't hard core the columns {1,3,5} ?Originally Posted by wk9128
Cell J3 formula , Drag down
Formula:
=INDEX($B:$F,SMALL(IF($A$2:$A$15=$I3,ROW($2:$15)),TRANSPOSE(ROW($1:$3))),{1,3,5})
Is there a way that we don't hard core the columns {1,3,5} ?Cell J3 formula , Drag down
Formula:=INDEX($B:$F,SMALL(IF($A$2:$A$15=$I3,ROW($2:$15)),TRANSPOSE(ROW($1:$3))),{1,3,5})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks