I'm at my wit's end here. I have a table with a number of columns. Of 3 specific columns, I need to find the amount of times each column shows the lowest number of the 3 columns, for each row. . For example:

Column 1 Column 2 Column 3
25 18 12
11 20 22
13 28 14
19 15 17
17 21 23
24 9 11


I have to show how many times each column shows the lowest number in each row. For instance, Column 1 shows the lowest number for 3 rows. Column 2 shows the lowest number for 2 rows. And, column 3 shows the lowest number for 1 row. I hope it makes sense.

I just need to show each one on a pivot table. So, I'm not sure if this would be a function I enter from the original data, or if it's certain setting once the pivot table is set up. But, any help would be great!!