06-15-2006, 03:05 PM | #1 | ||
Pro Starter
Join Date: Jul 2001
|
Any Excel experts out there?
here's what I have
Sheet #1 Column A = different names Column B = Yes or No example Joe Blow Yes Jack Imhoff Yes Bob Doe No Barry White Yes James Jones No Brian Wilson No I want to be able to in sheet #2 read and input down the list sot that it comes out like this in two columns Joe Blow Bob Doe Jack Imhoff James Jones Barry White Brian Wilson basically see if column B in sheet 1 = oppoiste on the next name insert it if it's the same put it down one...ect. any ideas? Last edited by SnDvls : 06-16-2006 at 11:36 AM. |
||
06-15-2006, 03:13 PM | #2 |
College Starter
Join Date: May 2003
Location: Beantown
|
Why do you need the info like that?
Why can't you just sort by column two and then cut all the Nos into column 2
__________________
Boston Bashers - III.14 - (8347) |
06-15-2006, 03:20 PM | #3 |
Pro Starter
Join Date: Jul 2001
|
I want to input it in one sheet and then have it output on another.
|
06-15-2006, 03:24 PM | #4 |
College Starter
Join Date: Aug 2002
Location: Strong Island, NY
|
I'm good at excel, but I'm confused about what you want.
|
06-15-2006, 03:29 PM | #5 |
Pro Starter
Join Date: Jul 2001
|
I want it to read sheet 1's info and put them in sheet 2 but opposites
example Joe Blow Yes Jack Imhoff Yes Bob Doe No Barry White Yes James Jones No Brian Wilson No so it reads Joe Blow and yes and puts him in then reads the next name and sees that it is also a yes so it puts hime below Joe Blow, then it reads name #3 and sees it equals a no so it puts it next to Joe Blow ect. too confusing? it's kinda like a match maker I guess for boxing or wrestling is what I'm looking for. |
06-15-2006, 03:31 PM | #6 |
lolzcat
Join Date: Oct 2000
Location: Annapolis, Md
|
Sorting/pasting seems to be the easiest way to do this, though I too am a bit baffled about your desired outcome. I'd sort the list by the second column, and then manually cut and paste the "No" group's names to be in column two.
There may be a higher tech solution, but if you're just doing this once, that ought to work fine. *shurg* Last edited by QuikSand : 06-15-2006 at 03:32 PM. |
06-15-2006, 03:32 PM | #7 |
Pro Starter
Join Date: Jul 2001
|
well they are rankings so I don't want to sort it and disrupt the order as I want the two highest ranked people to face off.
|
06-15-2006, 03:32 PM | #8 |
Pro Starter
Join Date: Jul 2001
|
dola -
I don't know if it is even possible in excell |
06-15-2006, 03:33 PM | #9 |
lolzcat
Join Date: Oct 2000
Location: Annapolis, Md
|
So add a numbered colum to go along with the original rankings... and have that be your second sort after the Yes/No column. Then paste the No group next to the Yes group.
|
06-15-2006, 03:36 PM | #10 | |
Pro Starter
Join Date: Jul 2001
|
Quote:
even if it's not a one time thing? I'd like to just type in the rankings and then have it make the fights based off the rankings. |
|
06-15-2006, 03:37 PM | #11 |
lolzcat
Join Date: Oct 2000
Location: Annapolis, Md
|
Best of luck to you.
|
06-15-2006, 03:54 PM | #12 |
College Starter
Join Date: May 2003
Location: Beantown
|
I could probably think of something with vlookups but I am getting on a plane now. Maybe tomorrow if boredom sets
__________________
Boston Bashers - III.14 - (8347) |
06-15-2006, 03:55 PM | #13 |
Bounty Hunter
Join Date: Oct 2000
Location: Pittsburgh, PA
|
I think the only way to do this is to run a macro on it. That means you'd have to write the macro, of course, and I don't know the language well enough to help with that. It has to be a macro because you're going to compare a condition ("yes" or "no") and that will determine which cell you're going to fill on sheet #2. Since the destination cell isn't determined until after you've checked the condition, there's really no other way to do this.
__________________
No, I am not Batman, and I will not repair your food processor. |
06-15-2006, 04:10 PM | #14 |
Pro Starter
Join Date: Jul 2001
|
well if anyone thinks of anything I'd appriciate it...thanks all again.
|
06-15-2006, 04:21 PM | #15 | |
Hokie, Hokie, Hokie, Hi
Join Date: Mar 2001
Location: Kennesaw, GA
|
Quote:
Code:
Just save that macro to your Worksheet and run it when you need sorting. |
|
06-16-2006, 01:03 AM | #16 |
Pro Starter
Join Date: Apr 2004
|
|
06-16-2006, 08:20 AM | #17 |
lolzcat
Join Date: Oct 2000
Location: sans pants
|
VPI is such a pimp.
__________________
Superman was flying around and saw Wonder Woman getting a tan in the nude on her balcony. Superman said I going to hit that real fast. So he flys down toward Wonder Woman to hit it and their is a loud scream. The Invincible Man scream what just hit me in the ass!!!!! I do shit, I take pictures, I write about it: chrisshue.com |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|