| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
A "sort" problem
The formulas is [=int(rand()*(100-1)+1)] in cells a1:e1. Then cells a2:a6, cell a2=a1, a3=b1, a4=c1 etc... I would like to sort the results in dec. order in cells a2:a6 after each recalc. The problem I have after the sort is a result of "REF#" Can anybody help? -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=471550 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
| Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
| Sort parameters | Excel Discussion (Misc queries) | |||
| Sort Function | Excel Worksheet Functions | |||
| Sort Function Without Using VBA | Excel Worksheet Functions | |||
Threaded Mode
