Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am new to doing this program so if i sound dumb sorry. if you know golf
this might be simple to understand. i have several rows with names and 18 colums ( 1 for each 18 holes). I am trying to do a count of skins won by each player at the end of each players row. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 name 1 4 5 4 6 3 4 5 5 5 5 6 4 6 4 4 4 4 4 name 2 4 4 4 4 4 4 4 4 4 3 3 5 5 5 5 5 5 5 name 3 3 4 4 4 3 5 5 5 5 4 5 5 5 5 5 4 4 3 name 4 4 4 4 4 4 4 3 5 5 5 5 5 5 5 3 4 4 5 I have the sheet set to highlight the lowest value in each column if there is only one lowest value. here is where it gets confusing. if there is more than on low value then it would carry over to the next column until it comes to a column with only one highlighted. here is what the total would be in the ex. at the end of each row. name 1 total is 3 name 2 total is 4 name 3 total is 4 name 4 total is 7 I am mostly doing this just to learn excel but it will also make it easier for my little golfing group to figure the the winners. thanks for any direction. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
highlight color in cells | New Users to Excel | |||
How do I change highlight color of selected cells | Excel Discussion (Misc queries) | |||
how do I change the highlight color of selected cells in Excel | Excel Discussion (Misc queries) | |||
change highlight color on active cells | New Users to Excel | |||
highlight/color cells with specific character inside | Excel Worksheet Functions |