Hi All,
I am trying to design a formular, I have a list of products with its descriptions. Also I developed a function called similarity which determine two cells similartity %.
So Now I have a list of new products and old products list with its functions. Is it possible in B15 and B16 to use a formular like =Index(B2:B7, Match(max(xx,Similarity(A:A)) and then in cell C15 & C16 Showing their percentage? Should we get the max % first and then work on its function?
My similarity function is simple say =Similarity(A2,A15) = 70% or =Similarity(A3,A15) = 65% as an example or should we work out a formular to come up with maximum similarity % first?
<tbody>
</tbody>
Thanks,
Peter
I am trying to design a formular, I have a list of products with its descriptions. Also I developed a function called similarity which determine two cells similartity %.
So Now I have a list of new products and old products list with its functions. Is it possible in B15 and B16 to use a formular like =Index(B2:B7, Match(max(xx,Similarity(A:A)) and then in cell C15 & C16 Showing their percentage? Should we get the max % first and then work on its function?
My similarity function is simple say =Similarity(A2,A15) = 70% or =Similarity(A3,A15) = 65% as an example or should we work out a formular to come up with maximum similarity % first?
A | B | C | |||||||||
1 | Product Name | Function | |||||||||
2 | AA | Building | |||||||||
3 | BB | entertainment | |||||||||
4 | CC | Travel | |||||||||
5 | DD | Stationery | |||||||||
6 | EE | Tools | |||||||||
7 | FF | Phone | |||||||||
8 | |||||||||||
9 | |||||||||||
10 | |||||||||||
11 | |||||||||||
12 | New Product List | ||||||||||
13 | |||||||||||
14 | Name | Function | Max Similarity % | ||||||||
15 | GG | ||||||||||
16 | HH | ||||||||||
<tbody>
</tbody>
Thanks,
Peter
Last edited: