Example A1 would equal the greatest number in A2:P2.
2006-06-19 16:05:20 · 6 answers · asked by Katmando 3 in Computers & Internet ➔ Software
We use excel because of IT restrictions and the numbers are progressive by date. I am using 1 spreadsheet to pull data from others.
2006-06-19 16:12:55 · update #1
Use function MAX.
For example you have data in range A1 to A10 and you want to find the largest number in the range, type in a blank cell
=MAX(A1:A10)
2006-06-19 16:22:33 · answer #1 · answered by Rajeev J 2 · 0⤊ 0⤋
Use the Max function with that range and you may display various information based on the Max value using the IF function.
For example: A1=Max(A2:P2) and if 80 is a passing grade - B1=If(A1>80,"At least one passed!","None passed")
2006-06-19 23:26:29 · answer #2 · answered by Yardie 1 · 0⤊ 0⤋
In your example, put this into the A1 cell:
=max(A2:P2)
2006-06-27 01:22:54 · answer #3 · answered by tom_2727 5 · 0⤊ 0⤋
You are asking to select the cell that have the max in a range, right?
You need two functions
Hyperlink and Max (Hyperlink from insert > function, not from Insert > hyperlink)
It is a little bit costum and needs more info
send me your e-mail and mark me as best answer and i can help
Read my profile, I am the XLMan
2006-06-21 05:00:55 · answer #4 · answered by Anonymous · 0⤊ 0⤋
put all of those cells into one column then sort descending to put the largest of the entries at the top of the worksheet.
2006-06-19 23:10:11 · answer #5 · answered by coxdebate 2 · 0⤊ 0⤋
i now what the answer is,but why choose excel?
2006-06-19 23:10:00 · answer #6 · answered by malibu 2 · 0⤊ 0⤋