How do I get highest CTR(CTR = clicks/impressions) given columns for clicks and impressions

Given 2 columns with 161 rows of data for clicks and impressions of a campaign, I am trying to find highest ClickThroughRate(CTR=clicks/impressions) of all. How do I do it? I am looking for approac...

excel

Formulas and Functions

Macros and VBA

HansVogelaar
Sep 30, 2021
Izzy90

Let's say clicks are in A2:A162 and impressions in B2:B162.

Use the following formula, confirmed with Ctrl+Shift+Enter to turn it into an array formula:

=MAX(A2:A162/B2:B162)