View Single Post
 
Old 08-04-2009, 03:50 AM
Girlie4 Girlie4 is offline Windows XP Office 2003
Novice
 
Join Date: Aug 2009
Posts: 3
Girlie4 is on a distinguished road
Default One to many and many to one question

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!
Reply With Quote