1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Display random numbers in sequence

Discussion in 'Business Applications' started by spooky1, Apr 8, 2010.

Thread Status:
Not open for further replies.
  1. spooky1

    spooky1 Thread Starter

    Jan 29, 2010
    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
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 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/915687

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice