Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumproduct..help please
Sorry about double post here....unsure if no answers due to subject line?
Win Xp Pr0 Office Xp I have created a workbook for recording scores at my bowls club. The MAIN worksheet is where I would appreciate help in automating the MAX score entry for each column entries. Col. A = all members names. Cols. B : AZ18 = cells for entering each score. Col. BD has a formula I use for generating the MAX score in each Col.(=Sumproduct(--(A4:G4=$A$67:$G67)), I obtained gratefully from this group.... I am also using conditional formatting from B4:AZ65, which highlights the MAX score in each column.(=B4=MAX(B$:B65)). I have to adjust the Sumproduct formula (G4 ...alter to col H4 and so on), each time I start a new col.otherwise it fails to enter the number of WIN/s against the respective MAX scorer/s. Am I able to automate this particular area please. Hope I have explained sufficiently for you ? TIA Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |