Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am setting a spreadsheet that will automatically fill in points earned for
the week/year, etc. Each week the winner(team with most points earned) gets $14. I have found I can do that with: =IF((H2=(LARGE(H2:H15,1))),14,0)+week5!j2 However if two or more teams tie, what needs to be there in order to evenly distribute that $14 amongst the the tied teams? I would really appreciate the help! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making changes in all pages in a work book | Excel Discussion (Misc queries) | |||
Making this formula work | Excel Worksheet Functions | |||
Making VBA code from one WB work on another WB | Excel Programming | |||
Making a Reuters function work in VBA | Excel Discussion (Misc queries) | |||
making a userform work | Excel Programming |