| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
location of cell
That is just to return an index into the large function. ROW(A1) returns 1,
so you get the first largest. When you copy down to the second row, this is updated to ROW(A2), which returns 2, so you get the second largest. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "owl527" wrote in message ... it works perfectly fine! thank you.... But, what does ROW(A1) do? I don't understand why you put it in the formula. Please can you explain? thanks. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=499654 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| shortcut to go to previous location or cell | Excel Discussion (Misc queries) | |||
| reporting back a cell location? | Excel Discussion (Misc queries) | |||
| Urgent Cell location changes | Excel Discussion (Misc queries) | |||
| Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
Threaded Mode
