Book1.xlsx | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
1 | 5 | 1 | 3 | 4 | 2 | 6 | Ok | Not function | |||||||||||
2 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | CONCATENATE Address | CONCATENATE Value | ||
3 | 1 | Active | ABC111 | JFG1 | Test2 | Test3 | Test4 | Test5 | Test6 | Test7 | Test8 | Test9 | Test10 | Test11 | Test12 | $C3$K3$E3$H3$B3$M3 | ABC111 | ||
4 | 2 | Active | ABC222 | JFG2 | Test2 | Test3 | Test4 | Test5 | Test6 | Test7 | Test8 | Test9 | Test10 | Test11 | Test12 | $C4$K4$E4$H4$B4$M4 | ABC222 | ||
5 | 3 | Active | ABC111 | JFG1 | Test2 | Test3 | Test4 | Test5 | Test6 | Test7 | Test8 | Test9 | Test10 | Test11 | Test12 | $C5$K5$E5$H5$B5$M5 | ABC111 | ||
6 | 4 | Active | ABC222 | JFG2 | Test2 | Test3 | Test4 | Test5 | Test6 | Test7 | Test8 | Test9 | Test10 | Test11 | Test12 | $C6$K6$E6$H6$B6$M6 | ABC222 | ||
7 | 5 | Active | ABC111 | JFG1 | Test2 | Test3 | Test4 | Test5 | Test6 | Test7 | Test8 | Test9 | Test10 | Test11 | Test12 | $C7$K7$E7$H7$B7$M7 | ABC111 | ||
Sheet1 |
=INDEX($B3:$O3,MATCH(MIN($B$1:$O$1),$B$1:$O$1,0))
Thank you.Profile was update excel 2019
I don't have 2019 to test with but you could try this.... if you find a solution for 2019
=CONCAT(INDEX(B3:O3,MATCH(ROW(INDEX(Q:Q,1):INDEX(Q:Q,COUNT(B$1:O$1))),B$1:O$1,0)))