Issue: SUCURI firewall block

From both work (PC) and home (iMac) I am now encountering a SUCURI Firewall block if I try to write/post a formula.
the (home iMac) block details are:
your browser: mosilla/5.0(macintosh;intelmacosx10_12_3) apple web kit/602.4.8 (KHTML, like gecko) version/10.0.3 safari/602.4.8
block ID: BLKUNF1
block reason: your request was not authorized due to its content (HTML code not allowed).
time: wed mar 29 07:47:44 2017
server ID: cp14015

so I requested help from the sucuri chat link and their response...
the website you wanted is using our firewall service and the website owner has configured settings and you would have to contact them.
only the website owner can make changes to "WHITELIST" your IP and allow you access to their website.

So as it stands now I cannot access excel forum for help with formulas from home (iMac and iPad) or from work (PC).

HELP!

Hi Sam..
Have you checked the Threads here?
You don't have to look too far!!
FirstTwoPostsSuggestionsforImprovement.JPG
Alan

( 10 to 1 you have a less than sign with at least 10 characters after it...https://www.excelforum.com/suggestio...ml#post4615552... )

trying it w/o the equal sign and greater than and less than signs...
COUNTIFS(M631:M636,"NB",L631:L636,greater than"42794",L631:L636,less than"42826")
and now with the equal sign but no greater than or less than...
=COUNTIFS(M631:M636,"NB",L631:L636,greater than"42794",L631:L636,less than"42826")
will it take them > outside of a formula? <

yes it will, but not in a formula??? I don't get it?

Thanks Alan, I guess I have to be careful about the formulas I try to post using greater than and less than to include spaces like this...
=COUNTIFS(M631:M636,"NB",L631:L636,"> 42794",L631:L636,"< 42826")

Originally Posted by Sambo kid

Thanks Alan, .. have to be careful about the formulas I try to post using greater than and less than to include spaces like this...
=COUNTIFS(M631:M636,"NB",L631:L636,"> 42794",L631:L636,"< 42826")

You is welcome
Alan

BTW as far as I know, no problem has been reported with the > - you need no space after that

space only after <
=COUNTIFS(M631:M636,"NB",L631:L636,">42794",L631:L636,"< 42826")


Or you can use the black character trick:
black character trick
=COUNTIFS(M631:M636,"NB",L631:L636,">42794",L631:L636,"<42826")

Check out the previous Threads and posts for all the info.
Your problem is / was the famous ".... .... the < followed by at least 4 characters ( not all character type )"..... problem

I can see the difference for your first example "space only after.." but I must be missing something for the "black character trick".

Originally Posted by Sambo kid

I can see the difference for your first example "space only after.." but I must be missing something for the "black character trick".

... Have you checked out the other Threads?? That and other stuff is all explained .......

Your problem is:

a less than sign ( < ) followed by at least 4 characters.
Those 4 characters are most but not all characters.
For example these characters do not cause the problem
[ ]
Those are the characters used, for example in BB Code Code Tags

So if before you post, you make the colour of one of those 4 characters ( 4282 ) black, then, in the Forum Editor it looks like this just before you post
=COUNTIFS(M631:M636,"NB",L631:L636,">42794",L631:L636,"<4[COLOR="#000000"]2[/COLOR]826")
Here I selected the 2 and then hit the black color
Black.JPG

so sucuri firewall sees_..
<4[CO
_..as the first 4 characters after the <
sucurri does not mind that combination

I think I follow it now. Thanks so much for the tips. I did check the other thread but didn't see a direct relevance so I must've missed.
But I do thank you for the solution.

Originally Posted by Sambo kid

I think I follow it now. Thanks so much for the tips. I did check the other thread but didn't see a direct relevance so I must've missed....

There is a lot of waffle and other crap from me in some of those Threads - i need to do a concise summary of all these problems and work a rounds sometime.. maybe when I retire.. I expect the Forum Software quirks will still be there then
Thanks for the rep thingy..