- string
- rubber bands
- matches
- batteries
- screw driver
- flashlight
- paper clips
- pens/pencils
- keys
- bottle opener
- Scissors
- Tape
- Pens
- Twist ties
- Coupons
- Take-out menus
- Corks
- Rubber bands
- Scratch pad (paper)
- Batteries
I’m probably too late for this, but what the heck.
Excel 05 -> Excel 07 Translation
- Give the columns headings (Items, Doper).
- 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”.
- Highlight the two columns.
- Go to “Data” in the toolbar, click “PivotTable and PivotChart Report…”
- Go to “Insert” in the toolbar, click “PivotTable”.
- Click “Next”, “Next”, “Layout”.
- Click and drag “Items” over to the “ROW” section.
- Click and drag “Doper” over to the “DATA” section (should now read “Count of Doper”).
- Click “OK” and then “Finish”.
BECOMES:
- Give the columns headings (Items, Doper).
- 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”.
- Highlight the two columns.
- Go to “Insert” in the toolbar, click “PivotTable”.
- Click “OK”.
- Drag “Items” to “Row Labels”.
- 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?
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 …
Anybody else playin’?
- Condom
- Paper Clip
- Pen
- Stamp
- Sugar Packet
- Spork
- Screwdriver
- Battery
- Tape
- Odd Change
- Matches
- Tape
- Screwdriver
- Rubber bands
- Bottle opener
- Paper clips
- Scissors
- Pencil
- Notepad
- 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!
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.
- batteries
- scissors
- tape
- pliers
- matches
- cupons
- nail clippers
- nuts
- bolts
- 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.
[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]