ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Where to start? (https://www.excelbanter.com/excel-discussion-misc-queries/92199-where-start.html)

Mike L.

Where to start?
 
I am a volunteer at a youth baseball association. I have an excel file
that is composed of columns of age divisions with rows of tournaments.
Each row is composed of the top 4 teams in the tournament (I did not
set it up, it is a bad organizational method).

What would I need to do to give a cell a point value (each first place
is worth 7 points, 2nd is worth 4, etc.), then have a list of the teams
in column (there are many duplicates) with how many points the have
accumulated.

I'm guessing there isn't a very easy way to do this. I don't
necessarily need someone to tell me exactly what to do, but give me
some search terms so that I can get going. Any help would be greatly
appreciated, adding up these totals by hand would be a huge undertaking.


Don Guillett

Where to start?
 
Doable but you need to give better information on the table layout.

--
Don Guillett
SalesAid Software

"Mike L." wrote in message
oups.com...
I am a volunteer at a youth baseball association. I have an excel file
that is composed of columns of age divisions with rows of tournaments.
Each row is composed of the top 4 teams in the tournament (I did not
set it up, it is a bad organizational method).

What would I need to do to give a cell a point value (each first place
is worth 7 points, 2nd is worth 4, etc.), then have a list of the teams
in column (there are many duplicates) with how many points the have
accumulated.

I'm guessing there isn't a very easy way to do this. I don't
necessarily need someone to tell me exactly what to do, but give me
some search terms so that I can get going. Any help would be greatly
appreciated, adding up these totals by hand would be a huge undertaking.





All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com