SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2801074%22%20slang%3D%22en-US%22%3EHow%20do%20I%20get%20highest%20CTR(CTR%20%3D%20clicks%2Fimpressions)%20given%20columns%20for%20clicks%20and%20impressions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2801074%22%20slang%3D%22en-US%22%3E%3CP%3EGiven%202%20columns%20with%20161%20rows%20of%20data%20for%20clicks%20and%20impressions%20of%20a%20campaign%2C%20I%20am%20trying%20to%20find%20highest%20ClickThroughRate(CTR%3Dclicks%2Fimpressions%3CSTRONG%3E)%3C%2FSTRONG%3E%20of%20all.%20How%20do%20I%20do%20it%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2801074%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2801126%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20get%20highest%20CTR(CTR%20%3D%20clicks%2Fimpressions)%20given%20columns%20for%20clicks%20and%20impressions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2801126%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1171747%22%20target%3D%22_blank%22%3E%40Izzy90%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20clicks%20are%20in%20A2%3AA162%20and%20impressions%20in%20B2%3AB162.%3C%2FP%3E%0A%3CP%3EUse%20the%20following%20formula%2C%20confirmed%20with%20%3CSTRONG%3ECtrl%2BShift%2BEnter%3C%2FSTRONG%3E%20to%20turn%20it%20into%20an%20%3CSTRONG%3Earray%20formula%3C%2FSTRONG%3E%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DMAX(A2%3AA162%2FB2%3AB162)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2801150%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20get%20highest%20CTR(CTR%20%3D%20clicks%2Fimpressions)%20given%20columns%20for%20clicks%20and%20impressions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2801150%22%20slang%3D%22en-US%22%3EIt%20worked.%20That%20was%20easy.%20Thank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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)