|
|
#2
08-23-2012, 11:50 AM
|
|||
|
|||
I think I figured it out... almost. The following works in most cases
=IF(J:J>=PERCENTILE(J2:J96,0.7),"G",IF(J:J<=PERCEN TILE(J2:J96,0.3),"R","Y")) But for some reason, there are 2 rows which don't match the color of the cells using the conditional formatting. Is the 'Top 30%' and 'Bottom 30%' used for the conditions calculated differently? I tried using 'Rank' as well to determine the values, but got the same results (I set a column to the RANK of column J:J, then used the above formula using that column - the value was the same as the original formula) Any suggestions? I need to do the same for another excel sheet forthcoming, and I would like to get this working before that one is required. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula needed to merge 2 name lists into one
|
lcolson | Excel | 1 | 06-11-2012 12:03 AM |
| Very simple formula needed! | nicholes | Excel | 4 | 04-12-2012 08:28 AM |
| Serious help needed. | karlyak22 | Outlook | 0 | 11-13-2011 07:32 AM |
|
help needed!!!
|
thunder14 | Word | 1 | 10-17-2009 02:57 PM |
| Excel formula needed. | Rod | Excel | 1 | 08-03-2009 06:55 AM |
Windows Vista 
Office 2007
Threaded Mode