Use this matrix formula![]()
=IF(COUNTIF(B$2:B$44;L6)>0;LARGE(IF(B$2:B$44=L6;F$2:F$44);2);"")
Use this matrix formula![]()
=IF(COUNTIF(B$2:B$44;L6)>0;LARGE(IF(B$2:B$44=L6;F$2:F$44);2);"")
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks