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!