I love it when...

hitbid

Board Regular
Joined
Jan 21, 2016
Messages
114
...I create a large post in the VBA question area, add the code, and go through all the trouble to ask the question...mind you I've tried a few things before posting because I want to figure it out on my own...and then right before I post, I get an idea, and BAM, I don't need to post the question any longer.

Very satisfying.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
When looking for help the answer lies in describing very carefully the problem you have and ensuring others can clearly understand it.
Just describing a problem with little care leads to "tunnel vision". People very often see the output they're expecting only when a condition is TRUE and there's no thought whatsoever when that condition is FALSE.

e.g. "If A1 is 1, I want B1 to be 2"
And what should B1 be if A1 does NOT happen to be 1, we'll just guess shall we?

I used to write reports (programs) for departments and people would fill in a request form to list the fields they wanted on the report. Very often they forgot to include everything they wanted. So I changed the form so you could not only list the fields but "draw" what you expected the report to look like. This meant they looked at the request a second time and in a completely different way and often included fields they'd originally left off the list.

Glad you solved your problem.
 
I love it when people include "easy" in a thread title asking about a problem they clearly can't solve themselves - side-splitting!!! :ROFLMAO:
 
I love it when people include "easy" in a thread title asking about a problem they clearly can't solve themselves - side-splitting!!! :ROFLMAO:
I absolutely hate when people simplify a problem for us and then, when the solution we post for that simplified data/setup doesn't work, then they come back and tell us what their actual data is and how it is laid out. So what are they thinking... Excel is so simple that once they see an answer it can easily be scaled up to solve any problem?
 
Rick! this thread is about LOVE, not hate.

K99 - I have done that so many times, I've lost count. But it's taught me that if I'm scratching my head over the obvious for 5 minutes, ask someone. By the time you're finished talking - you'll see the answer. Or they point out the simple answer to you (which you knew) and you can give yourself a DUH! moment. I do that too, lol.

Ali - thank you :)

hitbid - glad you figured it out. Though, if you had posted then figured it out- posting the solution just helps make the site better! That's why clear, specific titles are important. And why we prefer to keep everything on site (no attachments, for example). It just helps make the site more useful, which brings more people in, which helps pay for the server and keep it free.
Ok, Admin rant over :)

TGIF!!
 
*lol* that's the spirit :)
 
hitbid - glad you figured it out. Though, if you had posted then figured it out- posting the solution just helps make the site better! That's why clear, specific titles are important. And why we prefer to keep everything on site (no attachments, for example). It just helps make the site more useful, which brings more people in, which helps pay for the server and keep it free.
Ok, Admin rant over :)

TGIF!!

TGIF!

Great point. In the past (2-3 weeks since I joined), I have just stated that I figured it out, and haven't always posted the solution. Good call for next time, thanks.
 
Last edited:
Rick - that happens all the time at work even when I push for more information. Love it. :D
 
I love how Vlookup is the solution to everything (it's the greatest thing since sliced bread).

So I'm using Vlookup to Sum......but it doesn't work..
 
Last edited:

Forum statistics

Threads
1,213,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top