Comparison table

[yavoro]

Hi all,

I need fresh ideas on the following problem (please see the attachment):

I have list of prices from different companies for products (multiple prices for 1 product possible, because of partner companies, etc).

I want to count the number of times a competitor price is closest to my price where my price is best (rank 1).

But sometimes my company (partner) gives second best price as well, so I have to count third best price as a closest competitor one.

In the attached example I'm able to achive this when a product is selected. Table Closest Competitors would show what I want.But I don't know how to show the overall numbers.

Any ideas are welcome and much appreciated.

Thanks

Y

[lironbaram · Accepted solution]

hi

well i had to sleep on it

but here is an example of what you want

it uses first sorted value

hope it helps you

[yavoro]

Thanks Liron, that works for me perfectly!

[lironbaram]

hei y

so please make this case as answered on so other can know that this question have an answer