HI-



I tried to use the array from the last post, it wasn't really what I needed...though it was phenomenal information that I'm sure to use one day.

Thought I needed Access, they directed me here. Somewhat new to Excel, but an eager learner:

It is a doubles event.

There are 40 women and 85 men which have to be teamed up.

Each woman’s' scores has to be added to all of the men's score.

Then the total of each pair have to be placed in high to low order to announce winners.

I know it is simple for someone, but giving me a massive headache.

Any advice would be GREATLY appreciated!

One to many relationships and the like ARE Access!

Not sure exactly what you are trying to do - but I'm sure it could be worked in Excel if you want - could you attach a version of what you have - and anotate it with what you want to happen in each cell.

If you can, I'm sure I could work it out for you!

Hey! Thanks for voluteering to help me!
I have attached the spread sheet. Sorry it took so long...I'm a newbie.

I've uploaded the file here.
http://rapidshare.com/files/26498457...urney.xls.html

Figured I'd bump this thread for my mom (she's new to forums) please help her with her query. Thanks.