on the FORMULA sheet highlighted in yellow my entire formulas have stopped working they are supposed to search the results on the ENTER page and bring back the way 6 (only) results of home games..
can anyone help.
complex i know!!
on the FORMULA sheet highlighted in yellow my entire formulas have stopped working they are supposed to search the results on the ENTER page and bring back the way 6 (only) results of home games..
can anyone help.
complex i know!!
Last edited by jono121ukk; 10-21-2016 at 06:42 PM.
Title changed.
Last edited by AliGW; 10-22-2016 at 01:20 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
done|?? is that better
That's fine now, thanks.
You mention an attachment, but there is none ...
wont let me add it..
Press F9.....
My data set is
X(Plotted on Log Scale) Y(Normal Scale)
0.002 8
0.075 12
0.425 19
2 23
4.75 31
10 45
20 58
40 96
80 100
I want to find X corresponding to Y = 10, 20 and 30.
The scenario is X shows particle sizes of soils (which are always same) and Y shows cumulative percetages of particle sizes which change for each sample and we have to calculate percentage finer than 10, 20 and 30% for different kinds of soils.
Can someone help me. Thanks in advance.
@DrSingh - unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
still not letting me add the file
Are you trying to use the paperclip icon to add it? If so, this does not work. You have to go advanced in your reply and scroll down until you see manage attachments. If you are getting an error message, what is it? Try a file-sharing site if all else fails - some of us will be prepared to access it there.
Ok I will try that later thank you
ok so here is the link
https://1drv.ms/x/s!AsvT5d_j9a8qibRmuq19_3HoB2SbNg
the problem i have is (in yellow) this box should show ONLY 6 games played... cant get it to change
also
in ORANGE these formulas are no searching for anythin anymore.
please help thank you
That is a huge file, 5M+. Excel online won't open it nor will my computer download it. Can we assume that it is a variation of the file from the "get formula to read a column upside-down" thread?
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I will down size,the file later tonight sorry
Correct the formula in A77: (copied fro HOME games ?????)
=IF(OR(B77="",C77<6),0,COUNTIFS(ENTER!$C$7:$C$1000,1)-LARGE(IF((ENTER!$H$7:$H$1000=B77)*(ENTER!$C$7:$C$1000=1),ROW($A$6:$A$998)-ROW($A$6),""),6)+1)
Enter with Ctrl+Shift+Enter
Copy down
Any other errors are because formulae (SUMPRODUCT) have NOT been entered with Ctrl+Shift+Enter
Also note these formulas are "wrong":
=SUMPRODUCT(--(OFFSET(ENTER!$H$7,LARGE(IF((ENTER!$H$7:$H$1000=$B102)*(ENTER!$C$7:$C$1000=1),ROW($A$6:$A$998-ROW($A$6),""),6),0,$A102,1)=$B102),--(OFFSET(ENTER!$H$7,LARGE(IF((ENTER!$H$7:$H$1000=$B102)*(ENTER!$C$7:$C$1000=1),ROW($A$6:$A$998)-ROW($A$6),""),6),-1,$A102,1)>OFFSET(ENTER!$H$7,LARGE(IF((ENTER!$H$7:$H$1000=$B102)*(ENTER!$C$7:$C$1000=1),ROW($A$6:$A$998)-ROW($A$6),""),6),-2,$A102,1)))
The highlighted should be (in all cases):
ENTER!ROW($A$7:$A$1000-ROW($A$7)
as moved the results from the "Entry" page and have obviously been deleting/adding rows.
Last edited by JohnTopley; 11-04-2016 at 02:58 AM.
cheers John but how come the pld column shows over 6 ?? in the last 6 away only table??
... the formula is wrong one! Check formula in C29 for HOME equivalent.
And you appear to have repeated or wrongly titled tables.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks