SOLVED

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

Copper Contributor

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. 

3 Replies
best response confirmed by Izzy90 (Copper Contributor)
Solution

@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)

1 best response

Accepted Solutions
best response confirmed by Izzy90 (Copper Contributor)
Solution

@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)

View solution in original post