LinkBack URL
About LinkBacks
I6=INDEX(Data!J$4:J$48,MATCH(LARGE(INDEX(((Data!$M$4:$M$48)+1/(ROW(Data!$M$4:$M$48)*10^10))*(Data!$I$4:$I$48=$M$4),0),$H6),INDEX(((Data!$M$4:$M$48)+1/(ROW(Data!$M$4:$M$48)*10^10))*(Data!$I$4:$I$48=$M$4),0),0))
Try this and copy across
I6=INDEX(Data!J$4:J$48,MATCH(LARGE(INDEX(((Data!$M$4:$M$48)+1/(ROW(Data!$M$4:$M$48)*10^10))*(Data!$I$4:$I$48=$M$4),0),$H6),INDEX(((Data!$M$4:$M$48)+1/(ROW(Data!$M$4:$M$48)*10^10))*(Data!$I$4:$I$48=$M$4),0),0))
Try this and copy across
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks