I need help sorting a table

[markythesk8erboi]

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???

 

[ShaneDevenshire]

Hi Mark,

I guess I just don't follow this. If you want the table one Sheet3 to keep
their original values why would you need to resort it automatically? It
seems to me that you would sort it once, convert the RANDBETWEEN formulas to
values and there is nothing to sort again?

 

[markythesk8erboi]

Ok, here's the scanario:


A B C D E
Rand(1,1million) Rand(1,4) VLOOKUP Rand(1,11820)

1 385644 3 11234
2 456456 4 8888
3 12211 2 9456

I'm only using the sort of column B to randomize the sort for the
records.... So if there is an easier way let me know. But once the random
sort is finished I will be calling upon the data AND if I add another record
to the list it will need to be re-sorted with the rest of the table.

4 74455 1
45665

So, the table itself I have already decided to make only a total of 15 rows.
AND I dont need to call upon the data until the table is COMPLETE.