Sep 30 2021 02:33 PM - edited Sep 30 2021 02:40 PM
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 approaches without creating a new column for CTR and running MAX function on it.
Sep 30 2021 02:43 PM
SolutionLet'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)
Sep 30 2021 02:59 PM
Sep 30 2021 03:29 PM
Sep 30 2021 02:43 PM
SolutionLet'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)