Results 1 to 10 of 10

Formula to return random number from a list and associated name

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2009
    Location
    Woodland, CA
    MS-Off Ver
    Excel 2003
    Posts
    27

    Formula to return random number from a list and associated name

    My objective is to take two different random counts of numbers written in column b, ranging from B9:B66. However I want to highlight the specific fields listed in the example below, and pull random numbers from those selected fields only. Then I want to pull another set of random numbers in the same column B9:B66, however using a different specific set of fields within column B; as shown in the second random formula string. Use the Press 9 feature to randomly select the two different numbers. What this attempt is trying accommplish is selecting one boy, one girl who have assigned numbers adjacent to their names(name field populated in column c).
    What am I doing in correctly?

    HTML Code: 
    Last edited by gmaz2; 02-14-2009 at 01:21 PM. Reason: errant title

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