I need to count how many times a row had the smallest number in a column

[Dliu22]

So I have a fairly large sheet of data. Roughly 100 rows and 1000 columns of data. I need to count how many times a row had the smallest number in THAT column.
I'm familiar with the Countif function but I'm not sure how to configure it to count the smallest number for multiple columns.

[bebo021999]

Assum row A6:H6
smallest number: SMALL($A$6:$H$6,1)
then countif:

=COUNTIF($A$6:$H$6,SMALL($A$6:$H$6,1))

I guess thing might be more complicated, but just give a shot.

[Dliu22]

Assum row A6:H6
smallest number: SMALL($A$6:$H$6,1)
then countif:

=COUNTIF($A$6:$H$6,SMALL($A$6:$H$6,1))

I guess thing might be more complicated, but just give a shot.

hmmm.... every row spat out an answer of 1. that can't be right

[bebo021999]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Dliu22]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ok sorry. I whipped up a quick example. Each column is a simulation. Each row is a person. I need to know how many times each person posted the lowest number in a simulation.

[bebo021999]

Try in L2:

Please Login or Register  to view this content.

[Dliu22]

that worked! What changes would I need to make it for each row. example L3 thru L7?

[Dliu22]

I believe this will work. THank you! I'm testing it now

[Dliu22]

I appear to have made an error converting over to my chart. I copied a small portion for you to see.

[bebo021999]

Actual table starts from column B (the sample starts from column A), then new sequence numbers range should be:
COLUMN($B:$F)-COLUMN($B:$B)+1
instead of COLUMN($B:$F)

G11:

Please Login or Register  to view this content.