Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the largest number in a sheet to stand out on it own
One column is the individuals names. The next column the number of cuts per
day. How do I get the highest number to be either bold, blue, or stand out. Or have the name of the person with the hightest number pop up on a different cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the largest number in a sheet to stand out on it own
You can do this with conditional formatting. If your columns of names and
numbers are A and B, starting in row 2 then select cell A2 and Format Conditional Formatting. Use the drop-down to set up the condition: Formula Is, =$b2=max($b:$b) then click the Format button and select the highlighting you'd like and click OK a couple of times. Then select your entire table and hit crtl+y to repeat the previous operation. "Salgar" wrote: One column is the individuals names. The next column the number of cuts per day. How do I get the highest number to be either bold, blue, or stand out. Or have the name of the person with the hightest number pop up on a different cell. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the largest number in a sheet to stand out on itown
Let A4:A11 house the names:
Name dawn damon dan brian christine ian jon Let B4:B11 house the cuts per day: Cuts 75 85 70 90 56 80 90 In C4 enter: Rank In C5 enter & copy down: =RANK(B5,$B$5:$B$11)+COUNTIF(B5:$B$5,B5)-1 In F2 enter: 1 which is the size of the list of top performers. F3: =MAX(IF(INDEX(B5:B11,MATCH(F2,C5:C11,0))=B5:B11,C5 :C11))-F2 which needs to be confirmed with control+shift+enter, not just with enter. This calculates the number of performers whose score ties with that of the top performer. In F4 enter: Top Performer(s) In F5 enter & copy down: =IF(ROWS(F$5:F5)<=$F$2+$F$3,INDEX($A$5:$A$11,MATCH (ROWS(F$5:F5),$C$5:$C$11,0)),"") Another option to the same effect is to run Data|PivotTables... which allows to show the desired number of top performers. Salgar wrote: One column is the individuals names. The next column the number of cuts per day. How do I get the highest number to be either bold, blue, or stand out. Or have the name of the person with the hightest number pop up on a different cell. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the largest number in a sheet to stand out on it
Awesome! That worked! Thanks a lot. This one was killing me.
"bpeltzer" wrote: You can do this with conditional formatting. If your columns of names and numbers are A and B, starting in row 2 then select cell A2 and Format Conditional Formatting. Use the drop-down to set up the condition: Formula Is, =$b2=max($b:$b) then click the Format button and select the highlighting you'd like and click OK a couple of times. Then select your entire table and hit crtl+y to repeat the previous operation. "Salgar" wrote: One column is the individuals names. The next column the number of cuts per day. How do I get the highest number to be either bold, blue, or stand out. Or have the name of the person with the hightest number pop up on a different cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering a number on any sheet one time only | Excel Discussion (Misc queries) | |||
Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
finding the second largest number in a list | Excel Discussion (Misc queries) | |||
How do I sum 4 number discarding the largest number. | Excel Worksheet Functions |