FORUM HOME > TNM > Discussion
an excel experts out there?

SnDvls316Posted on 06/15/06 at 23:24:15

I have three colmns

Ranking Wrestler Name Yes/No (stands for Heel/Face)

I'd like to type in the rankings on one page, but have it read the page and produce an output based on the rankings and heel/face to set up the matches.

I want the output to give me the two highest ranked opposites all the way down.

anyone know how to do this?
Rick GarrardPosted on 06/16/06 at 01:47:13

I'm sure there is a way to do this with macros (or at least there should be).

And btw, it's "Excel" not "excell".  (this message brought to you by the friendly folks at Micro$oft.  :)
ZedjaPosted on 06/16/06 at 13:30:30

As far as I know there is no way it can automatically have Excel make the matches for you. Excel only works with one cell at the time.

If you use it as a database for a webpage it would be a different matter.

Then you could have two columns where in each column you connect to the database only choosing either faces or heels and then sort them after ranking.

You need to have IIS installed for that to work though.

Now you could separate the faces and heels into two different tables and just sort each after ranking. That would be the easy way to do it.
SnDvls316Posted on 06/16/06 at 17:58:46

that's how I had been doing it, but it got time consuming trying to cut it down.

someone did say there is a macro that can do it, I just have to figure out how to add/do the macro to the spreadsheet.
SnDvls316Posted on 06/16/06 at 19:02:41

On 06/16/06 at 01:47:13, Rick Garrard wrote:I'm sure there is a way to do this with macros (or at least there should be).

And btw, it's "Excel" not "excell". (this message brought to you by the friendly folks at Micro$oft. :)
fixed it for you....didn't want you to get confused about some other program out there.  ;D
Rick GarrardPosted on 06/17/06 at 01:04:48

"excell"ent  ;)
PulsarPosted on 06/17/06 at 09:07:51

If I can get my hand on Excell, I could make it in about 30 seconds.
Raiders_ArmyPosted on 06/25/06 at 04:14:19

It's actually pretty easy to program a macro.  All you need to do is:

Tools-->Macro-->Record New Macro

Assign it to Control-A or something.  Begin recording.  Highlight your data and then sort it by the columns.  Hit stop.  

That should do it.  You should then have to hit control-a and it will work.