Help Counting Number of Times a Column is highest value

Hi guys,
Gettingexcelhelp.PNG
I'm an excel noob!
I am building a monte carlo sim, now I need to count how many times the value in column 1,2,3,4,5,6,7,8 is highest
What formula would I need to do that

Thanks so much in advance!

Hi

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.

Thanks so much for explaining the forum expectations

Ok, I have uploaded my document

What I am looking to achieve is for N5, find the amount of times the value in column B is the highest number across the 10 rows , as Ive typed in the worksheet
Then I want to repeat the process for all 10 numbers.

Thanks so much if you can help!

Hi

I have created 10 columns of help with the following formula.

Formula:

Please Login or Register  to view this content.

The formula indicates the order of each line element.

This way you can count how many times a particular column is referred to with the value 1 (the highest value) or 2 (the second highest value), ....
I hope this helps you!

See the file (I cut some values)

Thank you so so much guys, much appreciated