# \<request\>

**URL:** <https://boards.straightdope.com/t/request/366263>\
**Category:** Miscellaneous and Personal Stuff I Must Share\
**Created:** [July 27, 2006, 2:32pm UTC](https://boards.straightdope.com/t/request/366263 "2006-07-27T14:32:17Z")\
**Posts on this page:** 20\
**Page:** 3

<div class="post-metadata">

**Author:** ![UncleBeer](https://avatars.discourse-cdn.com/v4/letter/u/977dab/32.png) [@UncleBeer](https://boards.straightdope.com/u/UncleBeer)\
**Post date:** [July 27, 2006, 7:37pm UTC](https://boards.straightdope.com/t/request/366263/41 "2006-07-27T19:37:18Z")

</div>

[QUOTE=anyrose]  
\<explosion of poster’s head as she tries to figure out the above equation\>  
[/QUOTE]

It counts the number of unique values - both text and numeric - in the range e116:e185 of an Excel spreadsheet while ignoring empty cells. Why the heck it’s gotta be so complicated to do that, is what’s making _my_ head explode.

---

<div class="post-metadata">

**Author:** ![Annie-Xmas](https://avatars.discourse-cdn.com/v4/letter/a/ecc23a/32.png) [@Annie-Xmas](https://boards.straightdope.com/u/Annie-Xmas)\
**Post date:** [July 27, 2006, 7:39pm UTC](https://boards.straightdope.com/t/request/366263/42 "2006-07-27T19:39:25Z")

</div>

\<makes inquiry about how to make a spoiler box\>

\<points out wasting time on SDMB instead of working\>

---

<div class="post-metadata">

**Author:** ![Ludovic](https://avatars.discourse-cdn.com/v4/letter/l/7ab992/32.png) [@Ludovic](https://boards.straightdope.com/u/Ludovic)\
**Post date:** [July 27, 2006, 7:47pm UTC](https://boards.straightdope.com/t/request/366263/43 "2006-07-27T19:47:09Z")

</div>

\<veiled threat to do bodily harm to OP’s pet\>

---

<div class="post-metadata">

**Author:** ![iamthewalrus\_3](https://avatars.discourse-cdn.com/v4/letter/i/258eb7/32.png) [@iamthewalrus\_3](https://boards.straightdope.com/u/iamthewalrus_3)\
**Post date:** [July 27, 2006, 7:57pm UTC](https://boards.straightdope.com/t/request/366263/44 "2006-07-27T19:57:02Z")

</div>

[QUOTE=Mbossa]  
\<comment about inappropriate Google ads\>  
[/QUOTE]  
\<expression of annoyance that people are _still_ commenting about the _damn_ Google ads.\>

\<suggestion to use Ad blocking software.\>

\<smug satisfaction\>

---

<div class="post-metadata">

**Author:** ![MostlyClueless](https://avatars.discourse-cdn.com/v4/letter/m/ba9def/32.png) [@MostlyClueless](https://boards.straightdope.com/u/MostlyClueless)\
**Post date:** [July 27, 2006, 7:59pm UTC](https://boards.straightdope.com/t/request/366263/45 "2006-07-27T19:59:13Z")

</div>

\<quote of Ludovic’s message\>

\<details on the amounts of mailmen and Jehova’s witnesses that have suffered the wrath of Fluffy Kerbloink Tesla III\>

\<general ridicule about a wasted 5000th post\>

\<obligatory “please don’t pit me” smilie\>

---

<div class="post-metadata">

**Author:** ![Spatial\_Rift\_47](https://avatars.discourse-cdn.com/v4/letter/s/a8b319/32.png) [@Spatial\_Rift\_47](https://boards.straightdope.com/u/Spatial_Rift_47)\
**Post date:** [July 27, 2006, 8:01pm UTC](https://boards.straightdope.com/t/request/366263/46 "2006-07-27T20:01:49Z")

</div>

[QUOTE=iamthewalrus(:3=]  
\<expression of annoyance that people are _still_ commenting about the _damn_ Google ads.\>

\<suggestion to use Ad blocking software.\>

\<smug satisfaction\>  
[/QUOTE]

\<snarky comment involving the term “Mr. Fancypants.”\>

---

<div class="post-metadata">

**Author:** ![FlyingCowOfDoom](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/flyingcowofdoom/32/21776_2.png) [@FlyingCowOfDoom](https://boards.straightdope.com/u/FlyingCowOfDoom)\
**Post date:** [July 27, 2006, 8:11pm UTC](https://boards.straightdope.com/t/request/366263/47 "2006-07-27T20:11:58Z")

</div>

\<comment about plane on treadmill\>

\<grin smiley\>

–FCOD

---

<div class="post-metadata">

**Author:** ![anyrose](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@anyrose](https://boards.straightdope.com/u/anyrose)\
**Post date:** [July 27, 2006, 8:13pm UTC](https://boards.straightdope.com/t/request/366263/48 "2006-07-27T20:13:38Z")

</div>

[QUOTE=UncleBeer]  
It counts the number of unique values - both text and numeric - in the range e116:e185 of an Excel spreadsheet while ignoring empty cells. Why the heck it’s gotta be so complicated to do that, is what’s making _my_ head explode.  
[/QUOTE]

\<comment to the effect that the quoted post was incomprehensible, since it was not in the proper format of this thread\>

\<large grinning smilie inserted several times\>

---

<div class="post-metadata">

**Author:** ![gigi](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@gigi](https://boards.straightdope.com/u/gigi)\
**Post date:** [July 27, 2006, 9:01pm UTC](https://boards.straightdope.com/t/request/366263/49 "2006-07-27T21:01:24Z")

</div>

[QUOTE=Mindfield]  
\<defends manhood\>

\<points to thread about hyena pseudo-penises\>

\<grabs crotch\>

\<makes wild claim by holding hands as far apart as possible\>

\<asks how _you_ doin’\>  
[/QUOTE]

\<Seinfeld quote about shrinkage\>

---

<div class="post-metadata">

**Author:** ![934spe](https://avatars.discourse-cdn.com/v4/letter/9/90db22/32.png) [@934spe](https://boards.straightdope.com/u/934spe)\
**Post date:** [July 27, 2006, 9:19pm UTC](https://boards.straightdope.com/t/request/366263/50 "2006-07-27T21:19:43Z")

</div>

\<wtf?!?!!?\>

---

<div class="post-metadata">

**Author:** ![Pixisis](https://avatars.discourse-cdn.com/v4/letter/p/f17d59/32.png) [@Pixisis](https://boards.straightdope.com/u/Pixisis)\
**Post date:** [July 27, 2006, 9:44pm UTC](https://boards.straightdope.com/t/request/366263/51 "2006-07-27T21:44:10Z")

</div>

\<feeling smug about ability to resist snarky comments\>

\<wondering if that might qualify as one\>

---

<div class="post-metadata">

**Author:** ![garygnu](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/garygnu/32/2924_2.png) [@garygnu](https://boards.straightdope.com/u/garygnu)\
**Post date:** [July 27, 2006, 9:45pm UTC](https://boards.straightdope.com/t/request/366263/52 "2006-07-27T21:45:48Z")

</div>

\<comment about the thread getting to two pages\>

---

<div class="post-metadata">

**Author:** ![UncleBeer](https://avatars.discourse-cdn.com/v4/letter/u/977dab/32.png) [@UncleBeer](https://boards.straightdope.com/u/UncleBeer)\
**Post date:** [July 27, 2006, 10:57pm UTC](https://boards.straightdope.com/t/request/366263/53 "2006-07-27T22:57:24Z")

</div>

[QUOTE=anyrose]  
\<comment to the effect that the quoted post was incomprehensible, since it was not in the proper format of this thread\>

\<large grinning smilie inserted several times\>  
[/QUOTE]

\<my moist humble apologies\>

---

<div class="post-metadata">

**Author:** ![Ruby](https://avatars.discourse-cdn.com/v4/letter/r/13edae/32.png) [@Ruby](https://boards.straightdope.com/u/Ruby)\
**Post date:** [July 27, 2006, 11:18pm UTC](https://boards.straightdope.com/t/request/366263/54 "2006-07-27T23:18:07Z")

</div>

\<only God loves the code monkeys\>

\<obligatory smilie because I raised a code monkey\>

\<acknowledgement smilies are not cool\>

\<:p\>

---

<div class="post-metadata">

**Author:** ![Mindfield](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mindfield/32/19759_2.png) [@Mindfield](https://boards.straightdope.com/u/Mindfield)\
**Post date:** [July 27, 2006, 11:21pm UTC](https://boards.straightdope.com/t/request/366263/55 "2006-07-27T23:21:21Z")

</div>

\<snide comment about **UncleBeer** not quite keeping up with the generic narrative vernacular\>

\<discussion of shrinkage\>

\<uncomfortable looks amongst the men in the thread\>

---

<div class="post-metadata">

**Author:** ![Syntropy](https://avatars.discourse-cdn.com/v4/letter/s/65b543/32.png) [@Syntropy](https://boards.straightdope.com/u/Syntropy)\
**Post date:** [July 27, 2006, 11:22pm UTC](https://boards.straightdope.com/t/request/366263/56 "2006-07-27T23:22:45Z")

</div>

[QUOTE=UncleBeer]  
\<my moist humble apologies\>  
[/QUOTE]

\<Obligatory sexual innuendo regarding your “moist” apology\>

---

<div class="post-metadata">

**Author:** ![Winston\_Smith](https://avatars.discourse-cdn.com/v4/letter/w/e95f7d/32.png) [@Winston\_Smith](https://boards.straightdope.com/u/Winston_Smith)\
**Post date:** [July 27, 2006, 11:34pm UTC](https://boards.straightdope.com/t/request/366263/57 "2006-07-27T23:34:27Z")

</div>

\<Obnoxious mostly-off-topic comment that causes more than a few raised eyebrows\>

\<Blanket statement dismissing previous comment as big joke, illiciting additional raised eyebrows accompanied with eyerolls\>

---

<div class="post-metadata">

**Author:** ![Antinor01](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@Antinor01](https://boards.straightdope.com/u/Antinor01)\
**Post date:** [July 27, 2006, 11:39pm UTC](https://boards.straightdope.com/t/request/366263/58 "2006-07-27T23:39:16Z")

</div>

\<incoherant rambling that it’s because of gays and atheists that threads like this even happen and cause all the evil in the world, including natural disasters. Goes on for several paragraphs.\>

---

<div class="post-metadata">

**Author:** ![Winston\_Smith](https://avatars.discourse-cdn.com/v4/letter/w/e95f7d/32.png) [@Winston\_Smith](https://boards.straightdope.com/u/Winston_Smith)\
**Post date:** [July 28, 2006, 12:04am UTC](https://boards.straightdope.com/t/request/366263/59 "2006-07-28T00:04:09Z")

</div>

[QUOTE=Antinor01]  
\<incoherant rambling that it’s because of gays and atheists that threads like this even happen and cause all the evil in the world, including natural disasters. Goes on for several paragraphs.\>  
[/QUOTE]

\<Incomprehensible and unprovoked attack\>

\<Malicious comments buried in rambling diatribe\>

\<Smug wrap-up making absolutely no sense whatsoever\>

\<Strangely lucid statement leaving everyone scratching heads at **Winston’s** increasing bizarre behavior.\>

---

<div class="post-metadata">

**Author:** ![garygnu](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/garygnu/32/2924_2.png) [@garygnu](https://boards.straightdope.com/u/garygnu)\
**Post date:** [July 28, 2006, 12:08am UTC](https://boards.straightdope.com/t/request/366263/60 "2006-07-28T00:08:52Z")

</div>

\<quip regarding the negative tone the thread has taken on\>

[Previous page](https://boards.straightdope.com/t/request/366263.md?page=2)

[Next page](https://boards.straightdope.com/t/request/366263.md?page=4)