Super Great job done working 100%. great knowledge you have.=IFERROR(INDEX(Data!A:A,AGGREGATE(15,6,ROW(Data!B$2:B$23)/(Data!B$2:B$23=B$2)/(INDEX(Data!C$2:K$23,0,MATCH(C$2,Data!C$1:K$1,0))=1),ROW(A1))),"")
this not working proper only showing 1 eng name other not=FILTER(Data!A2:A23,(INDEX(Data!A2:K23,0,MATCH(Result!C2,Data!A1:K1,0))=1)*(Data!B2:B23=B2),"no-one")
So FILTER isn't available to you - OK.this not working proper only showing 1 eng name other not
thanks for your reply , but not working here may be some other issue
Ashmee | Pronunciation/MTI | Eng Name |
Dhruv Kumar | ||
Dhruv Kumar | ||
Dhruv Kumar | ||
Dhruv Kumar | ||
Dhruv Kumar |