Posts by thomascrown

Thanks a lot everyone. But my brother allready developed a PHP code to extract, and its true the site is very well done, but the way to extract is based on the coordinates to have the complete row(s).

Hi im trying to import the table of results from this site but i´ve never seen nothing like this. The site is this http://clubelo.com/2017-10-01/Results
Can anyone help me on this? Thanks in advance!

Ok people its solved

Sub INSERTMATCHDAY()


Dim SrchRng As Range, cel As Range


Set SrchRng = Range("a1:a1000")


For Each cel In SrchRng
If InStr(1, cel.Value, ",") > 0 Then
cel.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
End If
Next cel


End Sub

Im trying to create a macro for if in column C there are cells with "," then insert that cell to the left, Can anyone help?

Re: Count ifs last 4 or 5 results

THANK YOU A TRILLION TIMES.

That worked fine

Re: Count ifs last 4 or 5 results

Quote from NBVC;793226

is column K relevant for column C?

Yes, i want to know the exact same thing if he won draw or loose. What i am doing is finding the team in column B in Column C.

Re: Count ifs last 4 or 5 results

This one is not working either, i can´t see where the problem is:((

=SE.ERRO(CONTAR.SE.S(ÍNDICE(C$1:C305;MAIOR(SE((A$1:A305<A305)*OU((B$1:B305=B305);(C$1:C305=B305));LIN(A$1:A305)-LIN(A$1)+1);4)):C305;B305;ÍNDICE(Q$1:Q305;MAIOR(SE((A$1:A305<A305)*OU((B$1:B305=B305);(C$1:C305=B305));LIN(A$1:A305)-LIN(A$1)+1);4)):Q305;Q305;ÍNDICE(B$1:B305;MAIOR(SE((A$1:A305<A305)*OU((B$1:B305=B305);(C$1:C305=B305));LIN(A$1:A305)-LIN(A$1)+1);4)):B305;B305;ÍNDICE(A$1:A305;MAIOR(SE((A$1:A305<A305)*OU((B$1:B305=B305);(C$1:C305=B305));LIN(A$1:A305)-LIN(A$1)+1);4)):A305;"<"&A305;ÍNDICE(K$1:K305;MAIOR(SE((A$1:A305<A305)*OU((B$1:B305=B305);(C$1:C305=B305));LIN(A$1:A305)-LIN(A$1)+1);4)):K305;"H");0)

Re: Count ifs last 4 or 5 results

I am trying to change the code to ask the last 4 games of a team independetly she is playing home or away but its not working.

=SE.ERRO(CONTAR.SE.S(ÍNDICE(B$1:C199;MAIOR(SE((A$1:A199<A199)*(B$1:C199=B199);LIN(A$1:A199)-LIN(A$1)+1);4)):B199;B199;ÍNDICE(A$1:A199;MAIOR(SE((A$1:A199<A199)*(B$1:C199=B199);LIN(A$1:A199)-LIN(A$1)+1);4)):A199;"<"&A199;ÍNDICE(K$1:K199;MAIOR(SE((A$1:A199<A199)*(B$1:C199=B199);LIN(A$1:A199)-LIN(A$1)+1);4)):K199;"H");0)

This is the code i modified to get the results but is not working. Where is the fail?

Re: Count ifs last 4 or 5 results

Ok the formula for the first row is this:

=SE.ERRO(CONTAR.SE.S(ÍNDICE(B$1:B1;MAIOR(SE((A$1:A1<A1)*(B$1:B1=B1);LIN(A$1:A1)-LIN(A$1)+1);4)):B1;B1;ÍNDICE(A$1:A1;MAIOR(SE((A$1:A1<A1)*(B$1:B1=B1);LIN(A$1:A1)-LIN(A$1)+1);4)):A1;"<"&A1;ÍNDICE(K$1:K1;MAIOR(SE((A$1:A1<A1)*(B$1:B1=B1);LIN(A$1:A1)-LIN(A$1)+1);4)):K1;"H");0)

and i was puting the formula you posted in row 1.

Thanks a MILLION NBVC.

One more question how can i do to ask for the last 4 games of a team independently she is playing home or away what do i need to change in the code?
Thanks one more time. Amazing job.

Re: Count ifs last 4 or 5 results

Ok i think i´ve fixed. I´m going to try now.

Re: Count ifs last 4 or 5 results

forum.ozgrid.com/index.php?attachment/72613/
Thank you NBVC. Ok i´ve tried, and it´s not working. Im trying to understand the formula, to see where is the error.
I´ve placed the formula in column S (filled in red) and as you can see the results are wrong, and in the last rows they all show a result of 0.
for example in row 130 team Benfica Won the last 4 games at home before that date, and the result showing with this formula is 1.
Is am i doing something wrong? Thanks in advance.

Re: Count ifs last 4 or 5 results

Thank you NBVC, i took a look and i think it won´t fit my needs i will post my example table and you will see what i mean.

forum.ozgrid.com/index.php?attachment/72611/

Imagine in row 285 Team Boavista have the following results playing at home 5 wins 4 draws and 6 lost games

What i want to know is the last 4 results that should give the following results: 2 wins 1 draw and 1 lost game.

Re: Count ifs last 4 or 5 results

No. The result of that formula will say for example that Real Madrid Won 56 Times before that date, what i want is how many games they won on the last 4 games they played before that date not the whole results of a table.

Hi what i´m trying to do is counting how many times a club win, draw or loose, but i only want the last 4 results, not the whole count: i will place here an example:

=COUNT.IF.S(A:A;"<"&A1;B:B;B1;L:L;"WIN";AC:AC;AC1;AD:AD;AD1)

This Formula is asking to count (A:A) DATE < DATE IN CELL A1;
(B:B) TEAM = TEAM IN CELL B1
(L:L) WIN DRAW OR LOOSE
(AC:AC) & (AD:AD) ARE THE FIELD FOR COUNTRY AND LEAGUE

This formula will tell me how many times that team have won before that date, but i only want the last 4,5 or 6 results.

Can someone tell me what to do. Thanks in advance.