0
How do you get Excel to return highest number of entries in a range?
Wiki User
∙ 14y ago
You can use the MAX function. If your range was A1 to A15, then your formula would be:
=MAX(A1:A15)
You can also use the LARGE function, although it is more for when you want to find a position like the second largest or third largest. To use it to find the largest you would type:
=LARGE(A1:A15,1)
The 1 tells it to find the largest. 2 would mean the second largest and so on. To find the largest it is better and simpler to use MAX.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is the highest cell number on Excel?
XFD1048576
How do you clear cell entries in excel?
Click on the cell and press delete.
How do you format an absolute value in Excel?
In excel cell, type =ABS(XXXX). It will return the absolute value of the number or equation you put within the parentheses.
Excel aligns date entries at the what side of the column?
Dates are aligned to the right.
Why do random entries in Excel get replaced with the number symbol?
The number symbol (#) indicates that the content of the cell is wider than the cell can display. Increase the column width and you will see the cell contents, instead of ##########.
Which bar displays entries as they are made and edited in the Excel workbook window?
formula barformula bar!
The feature in excel will complete text entries as you start to type a new entry in a cell?
It is called Autocomplete.
How do you print a row and column headings on excel window?
to get column number, we can use =COLUMN(Reference) to get Row number, we can use =ROW(Reference) For example =COLUMN(A1) will return 1 and =ROW(A3) will return 3
Match examples of number entries to the number formats you would use to represent them in Excel 2007 All formats may not be used?
Fraction >> 8/10 Currency>>-$66,198.05 Number>>-8547.54 Scientific >> Time>>12:51:37 Accounting>>99,178.98
Does Microsoft Excel automatically select the entries in the topmost row of a chart range as the titles for the horizontal axis of a chart?
no
What displays entries as they are made and edited in the Excel workbook window?
The Formula bar will do that and you will also see them in the actual cell.
What is the function in Excel that will count the number of numeric entries in a table?
The COUNT function will do it. You just need to specify your table range. Say your table is from B2 to E16, then the function would be: =COUNT(B2:E16)
