Minimum Count

[rodewala]

Here is my situation.....I have a set of data 4 rows long and 4 columns wide. For example,
lets say my data is:
4 6 5 5
3 4 5 2
4 3 6 4
2 5 4 6

With that being columns A-D and rows 1-4, I would like a formula for Column E row 1 that would give the number of times that row contains a unique minimum for that row. For example, Row 1 would yield "0" as it has no unique minimums, Row 2 would yield "1" as 2 is the absolute minimum in column D, Row 3 would yield "1" as 3 is the minimum of column B, and Row 4 would yield "2" as both 2 and 4 are unique minimums of columns A and C. Sorry for the repetition, just wanted to give an example......If anyone has any advice I would appreciate it....Thanks.

Drew

[daddylonglegs]

Hello Drew, thanks for changing the thread title.

Try this formula in E1 copied down

=SUMPRODUCT((COUNTIF(OFFSET(A$1:A$4,0,COLUMN(A1:D1)-COLUMN(A1)),"<="&A1:D1)=1)+0)