| 
||||
			
			  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 6 2009, 11:35 PM
			
				 Post
					#2
					
				
			 
		 | 
	|
| 
        	
				
        			 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.......
				
				
				
			 
			
			
					
		 | 
	
| 
			
			 | 
	|
 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
 
 GlennCMC70   basically we get 5 drops per season. i don't k...   Aug 5 2009, 06:40 PM
 
 RedHardSupra   send me the spreadsheet to marcinpohl@gmail.com, i...   Aug 6 2009, 11:01 PM
 
 Zeppelin   EDIT: Sorry, that wont work.   Aug 21 2009, 02:42 AM![]() ![]()  | 
	
| Lo-Fi Version | Time is now: 4th November 2025 - 04:19 AM |