Crapinon

The 3 fingered prostate punch of death for the win

Not sure if this is dumbass or WTF? Home Garden seems to have an infatuation with Nina Hartley and amputee women. And I don't follow but it keeps popping up. Not sure if this is dumbass or WTF? Home Garden seems to have an infatuation with Nina Hartley and amputee women. And I don't follow but it keeps popping up.

Yep. I paid $225 for my first one. Sold it at a gun show for $235 and thought I did ok. Then a couple of weeks later Bush signed the assault weapons ban and they jumped to $400+ overnight.

We still have to write checks for property and auto taxes. The county adds a 4% surcharge if you pay with a credit card. I am an old fart in that even though I pay 99% of our bills with a credit card, I still balance the checking account. I want to know where my money is going and make sure everything is legit.

Sam Chilton needs to be benched NOW!

We keep some of our bulky inventory in a conex. The only problem we have is when it's full and the item you need is in the back. I needed to get a box from the back yesterday but didn't feel like moving 4 pallets to get to it. So I decided I'd just jump on top of the pallets and crawl over them. The top of the pallet was about chest high. Wrong. I couldn't even get my waist to that level. Broken down shoulders with no strength anymore sucks.

Since they're all 1920's genuine gobbledy gook, how about this? Applesauce Applesauce Bunk Corn-shredder Hotsy-Totsy Hooey Whoopee A&M https://www.yourdictionary.com/articles/1920s-slang

I've never sailed on the open sea but a friend of mine who does is worried about this. Though it won't eat you after it hits you. https://www.yachtingworld.com/news/could-a-floating-shipping-container-sink-your-yacht-is-the-danger-to-sailors-real-or-imagined-107508

My wife came home with an old worn out exercise someone was donating to Gooodwill. She had to have it so she could exercise at home. It remained in the corner of the bedroom 10 days before the first piece of clothing was draper over the handle bars.

Years ago, I was getting on a small regional carrier and had a panic attack while boarding. It was only a 30 minute flight so I was going to tough it out, but the longer it took to take off, the worse it got. Right before we were supposed to leave, they announced that there were problems with the plane and we were going to have to disembark for another plane. When I got on the next plane, I had no problems whatsoever. I think this was going to happen. .

I was able to get a spreadsheet with both sets of part numbers. Now it will work like I need it to work. Thanks for the help in finding the correct functions. XLOOKUP works great.

I had tried that, adding ,2,1 to the end of the formula. But it is returning the wrong info. The search criteria is on sheet 1 is SK-A-050. I would like it to find A-050 on sheet 2. But the info it finds on sheet 2 is SET-900009. I thought it went to the first "S" it found but there are other parts that begin with S before it. I found this on a Microsoft page but I can't figure out how to put it in the formula: Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria. Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set". Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started". Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".

"I carry a 365. Wish I had gone with the XL or slightly larger option. It’s a small gun, very easy to carry/conceal, not so great at the range. Small guns are hard to shoot effectively." Our church has no restrictions on carrying firearms, though no one open carries. We have a security team headed by retired LEO's. Once a year we have a meeting to see who is carrying and trying to go over scenarios with everyone. It's not perfect but it is what it is. At our last yearly meeting, 40-50 people showed up. At least 20% of them were 70+yo women who carried small pocket pistols in their purses. I told my wife if there ever was an active shooter situation, the safest place would be on the ground, because shots are going to be flying everywhere, most of them flying wild.

OK, I've figured xlookup out with one caveat. The part numbers on our website master sheet have our vendor prefix before the part number. Our vendor price list do not. So in sheet 1 the part number is SK-A-050 and on sheet 2 it's A-050 (no prefix). I've tried "*"&{column/cell}&"*" to see if it would just pick up the A-050 but it doesn't work. If I add the SK- to sheet 2 part numbers, it works perfect. But I've got 1000's of parts with different prefixes and can't add to all of them. Is there anyway to have xlookup look for a partial match in the part numbers, no 2 letter prefix?

CEO is easy. Fire people and make people do double duty, drive the short term company profits up and cash out your stock options.

I don't think so. It means more padding and the heavier the glove the more energy you have to exert to move it. "A heavier glove does not hit harder, nor does it hurt the opponent more. Choosing a heavier glove is more about ensuring the safety of you and your partner than about inflicting damage on an opponent. Heavier gloves have more padding, designed to better soften the blow of a hard hit as you leverage your body weight into a punch. To hit harder, work on improving your technique - not sizing up your gloves." https://blog.joinfightcamp.com/boxing-equipment/boxing-glove-ounces-explained/

Bobby Riggs was a tennis hustler deluxe. I know he had a angle to make money, even while losing.

They're wearing 16 oz gloves. While I have no doubt me being hit by Tyson wearing them would kill me, in the world of boxing it's akin to being hit by a pillow.

Since it's aggy related... An random aggy Instagram man-whore claims to have had an affair with Nick Saban's married daughter, Kristen. Said he's being blackmailed by some random person who has questionable sourced pics of them hugging each other, while he's wearing a t-shirt with Saban wearing a crown. WTH and who cares?

IDK....if everyone put there wheels on the parking lot line, cars would be spaced perfectly. Maybe she's trying to start a trend.

Thanks! I'll play with it this afternoon. Duplicate parts numbers will be almost nil. I'll let you know how it works and thanks again!

I'll try to get e screenshot but basically what I'm trying to do is this: We have a master sheet of our web products on sheet 1 of an excel file, in alphabetical order by part number. Column A contains the part numbers, B the description, C UOM, D Main category location and E secondary category location. I imported our vendors spread sheet on sheet 2 of the same excel file. On that sheet (2) column A is part number, column B Description and Column C is the list price. I would like to get sheet 1, column A to find the corresponding part number on sheet 2, column A and bring the list price from sheet 2, to a new column F on sheet 1. Not all the part numbers are from the same vendor so I thought I could import each different vendor price list to a different sheet and repeat the process. I tried using the VLOOKUP function, but the formulas I found on the internet wouldn't work the way I wanted and always returned a null value or "incomplete formula". Thanks again for the help!

I need some help with Excel functions. I have to update pricing on our website by pulling list price from vendor supplied price list. I can get the website content list sent to me in Excel. I would like to set the website content Excel sheet to find part numbers on Excel sheets supplied by our vendors, then import the list price for each item from that sheet to our website sheet. It seems like it should be easy to do but I've searched all day trying to figure out how to do it. I'm sure I'm not putting the correct terms in the search engine. Any help or direction to help would be appreciated.

Right now I'm just looking for some good range ammo to shoot.

I'm trying to buy some .308 ammo for my SFAR. I'm always looking for a deal and know a lot of the sites to check. A lot of the vendors are selling cheaper ammo made by companies I have never heard of (Bullets 1st, Igman, Veterans Ammo) and some from overseas makers (GGG). But seeing Brat's picture of the split in half .357 makes me nervous about buying from a manufacturer I'm not familiar with. Does anyone have any insight or sources that list the quality of ammo offered? Other than social media, which is too easily manipulated.