I have solved a problem here with someone but when i am implementing the formula on my excel 2016 professional i am getting error, There is a problem with the formula not trying to type the formula
the formula i have written is same as provided by your support tech, and it is working fine on the above link i provided for google sheet.. so i am wondering why it is showing error on my excel installed on my laptop.
The error is on this formula
=INDEX(Sheet6!$D3:$D, SMALL(IF($B$3=Sheet6!E:E, ROW(Sheet6!E:E)-ROW($A$3)+1), ROW(1:1)))
and i found the error is on array provided INDEX(Sheet6!$D3:$D as it is focusing on $D...so any solution pleaase
Solved by X. F. in 12 mins