Count number of times when data is highest among a column

hello everyone,

i am new here, and learning to use the advance excel functions.
currently i am stuck on a project where i am suppose to calculate each day, the number of times A is the highest against its competitors (B to L).

using the attached excel worksheet 0506-0512, i have grouped my data by channels, starting with A (row 107) where you can see daily stats by the hour. this is followed suit for other channels B to L as you scroll down.

i am trying to find out the number of times in a day where my channel, A, is the highest compared to channels B to L. similarly i wish to do it the other way round where i can see number of times where competitors is the highest compared to my channel but excluding zeros.

any kind souls can help me figure this out? or do i actually need to build MYSQL to do this?
much appreciate!

Hi
Please see attached solution.
Good Luck
Tony

Hi ARGK!

Thanks! Is it possible to build a criteria that excludes counting of those zeroes?
Thanks once again!

Hi
You can turn off the display of Zeros by following these steps:
1. Click on File > Options > Advanced.
2. Under "Display Option for this worksheet" untick the box that says "Show a Zero in cells that have zero value".
Good luck
Tony