Forum Discussion
Solved
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 approaches without creating a new column for CTR and running MAX function on it.
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)
3 Replies
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)
- It worked. That was easy. Thank you 🙂
- Would you please help me with the other question I have in here
https://techcommunity.microsoft.com/t5/excel/find-cost-per-1000-impressions-over-first-10-days/m-p/2801179
Thanks in advance 🙂
