Counting rows with minimums

[brakiachi]

Can't think of a good way to do this.
I have table with about 200 columns and rows.
What I would like to do is count how many instances in a column that a minimum for a exists.
A simplified version of this would be

1	2	3	4
2	3	4	1
1	3	2	4
2	2		1

What I want is a formula that for column a, would return 2 (A1 is minimum for row 1, A3 is minimum for row 3), column b would return 0, column c would return 0, column d would return 2 (D2 in minimum for row 2, D4 is minimum for row 4)

I have tried doing a conditional formatting that highlights the minimum for each how, and then using a UDF to count the number of instances that color appears in a column, but I can't figure out how to get the UDF to count cells that are colored by conditional formatting. And I can't think of a way to get a countifs to work without having about 200 criteria (a criteria for each row). I'm certain there is any easy way to do this.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[brakiachi]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

2010. My profile should be updated now

 

[Fluff]

Ok, thanks for that, try

+Fluff 1.xlsm
	A	B	C	D	E
1
2	1	2	3	4	5
3	2	3	4	1	7
4	1	3	2	4	0
5	2	2		1	2
6
7	1	0	0	2	1
Master

Cell Formulas
Range	Formula
A7:E7	A7	=SUM(--(A$2:A$5=SUBTOTAL(5,OFFSET($A$2,ROW($A$2:$E$5)-ROW($A$2),,,COLUMNS($A$2:$E$5)))))

It may need to be array entered in your version of xl.

 

[brakiachi]

Perfect. That works. I don't quite understand what the offset is actually doing though, but it works. Thank you

 

[Fluff]

You're welcome & thanks for the feedback.
The subtotal returns the minimum value for each row.