Results 1 to 4 of 4

one number from multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2010
    Location
    n.ireland
    MS-Off Ver
    Excel 2007
    Posts
    91

    one number from multiple columns

    Hello,

    I have data in columns A2:DK31 and growing,
    what i need is to pick a random number from 3 columns ei column A,E,AF.
    I know i can use
    =index(a2:a31,randbetween(2,31)) to get a random number from column A

    but how do i add in column E,AF to this and still return just 1 random number.
    Each day there is a new column added and each day he looks for a different combination.

    any help is fantastic.
    Last edited by dealer; 08-20-2010 at 06:37 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1