I need help sorting a table

  • Thread starter markythesk8erboi
  • Start date
M

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top