TTQ B4U

Thanks to Miller, the world of numbers is good! Regards!!

I know excel pretty well but not a power user for fancy formulas. This one is easy but I'm dumb. Please help me understand how to do this. Situation: I have a spreadsheet with thousands of accounts and about 1,400 zip codes. When moving territories around based on zip code, the account executive code for them will thus change. Need: What I'd like to do is have a lookup/replacement of the Account Executive Sales Code populate based on the listing to the right showing which zip codes go with which AE. Example: For example it would be If the zip code in cell 7K = cell 7Y then take the Account Executive Code Cell 7B with cell 7X. Make sense? Here's a screen shot for you. What formula do I plug in where to make this happen? Thanks in advance for the help! http://i1379.photobucket.com/albums/ah133/PDQS4/excel%20help_zpsxdlksuyp.png

welcome to cbus man. :thumbup:

Their entire web site reads like high school student wrote it. I think I just offended most high school students too. Weird.

Was Kirk in town? Nice ride.

You will know a really good one when you have it.

You'll get as many suggestions as you do members here, so I'll keep it simple. Rombauer Vinyards is good for white Justin is good for a nice Cabernet Sextant is a good one too The above will be in the $20-$30 range at The Anderson's. There are tons of good ones. These just happen to be 3 off the top of my head that we like that won't be overly expensive.

Should have piped him and honked three times.

http://jalopnik.com/holy-shit-dyno-test-shows-2016-camaro-ss-makes-more-po-1747436409 Not sure I believe the source running the dyno's but it's news nonetheless.

My counter part at the lab was an Army Ranger and he trained his guys on using one. He said they would do shit like that in the Pre-Obama days.

Not likely but like many, I'm far from having a decision. I also wouldn't say I'm as extreme as you indicate but that's really not important here.

Count me in!

How many times have people here either seen or done it with a DQ Blizzard or like? I see it a lot in the summer.

That was some funny shit! Handled it well considering that little fucker could probably chomp off some fingers or nose of his face pretty easily. Props to the monkey for having no fear though.

Open mouth, spray Fox 5.3, drink a beer.

Two slices of buttered white bread and two slices of American cheese and about 5-7 minutes. I like to add me in some soup and a couple pickles too. Yum!

:nws: Graphic image of Fuck-stick with his brains blown out. No sexy Virginia for you buddy.....

I agree with your descriptions but am disappointed because based on the above when I wax my Audi I'm jerking off in the garage.

Did you quote me as having said that? That's not my quote you replied to.

He did go back inside and called. The clerk saw the whole thing and already had cops in route. He said 2 cars showed up but one left shortly after. The first officer took a report but it wasn't extensive. It was a Shell off Morse Rd close to Easton. That's all I know about the location. Now one thing I will again agree on you with. Anyone on here that carries a gun for self protection. GET MORE TRAINING. In most cases your CCW instructor was a dickbag just wanting to make a buck. He/she didnt tell you all you need to know. Even if you had a good instructor 4 hours of range time isnt sufficient.

I agree around the $50 but the unknown is would the kid have shanked him and ran? He's as big as you and FWIW, not much but perhaps to some, all three are black. So it's not like young black guys picking on a small geeky white guy. Agree, but he clearly did and does understand the responsibility. When I talked to him face to face I could see his face as he said he didn't want to have to shoot the kid and was glad the kid ran vs forcing him to pull the trigger.

I think there's a difference to be considered though. In the cases of your firm, the bad guys knew and expected them to be armed. No so much with the average Joe. A guy I work at Easton was headed home on Monday, filled up with gas off Morse Rd. He noticed a group of young teens as he walked in. Broke a $50 getting smokes and as he walked out was confronted by two of them. One asked if he had a few bucks to spare. He said "no" and tried to walk past but as he did he jumped a step to the left as he noticed the other guy was pulling something out from his backside and moving to block his path towards his car. As he stepped over he drew his .40 cal from his waste. He kept it pointed downward but once he saw the kids knife he raised the gun and yelled for help and made a ton of noise as he yelled what was happening. The boys turned and took off. He clearly could have dropped the kid, and whether you agree with his exact actions or not, in his case he was aware and prepared and within his rights. That kid could have simply stabbed him and taken his money, gun or worse. Just sharing as while there are times where bad things happen, it's also comforting to know that you have more than just a fist to defend yourself. My friend was still shaken and took the rest of this week off work. He's also going to retake some classes to insure he's more prepared.

http://forums.macrumors.com/proxy.php?image=https%3A%2F%2Fscontent-lax3-1.xx.fbcdn.net%2Fhphotos-xfa1%2Fv%2Ft1.0-9%2F12348070_747505735380257_2782244873645265532_n.jpg%3Foh%3D2b782bd6a490f8c26705cdba281d413b%26oe%3D56D5F7C0&hash=d2e2a86e927e232ef7265a5f06af3f07