Results 1 to 2 of 2

Complex Function

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2011
    Location
    Birmingham, AL
    MS-Off Ver
    Excel 2008 MAC
    Posts
    3

    Complex Function

    I have a spreadsheet with a number of cells each with a name. There are 19 names total. A list of guys are on the left side and in separate cells to the right they are paired with girls. Each guy and girl is paired with a different guy or girl 3/4/5 times. I want to write a function that will spit out which guy is paired with each girl and vice versus. An example of the end result of what I want is displayed in the sheet that is attached. I used a manual method to display what the function needs to spit out, but I would like a function to do the work for me.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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