answersLogoWhite

0

You would use the small function. So say your values were in the cells from A1 to A15, then to find the fifth smallest you would put the following formula into a cell outside of that range:

=SMALL(A1:A15,5)

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What is the lowest terms for one fifth?

1/5


What is the lowest common denominator of one fifth and one fourth?

20


What is 0.2 as a fraction in its lowest terms?

One fifth or 1/5


What if your mother was both 5th highest and 5th lowest in a race How many people participated?

10, I think. Let's say the Lines are the ten people. Your mother is the exclzmation point. _ _ _ _ !_ _ _ _ Now she is the fifth highest and the fifth lowest.


What is the most famous christmas window display?

Finding the most famous would be subjective but there are some that are popular. In New York for example these would be Macy's Display, Bloomingdale's Display and Saks Fifth Avenue Display.


Where can you find answers for fifth grade excel?

nowhere but ask a teacher for guidance. you can also use a calculator


What is the lowest string on a double bass?

The lowest string on a four string double bass is an E string. If you have a fairly rare five string double bass then the lowest fifth string is a B string.


What is the lowest term of 17 and 85?

Expressed as a vulgar fraction in its lowest terms, 17/85 is equal to 1/5, or one fifth.


What fraction of a pound is 20 pence?

It is: 20/100 or 1/5 in its lowest terms


Joe was both fifth highest and fifth lowest in a race How many people in the race?

There are 9 people in the race. Think about it this way - for him to be 5th highest, there must be 4 people above him (1st place, 2nd, 3rd and 4th). For him to be 5th lowest, there are also 4 people below him. So 4 above plus 4 below plus him = 9 participants


What does range mean in fifth grade math?

what does range mean in fifth grade math?


What is a sentence using the word bonfire?

On November the fifth, all the children were round the bonfire waiting for the firework display.