Hi
I have asked for a formula in another thread and it was answered very nicely (here : https://www.excelforum.com/for-other...ml#post5711860).
But problem with the formula is that, I will be needing to add more and more numerical colomns. So my question regarding the given formula below is :
=INDEX(Sheet2!A:A,-MOD(LARGE((Sheet2!$B$1:$C$1=$A2)*Sheet2!$B$2:$C$10*10000-ROW($2:$10),COUNTIF($A$2:$A2,$A2)),-1000))
- If it is notably as $B$1:$C$1 and $B$2:$C$10, then how is the formula will looks like if I adds more colomn (sheet2 - colomn D) and more rows (sheet2 - A11:D18)?
I may needed the rows to be infinite actually.
Refers here :
https://www.excelforum.com/for-other...ml#post5711860
The sheet is here :
https://docs.google.com/spreadsheets...IOo/edit#gid=0
Thank you
@wk9128
Bookmarks