Pedro
asked on
Formula will not work in adjacent table
Hi everyone,
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:
https://www.experts-exchange.com/questions/28526375/table-data-based-on-adjoining-calculation.html?anchorAnswerId=40352615#a40352615
Thanks,
Goglow Said:
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" &4*ROW(M5)-15)<0,INDIRECT( "B" & 4*ROW(B5)-15),INDIRECT("J" & 4*ROW(J5)-15))
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(" M" &4*ROW(M5)-15+2),2))
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.
EE-gamestats-ERA.xlsm
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:
https://www.experts-exchange.com/questions/28526375/table-data-based-on-adjoining-calculation.html?anchorAnswerId=40352615#a40352615
Thanks,
Goglow Said:
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"
The formula for the results is
=ABS(ROUND(INDIRECT("E" & 4*ROW(E5)-15)-INDIRECT("M"
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.
EE-gamestats-ERA.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Pony10us,
It seems you got the correct results. Don't know why though.
Goflow,
I had to delete an recreate the V:W to get this to work. But it did work.
Thanks,
Pedro
It seems you got the correct results. Don't know why though.
Goflow,
I had to delete an recreate the V:W to get this to work. But it did work.
Thanks,
Pedro
I don't know why either. Just lucky that way sometimes. :)
Glad you got it working though.
Glad you got it working though.
See attached.
Copy-of-EE-gamestats-ERA.xlsm