meta user
network profile
| bio | website | |
|---|---|---|
| location | United Kingdom | |
| age | ||
| visits | member for | 3 years, 1 month |
| seen | yesterday | |
| stats | profile views | 27 |
Email: stackoverflowmartinsmith@gmail.com
|
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 18 |
comment |
Saving music wisely: Why save 'Queen - Bohemian Rhapsody.mp3' millions of times? "Some criteria that may help you find an answer:" Reads like homework? |
|
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? |
