below is what 'goflow' experienced with the attached file. If anyone knows how to solve this, please post.
The issue in on sheet 'Current Game 2' columns V and W. For some reason the formulas below will not work there.
The link to the original post is:
I added them in the attached file at the bottom of the table in the green section as I could not get the formula to display results in col VW like advised before.
The formula for the team is
=IF(INDIRECT("E" & 4*ROW(E5)-15)-INDIRECT("M"
"B" & 4*ROW(B5)-15),INDIRECT("J"
The formula for the results is
=ABS(ROUND(INDIRECT("E" & 4*ROW(E5)-15)-INDIRECT("M"
&4*ROW(M5)-15),2))&" - "&ABS(ROUND(INDIRECT("E" & 4*ROW(E5)-15+2)-INDIRECT("
When you fix the issue of getting the results in col V and W then you take these 2 formulas that you copy from here and paste into cell V6 and W6 and from there you drag them down.