115 reputation
11
bio website
location United Kingdom
age
visits member for 4 years, 8 months
seen Dec 14 at 13:38

Email: stackoverflowmartinsmith@gmail.com


Sep
14
comment Automating Defrag
My earlier comment might have been utter nonsense. Have you read this already? support.microsoft.com/kb/555098
May
30
comment Online email tracing tool
Only way I can imagine that anything like this could have ever existed would be by sending an HTML email with a tracker image and geolocating by IP address. Most mail clients block remote HTML resources now for privacy reasons so that scheme would be dead in the water.
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?