secretvalentine.jpg
So my goal is to come up with a formula to pair up the 26th person with the first person, the 2nd with the 25th, the 3rd with the 24th, etc. I also must do this by putting the full name of their match into the "Secret Valentine" column. I have absolutely no idea how I can do this, any suggestions? Would the INDIRECT function be in any way useful here?
Bookmarks