| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need help sorting a table
HI ALL!!!
J25...1...K25...(randbetween(1,1000000))... J26...2...K26...(randbetween(1,1000000))... J27...3...K27...(randbetween(1,1000000))... Now, on sheet3 I would like to create the same table only automatically sorted by column K Oh, and it would be nice if after ever change on Sheet1 (which causes the randbetween function to act; changing the number) Sheet3's table will KEEP the original value assigned to the cell. ex. and desired outcome: J25...1...K25...842643... (please note that once a cell has been changed J26...2...K26...520924... all numbers in column K will change as well) J27...3...K27...683921... Sheet3's table would be: J25...2...K25...520924... J26...3...K26...683921... J27...1...K27...842643... ANY IDEAS??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting in a table | Excel Discussion (Misc queries) | |||
| table sorting. | Excel Programming | |||
| Table sorting and v look up possible & | Excel Discussion (Misc queries) | |||
| Need help sorting pivot table | Excel Discussion (Misc queries) | |||
| Sorting a table | Excel Programming | |||
Linear Mode
