Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-04-2009, 03:50 AM
Girlie4 Girlie4 is offline One to many and many to one question Windows XP One to many and many to one question Office 2003
Novice
One to many and many to one question
 
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
  #2  
Old 08-04-2009, 05:44 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline One to many and many to one question One to many and many to one question Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

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!
Reply With Quote
  #3  
Old 08-07-2009, 10:13 PM
Girlie4 Girlie4 is offline One to many and many to one question Windows XP One to many and many to one question Office 2003
Novice
One to many and many to one question
 
Join Date: Aug 2009
Posts: 3
Girlie4 is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 08-09-2009, 08:02 PM
Girlie4 Girlie4 is offline One to many and many to one question Windows XP One to many and many to one question Office 2003
Novice
One to many and many to one question
 
Join Date: Aug 2009
Posts: 3
Girlie4 is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
One to many and many to one question newbie question DanSandbergUCONN Word 5 03-06-2011 04:27 PM
One to many and many to one question email question neilinthegarden Outlook 1 01-14-2009 10:04 AM
Need help with this question... lllDNYlll Outlook 0 05-04-2006 07:17 AM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM
Access question Ayres Office 6 06-06-2005 10:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft