Display random numbers in sequence

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

spooky1

Thread Starter
Joined
Jan 29, 2010
Messages
126
Can this be done?
problem: column of random numbers, display ten of these numbers on screen permanently in sequence of
largest to smallest. As the numbers in column A changes so too should the display.
I know this could be done with filters but is not what I need.

Col A..... Col B
1 ..........Eggs don't have legs
7 ..........Ban weather reports
9 ..........Ban sports reports
2 ..........give up junk food

(full stops are for separation purposes only)


Display on screen permanently
9 Ban sport reports
7 Ban weather reports
2 Give up junk food
1 Eggs don't have legs


If 8 is added to col A then display should reflect the change thus:- 9, 8, 7, 2
if 7 is removed from col A display would be 9,8,2,1

if it can't be done automatically then a macro would suffice.

These numbers would then be used to vlookup associated data.
In this way one could instantly see if (eg) an account is overdue or due without having to do anything (if not macro). Could be used for many other things.

PS. The numbers for col A would be automatically calculated from date of entry or other means
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top