Help Please on a formula that would count the 2 largest numbers in a row greater than 14?
Thank you.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
excel formula Countif and 2 largest numbers in a row
0
Discussion
Bmcmay.
Do you mean count them (2) or report the two largest values over 14?
Also. please modify your Profile to show which bersion of Excel you use.(Answers may vary with version)
Do you mean count them (2) or report the two largest values over 14?
Also. please modify your Profile to show which bersion of Excel you use.(Answers may vary with version)
John_Ru (rep: 6152) Dec 2, '21 at 11:30 am
Hi John,
I would like to count them(2).
Thank you,
JR
I would like to count them(2).
Thank you,
JR
bmcmay (rep: 2) Dec 2, '21 at 11:47 am
Answers
0
Selected Answer
Bmcmay
If you only want to count the two largest values in a range (C3:J3) if they are greater than 14 (so can only have answers 0, 1 or 2), this formula should work in all versions of Excel and isn't an array formula:
=IF(LARGE(C3:J3,1)>14,1,0) + IF(LARGE(C3:J3,2)>14,1,0)Look in the Excel Tutorials section for more on the LARGE function.
Hope this is okay for you.