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: