Count the number of times one thing is minimum

[#1]

Hi

I have data which looks as below

Item Number	A	B	C
1	100	300	600
2	200	300	500
3	300	300	400
4	400	300	300
5	500	300	200

I want to have something which says what percentage of the time each shop (A,B and C) is cheapest, so a table which looks like this

Shop	%cheapest
A	60%
B	40%
C	40%

I know you can use RangeMin(A,B,C) to get the cheapest price for each item and could probably do so kind of IF statement to count for each shop whether its prices equals the rangemin but I actually have about 50 shops so that would take a long time

Any help would be greatly appreciated.

[Gysbert_Wassenaar]

See attached qvw

[#3]

Thanks Gysbert

While this works I also want to be able to select just shops B and C and have the % cheapest recalculated which I don't think this will do.