E3try this and copy across![]()
=if(columns($e3:e3)>sumproduct(countif($b3,"*"&$k$6:$k$9&"*")),"",index($k$6:$k$9,match(small(index(search($k$6:$k$9,$b3&""&$k$6:$k$9),0),columns($e3:e3)),index(search($k$6:$k$9,$b3&""&$k$6:$k$9),0),0)))
E3try this and copy across![]()
=if(columns($e3:e3)>sumproduct(countif($b3,"*"&$k$6:$k$9&"*")),"",index($k$6:$k$9,match(small(index(search($k$6:$k$9,$b3&""&$k$6:$k$9),0),columns($e3:e3)),index(search($k$6:$k$9,$b3&""&$k$6:$k$9),0),0)))
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)
Bookmarks