 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? |
 |
 
|
|
Aug 5 2009, 05:38 PM
Post
#2
|
|
|
Experienced Member Group: Advanced Members Posts: 1,766 Joined: 10-April 04 From: New Orleans, LA Member No.: 303 |
Glenn - if you want to email it to me at pattersonm at northoaks dot org, I'll be glad to take a look. I'm no savant, but I spend a lot of time with Excel.
|
|
|
|
|
Aug 5 2009, 06:25 PM
Post
#3
|
|
|
Veteran Member Group: Advanced Members Posts: 3,323 Joined: 30-March 06 From: Detroit Suburbs Member No.: 1,144 |
I'm not sure exactly what you are trying to do, but here are couple suggestions that might help you out.
small - returns the k-th smallest value in a data set min - returns the smallest value in a data set using those tools, you can try some trickery. =SUM(A1:F1)-MIN(A1:F1)*0.2 this would subtract 20% of the smallest score =SUM(A1:F1)-SMALL(A1:F1,1)*0.2 this gives you the same answer as above since the '1' means the smallest value in the list =SUM(A1:F1)-SMALL(A1:F1,1)*0.2-SMALL(A1:F1,2)*0.2 this is an add on to above, it subtracts 20% from the smallest and 2nd smallest event this is how I interpret what you are trying to do, but could be wrong. you should be able to make a slight change to get what you want. This post has been edited by StanIROCZ: Aug 5 2009, 06:25 PM |
|
|
|
|
Aug 5 2009, 06:40 PM
Post
#4
|
|
|
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. |
|
|
|
|
Aug 6 2009, 11:01 PM
Post
#5
|
|
|
Advanced Member Group: Advanced Members Posts: 452 Joined: 12-January 04 From: Charleston, SC Member No.: 121 |
send me the spreadsheet to marcinpohl@gmail.com, i've been doing excel almost on daily basis since mid 90ties (IMG:http://www.frrax.com/rrforum/style_emoticons/default/wink.gif)
|
|
|
|
|
Aug 6 2009, 11:35 PM
Post
#6
|
|
|
Veteran Member Group: Member Posts: 2,688 Joined: 23-December 03 From: Ft Worth, TX Member No.: 8 |
emails sent. the 2nd one has the file.......
|
|
|
|
|
Aug 21 2009, 02:42 AM
Post
#7
|
|
|
Member Group: Advanced Members Posts: 46 Joined: 20-August 09 Member No.: 5,973 |
EDIT: Sorry, that wont work.
This post has been edited by Zeppelin: Aug 21 2009, 10:43 AM |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 22nd October 2024 - 06:46 PM |