How can get the index of a cell next to the cell satisfiying the condition, but the cell row ( or col.) is not constant.
Thank you for your help.
How can get the index of a cell next to the cell satisfiying the condition, but the cell row ( or col.) is not constant.
Thank you for your help.
Please try at F2
=IFERROR(INDEX(Sayfa1!$D$1:$I$33,AGGREGATE(15,6,ROW(Sayfa1!$D$3:$G$33)/(Sayfa1!$D$3:$G$33=$C$2),ROWS(F$2:F2)),MOD(AGGREGATE(15,6,ROW(Sayfa1!$D$3:$G$33)*10^6+COLUMN(Sayfa1!$D$3:$G$33)/(Sayfa1!$D$3:$G$33=$C$2),ROWS(F$2:F2)),10^6)-3+COLUMNS($F2:F2)),"")
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks