115 reputation
9
bio website
location United Kingdom
age
visits member for 4 years, 3 months
seen Mar 12 at 20:56

Email: stackoverflowmartinsmith@gmail.com


May
15
comment What does frequency mean with regard to Broadband?
Thanks Ignacio and Lo'oris. It begins to make sense now!
May
15
awarded  Scholar
May
15
accepted What does frequency mean with regard to Broadband?
May
15
awarded  Editor
May
15
revised What does frequency mean with regard to Broadband?
added 164 characters in body
May
15
asked What does frequency mean with regard to Broadband?
May
10
comment Using excel, how can I count the number of cells in a column containing the text “true” or “false”?
Doesn't work for me. Returns 0.
May
10
comment Using excel, how can I count the number of cells in a column containing the text “true” or “false”?
It seems that =COUNTIF(G1,">=true") and =COUNTIF(G1,"<=true") always return 0 for any possible input from CHAR(1) to CHAR(255) so whatever it is being converted to seems completely incomparable. It seems to be acting like a NULL comparison in a database would.
May
10
comment Using excel, how can I count the number of cells in a column containing the text “true” or “false”?
For what it's worth I've changed my mind on this. I guess Excel formulae could be considered a kind of declarative programming language. I don't think it is Turing complete without the use of VBA but then neither are regular expressions - which are deemed acceptable by the SO community!
May
10
comment Using excel, how can I count the number of cells in a column containing the text “true” or “false”?
Hmm I can see the frustration. COUNTIF(A2,">=trud") and COUNTIF(A2,"<=truf") both work. COUNTIF(A2,A2) and any conceivable variant doesn't!
Apr
18
awarded  Commentator
Apr
16
awarded  Supporter
Apr
16
comment DNS cannot resolve a web site address
Fair enough! A good set of troubleshooting steps as well.
Apr
16
comment DNS cannot resolve a web site address
BBC does respond to ping.
Apr
16
comment DNS cannot resolve a web site address
If you ping bbc.co.uk what output do you see?