The Feud: Items in a Junk Drawer [Game Over]

  1. string
  2. rubber bands
  3. matches
  4. batteries
  5. screw driver
  6. flashlight
  7. paper clips
  8. pens/pencils
  9. keys
  10. bottle opener
  1. Scissors
  2. Tape
  3. Pens
  4. Twist ties
  5. Coupons
  6. Take-out menus
  7. Corks
  8. Rubber bands
  9. Scratch pad (paper)
  10. Batteries
    I’m probably too late for this, but what the heck.

Excel 05 -> Excel 07 Translation

  1. Give the columns headings (Items, Doper).
  2. I copied the list and repeated it, making a list of 20, and gave the new 10 your name, just to make this work better. I also changed Dolores’ “a pirate” to “a ninja”.
  3. Highlight the two columns.
  4. Go to “Data” in the toolbar, click “PivotTable and PivotChart Report…”
  5. Go to “Insert” in the toolbar, click “PivotTable”.
  6. Click “Next”, “Next”, “Layout”.
  7. Click and drag “Items” over to the “ROW” section.
  8. Click and drag “Doper” over to the “DATA” section (should now read “Count of Doper”).
  9. Click “OK” and then “Finish”.

BECOMES:

  1. Give the columns headings (Items, Doper).
  2. I copied the list and repeated it, making a list of 20, and gave the new 10 your name, just to make this work better. I also changed Dolores’ “a pirate” to “a ninja”.
  3. Highlight the two columns.
  4. Go to “Insert” in the toolbar, click “PivotTable”.
  5. Click “OK”.
  6. Drag “Items” to “Row Labels”.
  7. Drag “Doper” over to “Values” (will now read “Count of Doper”).

Not as intuitive as before, but I guess Microsoft knows best…
You should now have a list that looks like this:

Row Labels Count of doper
a ninja 1
a pirate 1
Abe Vigoda 2
big rig truck 2
dead hookers 2
elephants 2
Empire State Building 2
gold dubloons 2
Sadness 2
The Astrodome 2
The Pyramids at Giza 2
(blank)
Grand Total 20

If I counted right, Twicks is #43.

Awesome.

Why aren’t they on the refrigerator? :confused:

Why do I have crumbs in my junk drawer? How many licks does it take to get to the Tootsie Roll center of a Tootsie Pop? It’s one of those things that the world may never know … :wink:

Anybody else playin’?

  1. Condom
  2. Paper Clip
  3. Pen
  4. Stamp
  5. Sugar Packet
  6. Spork
  7. Screwdriver
  8. Battery
  9. Tape
  10. Odd Change
  1. Matches
  2. Tape
  3. Screwdriver
  4. Rubber bands
  5. Bottle opener
  6. Paper clips
  7. Scissors
  8. Pencil
  9. Notepad
  10. Batteries

That’s #45!

I’m sorry. Your entry is disqualified because you didn’t give ten items.

Damn, you’re strict!

What would’ve happened if s/he had done “pass” for 8, 9, and 10?

I guess I could do that - but what’s the point?

It’s no biggie - I’ll put her/him in. I gave a bye to others on formatting, since the numbering doesn’t matter…

FYI:

There is hardly any grouping in this one. If you said “screwdriver,” it is not “tools.” I’m still sorting this out. Be patient!

I should have thrown in a smiley – I was teasing you, not criticizing you.

This is going to be a bitch to score – take your time, don’t make yourself nuts with it.

Ok - I’m taking a chill pill! :slight_smile:

The hardest thing in this particular Feud is “identicalizing” the answers! (Is too a word!)

DOLO - Sending you a virtual bottle of wine for your weekend. Unfortunately you won’t be able to open because you didn’t answer “corkscrew” I thought everyone had a corkscrew in their junk drawer, apparently only a handful do.

Happy Memorial Weekend to everyone.

  1. batteries
  2. scissors
  3. tape
  4. pliers
  5. matches
  6. cupons
  7. nail clippers
  8. nuts
  9. bolts
  10. left over parts

Happy Memorial Weekend to you too notfrommensa!

This reminds me of one of the ways to tell if one is Episcopal…

If while looking for a can opener in the church kitchen, all you can find are four corkscrews.

:smiley:

[cue twilightzone music]

Swampy, do you know me. I am Episcopalean, and when I checked my my junk drawer, for this feud, there were four corkscrews.

[/cue twilightzone music]