0
You use the RANK function. So if you have a set of numbers in the cells from A2 to A15 and wanted to put a rank of each one beside it, then starting in B2, you would have the following formula:
=RANK(B2,A$2:A$15)
That will rank from highest to lowest. There is an optional argument, to rank them in reverse order. You would use 0 for the default of ranking the highest as first, which is the default, and 1 to rank the lowest as first, like this:
=RANK(B2,A$2:A$15,1)
Wiki User
∙ 7y ago
Add your answer:
Earn +20 pts
Is apple iwork numbers a spreadsheet program?
Apple's Numbers software is the spreadsheet component of their iWork suite.
Is a spreadsheet a collection of numbers or not text?
Spreadsheets are mainly for manipulating numbers and doing calculations, but a spreadsheet will also have a lot of text in it too, usually to explain what the numbers refer to. So there will be mostly numbers on a spreadsheet, but lots of text too.
What is the spreadsheet formula to calculate the difference between two numbers?
It depends which spreadsheet package you're using, and how its syntax is set but - something like... D3=A3-B3 or D3=sum(A3-B3)
what are the row numbers that appear automatically in an excel spreadsheet called?
Serial numbers. Or, generically for any spreadsheet, row headers.
In a spreadsheet numbers are called?
value
Spreadsheet columns are labeled with numbers?
no they are not
Why electronic spreadsheet are much larger than manual spreadsheet?
beacause of the set out
Rows in a spreadsheet are identified by letter.?
No. Rows are identified by numbers in a spreadsheet. Columns are identified by letters.
What is the name of apple's spreadsheet software?
The spreadsheet included with the iWork software suite is called Numbers.
How on Numbers for Macs can you make your own blank spreadsheet?
From the Numbers File menu select New From Template Chooser.... And then select the Blank spreadsheet template.
A spreadsheet calculating the sum of 10 numbers entered into spreadsheet cells is an example of?
A formula. It can also be a function.
What Describes how spread out a data set is?
spreadsheet
