Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    May 2007
    Location
    desertland, Western Australia, Australia
    Posts
    33
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Populating via "Lookup" (Maybe)

    So.. Given that I haven't messed anything up here -
    In the uploaded xlsx file "bush poetry data" I have two sheets -
    1) Sheet one, is as I enter Nominations for the day, and the "Y" in the following 8 columns is the events the nominees are participating in.
    2) Sheet two, is the 8 individual "Event" lists.

    I have two tasks to preform here -
    1) Populate the 8 individual event lists in Sheet 2, by reading the "Y" in it's relevant column on Sheet 1, and filling in the names associated with that event.
    2) Randomize the list of names so each nominee does NOT follow the same person all the time in each event

    In my basic thinking, I gave the nominees 3 name criteria so I can individually select any column and "Find/Select" that column to scatter the names somewhat.
    This is because I could find no reference to randomizing a list of names with a simple command.
    I WOULD prefer not having to do this.

    Ideally, how I would LIKE this Spreadsheet to work is -
    On the day on nominations, people come in, I type their names into the nominations list and "Y" in relevant event columns.
    Then I go to Sheet 2, and find the events populated.
    I highlight the names in each vent list, and "Shuffle" them with some simple command.

    AS you can see, I don't really know a lot.. maybe I have to have each event on a separate Sheet.. or something..
    open to suggestions.
    I need to be able to "Grow" the data and possibly use it to populate score sheets and stuff too..
    So, whatever I get handed and taught here, I need to be able to understand WHAT the formulas are doing..
    Thanks in advance..
    kio
    Attached Files Attached Files

  2. #2
    Lounger
    Join Date
    May 2007
    Location
    desertland, Western Australia, Australia
    Posts
    33
    Thanks
    1
    Thanked 0 Times in 0 Posts
    ok.. so.. a simple "IF" formula to read what I want onto the SAME sheet is =IF(F6="y",C6, "")
    BUT... I want a cell on sheet two, to read a cell on sheet 1 for a "Y" factor, and if true, then reference itself back to ANOTHER cell on sheet 1.. ??
    does that help anyone help me please?

  3. #3
    Lounger
    Join Date
    May 2007
    Location
    desertland, Western Australia, Australia
    Posts
    33
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Right oh.. stop looking for it...
    =IF(Nominations!I6="y",Nominations!C6, "") will do it from my "Events" sheet..
    HOWEVER...
    If someone bothers to look at what I am trying to do, and has a faster and more efficient way to achieve..
    Please contact me..
    Cheers..

  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    One option

    Hi Kio (Steve)

    Here's one option, I'm sure that someone out there may be able to do this smarter, but looks to work from what I can see.

    Open the Events tab and hold down F9 and see if that does what you want.

    Also, please have a look at row 18 of the Nominations sheet.

    All the best
    Attached Files Attached Files
    Last edited by verada; 2015-11-06 at 02:08.

  5. The Following 2 Users Say Thank You to verada For This Useful Post:

    kio (2015-11-06),Maudibe (2015-11-07)

  6. #5
    Lounger
    Join Date
    May 2007
    Location
    desertland, Western Australia, Australia
    Posts
    33
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Dean.. Looking forward to the next Poets Breakfast..
    Love to hear your recitation
    We should catch up again mate.. I live out back of Northam now..
    Did you see the Honda TV commercial with the coloured horses???
    I was the Cowboy in it who owned them all....

  7. #6
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Hi kio

    don't hold your breath
    Do you get down this way often? Do you still have my mobile numbers?, if so, please give me a call. Not sure how to PM you on this forum.

    Anyway I hope my suggestion for the bush poet data worked for you or atleast give you a starting point.

    Cheers

  8. #7
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Verada,

    To PM someone just click on their name (in blue) at the top left of one of their posts and you'll be given the option.

    Thus to PM you I'd do this:
    WSLPM.JPG

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  9. #8
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 644 Times in 588 Posts
    Verada,

    Clever use of the RND and RANK Functions!

    Kio,

    Are you the cowboy with the beard?
    Last edited by Maudibe; 2015-11-07 at 17:48.

  10. The Following User Says Thank You to Maudibe For This Useful Post:

    verada (2015-11-08)

  11. #9
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Thanks RG,

    I had a look by clicking on the Name (in blue) but the Private Message option is not there, do I need to change a setting or if there something else I need to do?

    Regards

Posting Permissions

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