 need some help w/ Excel |
|
|||||||||
 Aug 5 2009, 05:01 PM
Post
#1
|
|
|
Veteran Member  Group: Member Posts: 2,688 Joined: 23-December 03 From: Ft Worth, TX Member No.: 8  |
i use Excel to track season points. i know the every simple stuff like Sum and stuff.
for the final season points tally, i have to go in and manually subtract 20% of the lowest scores for each person. i want a formula that will automatically drop those scores based on cell or text color for that cell. i've googled till my eyes are falling out. i've found some stuff, but i just don't know enough about excel to understand it all. i've tried a few examples given w/ no luck. anyone here able to help? |
 |
 
|
 |
Replies
|
Aug 5 2009, 06:40 PM
Post
#2
|
|
|
Veteran Member Group: Member Posts: 2,688 Joined: 23-December 03 From: Ft Worth, TX Member No.: 8 |
basically we get 5 drops per season. i don't know what the best way to do it would be. i was thinking of just marking the 5 lowest finishes in some way to alow the total less drops to be displayed. if you guys know a way for it to be done w/ no required input from me, let me know.
Matthew - email sent. |
|
|
|
Posts in this topic
GlennCMC70 need some help w/ Excel Aug 5 2009, 05:01 PM
00 Trans Ram Glenn - if you want to email it to me at patterson... Aug 5 2009, 05:38 PM StanIROCZ I'm not sure exactly what you are trying to do... Aug 5 2009, 06:25 PM RedHardSupra send me the spreadsheet to marcinpohl@gmail.com, i... Aug 6 2009, 11:01 PM GlennCMC70 emails sent. the 2nd one has the file....... Aug 6 2009, 11:35 PM
Zeppelin EDIT: Sorry, that wont work. Aug 21 2009, 02:42 AM |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 16th May 2025 - 10:49 PM |