The Bad Threads

[martindwilson]

teyln i thought the same(since it was me that answered him/her) look in programming forum to see if anything else arises

[ChemistB]

This one is really a pet peeve of mine (is that an international term?).

Why can't people just say "It's not working on my system." or "I can't get it to work." instead of "Your solutions don't work." or "You're wrong." Sheesh!

Typically it's that they did not explain their situation clearly or that they have no clue how to modify a general answer to fit their situation (e.g. change the range) and once in a blue moon we screw up a formula or code.
Just venting.

[royUK]

The worst examples are the ones that don't explain what they want adequately & we end up with a guessing game for several posts.

Then I think the worst offenders are the ones that don't try adapt what is given to their needs, they make no effort to understand the answer!

[martindwilson]

I often wonder if some of the posters have told small fibs on their c.v. or interviews
imagine
scene 1
Monday 1st feb 2XXX
interviewer. are you fully conversant in ms office and its most often used applications ?
applicant . oh yes
interviewer. we us excel a lot in this company are you OK with that ?
applicant . oh it's one of my strong points, I used it all the time when i was with my last 2 employers
interviewer. OK thats fine can you start next week?
applicant . OK, Monday 8 Feb?
interviewer. Yes , 9:00hrs sharp
applicant . OK i'll be here then
applicant stands and exchanges hearty handshake with interviewer then exits stage left.

scene 2
10:15 tuesday 8 feb 2XXX
phone rings and is answered by employee 1
boss. Hi there ,now youve settled in i've emailed you a spread sheet,just need totals of sales figures on sheet 2 and please give me a layout showing only those that have greater than 18% mark up less those highlighted in red font
employee 1. NO prob boss,Can do! on it now.
employee 1 hangs up phone,opens mail,finds spread sheet attached.
Gives panicked look
leans over to next desk
employee 1. excuse me but can you show me how to open this ,i used to do it all the time at my old job but you seem to use different mail program
employee 2. oh ok there you go
employee 1 thanxs.
employee 1. opens spread sheet............
percentage ? font ?,last time i saw a font it was in a church! total whats all that about panic!!!!!!!!!!
surfs net ,"how to add up in microsoft excel"
ah a hit
Search ResultsExcel Formulas - The Basic Operators
employee 1. reads article,scratches head reads article again
blast ,tries another search
"excel +help +forum +adding"
ah another hit
clicks link and is directed to joseph rubins excel tip .com
now realising salvation is at hand starts first post
in Excel Workshop Discussion
with title HELP!!!!!!!!!!!!!!!!
end
Curtain

[Cheeky Charlie]

hehehe, how do you know me so well?

Thing is, I kinda understand to be fair. When "one's life is falling apart before oneself", the natural response is not "how can I make it easy for people to help me?", it's "I need to convey how badly I need help right now". I get annoyed when people are awful, but I know when I panic... in reality I'm probably not much better (*shameful admission*). I've learned forum etiquette (almost), but I'm sure I'd be just as useless as these people we're ribbing if I hadn't.

I'm clearly feeling the peace and love today.

It's nearly Christmas, hooray!

CC

[EdMac]

In response to a request to post a workbook

Well .. you could make one in about 20secs from what I wrote above.
If you start a workbook and put the 6 fields in that i wrote you'll have it right there.
That is why i gave em with specific field letter/numbers.
Just put the blue text into the assigned fields and away you go.
Then it's just to get D1 to come out with an answer of 25 .. lol

FANTASTIC

[jasoncw]

This thread made me laugh pretty good. I've had my share. And honestly, I was reading through to make sure I wasn't contributing to the "bad threads". LOL

[shg]

This has to qualify:

I am looking to create a trading platform for my own product. I want to be able to input prices and quanities, be able to kill (erase) the price and quantity, and keep track of who did the trade, and match the trades bids to asks? How hard would this be for a novice excel user?
Thanks for the help!

Not hard at all!

[ChemistB]

Well, you answered their question. LOL

[chergh]

I often wonder if some of the posters have told small fibs on their c.v. or interviews

I think a lot of people must lie about their excel experience in CV's.

I've just started a new job and apparently the guy before me was an "excel guru". Here's an example of some vba I've inherited:

Sub Get_Sheet_Name_List()
    Sheets("Sheet1").Select
    Columns("M:M").Select
    Selection.ClearContents
    Range("M4").Select
    i = 0
10  i = i + 1
    Range("Sheet1!M" & 3 + i).Value = Sheets(i).Name
    GoTo 10
End Sub

Sub Unhide_all_sheets()
    i = 0
10  i = i + 1
    If Sheets(i).Visible <> True Then Sheets(i).Visible = True
    GoTo 10
End Sub

I'm almost scared to look in the other 20 modules.

[mewingkitty]

for people like me that have their heads up their butts.

I may have felt that way from time to time, but it takes a whole other kind of person to...

A. Complain about service on a free forum

and simultaneously

B. Openly admit they have their head shoved up their.... you get it.

On another note, amusing thread. Brightened up my morning reading through these. 'specially liked the teensy little jpg file submitted.

Personally one of my favorites... after admittedly having done this myself more than once is...

That solution works perfectly, but VBA scares me. I think it's going to hide in my closet and eat me if I fall asleep. I don't know how it works so I do not accept your solution in which I need only to click a button to have my spreadsheet fixed. I also do not know how to ride a bicycle because I was not born knowing how to do so, learning new things is against my religion. Please find a long and arduous formula which will barely accomplish the same thing in only the most ideal of situations.

thanks!

mew!

[shg]

Mew, is that from the forum? That is VERY funny ...

[Cheeky Charlie]

B. Openly admit they have their head shoved up their.... you get it.

I think the thread in question was edited by a mod (you to me?). But the guy was a total tool, for sure.

[Cheeky Charlie]

http://www.excelforum.com/excel-gene...ced-sheet.html


nyaaarargargghrhrghghrh

[martindwilson]

this ones getting to me, it's the quote that done it
http://www.excelforum.com/excel-work...se-tables.html

A friend of my husband gave this brain teaser to him.