Count number of times when data is highest among a column

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