answersLogoWhite

0


Best Answer

You could use the MAX function to find the highest and the LARGE function to find the second highest. You could combine them into one formula to show what those numbers were. Say your numbers are in the cells A2 to A5, then you could use the following formula:

=MAX(A2:A5)&" is the largest and "&LARGE(A2:A5,2)&" is the second largest"

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you find the best 2 greatest number out of 4 in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you find a greatest number of a number?

Which number is greatest?0.0990.2920.3810.413


How do you find scientific notation on excel?

You find scientific notation in Excel under the Format - Number menu.


Program to find the greatest number?

The greatest number is infinity.


How do you find 30 percent of number in excel?

Multiply the number by 0.3


What is a function to find the number of values in cells?

In Excel is it COUNT.


How can I find a greatest factor of 96?

The greatest factor of any number is the number itself.


What is a lookup list in Excel?

It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.It is a list that you can search through to find a value. There are a number of functions that can do lookups in Excel. See the related question below.


Where do you find the serial number for excel shotgun?

look on the breach, barrel.


When you subtract the smallest number from the greatest number you will find the?

Range.


How do you find the greatest whole number?

There is no greatest whole number. If x were the greatest whole number then what about x+1? It would be greater than x and it would be a whole number!


How to find the greatest integer plotted on a number line?

Find the number which is furthest to the right.


Can I find the greatest number with factors 112337?

No.