Link to home
Start Free TrialLog in
Avatar of Pedro
Pedro

asked on

table data based on adjoining calculation

Hi everyone,

The attached file in sheet named 'CurrentGame2' I would like to update the "Better ERA" section using data from the sheet to the left of it.

For instance, V6:W6 should contain data from the team that has an ERA of -1 or greater comparing data in cells E8 and M8 (i.e. the first two teams). The cells have been manually filled in to show the desired results.
The formula should be able to be copied down.

Please note that when the numbers in E8 and M8 do not differ by one or greater then it is left blank. (i.e. V8:W11)
EE-gamestats-2014.xlsm
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Could you explain again the logic for filling the Table "Better ERA" as nothing is filled in the file you attached. Please specify what columns need to be filled and how exactly the data is compiled as you point to row 6 then comparing it with row 8 !! (Why 8 and not 6 ?)
gowflow
Avatar of Pedro
Pedro

ASKER

Gowflow,

Attached is a file that contains data in V:W. Those are the columns and rows that I would like to extract data to from B:Q in the 'currentgame2' sheet.

The reason row 8 is used is because it contains the most recent stats (i.e. last 5) Row 6 contains last 10 stats.

Hope this helps,
Pedro
EE-gamestats-2014.xlsm
Sorry its chineese to me with all do respect to chineese I do not know this language.

If you want my help you need to explain to me how you get these figures as not clear to me at all. You explain how you go about so I can get you the formula.

I think you made a mistake and the first line
you have put
MIL      8-32-1.78

where I think you meant
MIL      8.32-1.78

meaning negative 8.32 and 1.78 positive.
What I don't get is how you get these figures I guessed that
8.32- = 3.44 - 11.76
but fail to understand the 1.78 I see it is the difference on row 7
so what is the relation with all this ???

Furthermore I try to put formula in Col V W but I cant it puts the formula and not the results !!! what did you do although I looked at options and it says in advanced to display results and not formula.

gowflow
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Pedro

ASKER

Goflow,

This is an interesting problem since I have not seen this problem before where a formula does not work in adjacent table.

Thanks for your help. I have not been able to see how to solve that problem. For that reason I have posted for someone to help here.

https://www.experts-exchange.com/questions/28529937/Formula-will-not-work-in-adjacent-table.html

I will wait to see what others have to say about this issue.
Avatar of Pedro

ASKER

BTW,

 M19 and M20 that shows Div0 is because the pitcher does not have enought stats. That is normal since excel is trying to divide by 0 and lets me know it cannot do that.

and row 53 downward errors in formulas are also expected since formulas are looking for results and cannot find. When results are there these problems are corrected and results are shown.

The above problems are expected and is normal considering the formulas used in the table.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Glad we got it to work at the end.

BTW, my assumption is that you have so many formulas in this wb and some of the get REF error some of them also hv errors for missing data and sum hv different type of errors ....

Maybe at some point in time when creating these formulas don't really know if you did all this or got help form EE experts ... at some point in time someone must hv turn the option to show formula and not results to troubleshoot something ... and somewhere the cell were changed into forting TEXT as this is what I found in these columns so all these combinations with an Unexpected Excel 2010 that have some very weird behavior got locked somewhere in its memory that these columns we need to display formula and not results even though we are changing the entire Sheet behavior by toggling this option on and off it did not affect so the only possible solution at the end was to completely delete the columns removing all references if any in Excel backdoor memory !!!

This is my assumption but not sure either
Regards
gowflow
Also as a side note I strongly suggest you to get assistance in cleaning these errors as the worksheet becomes more readable and less confusing.

If you need help with this let me know I will be glad to assist. For sure you will need to post something new not to over thread this question.
gowflow
Avatar of Pedro

ASKER

Goflow,

I did not correct these errors in the sheet I posted here because it was not relevant to the post. But I see it may cause confusion in solving other formula errors.

BTW, I have posted a corrected copy of the file with another question here, if you would like to look at it.

https://www.experts-exchange.com/questions/28530722/Show-only-data-that-has-a-value-equal-to-or-greater-than-1.html

Best Regards,
Pedro