excel help from you gurus

• ZWICK 4 PREZ

  

  I'm making a worksheet for a golf league...
  
  Player A is an 8 handicap and Player B is 4 handicap
  
  How do I calculate the difference between their handicaps (4) and assign 4 strokes to the lowest handicap holes ?
• Belly35

  

  I'll get back to you later...
• sleeper

  

  One hell of an 'if' statement.
• ZWICK 4 PREZ

  

  sleeper;1745569 wrote:One hell of an 'if' statement.

  Yeah I have one and i can't get it out of error. So I'm hoping someone can figure it out.
• ZWICK 4 PREZ

  

  I'm thinking there's no way to do this without using VBE?
• ZWICK 4 PREZ

  

  i got it.. thanks for nothing lol jk
• gut

  I thought you were an engineer....
  
  if(min(A,B)=A, A+abs(A-B),B+abs(A-B))...that's your total value.
  
  Then use a lookup table that distributes the handicap according to the number. So if you're doing up to 36 handicap, you might need 36 distributions for a differential of 1-36.
• ZWICK 4 PREZ

  

  gut;1745609 wrote:I thought you were an engineer....
  
  if(min(A,B)=A, A+abs(A-B),B+abs(A-B))...that's your total value.
  
  Then use a lookup table that distributes the handicap according to the number. So if you're doing up to 36 handicap, you might need 36 distributions for a differential of 1-36.

  
  No, that's retarded
• gut

  ZWICK 4 PREZ;1745615 wrote:No, that's retarded

  It would have taken me about 10 minutes...how long did your non-retarded method take you before you posted asking how here?
• ZWICK 4 PREZ

  

  gut;1745644 wrote:It would have taken me about 10 minutes...how long did your non-retarded method take you before you posted asking how here?

  I have a formula based on simple addition. Why would I build a table when I can add 1+1?
  The formula didn't take time at all, the 0 handicap was blowing up my formula since you can't have a "0th" smallest number in an array.