Computer Geeks Unite! And farging help me!

[ice grillin you]

also sarge pawn shops if you got them in bumblefarg are amazing for component pieces

I was in one a few weeks ago and bangin ass techniques receiver was 12 bucks

[Sgt PSN]

Not so many pawn shops out this way....Goodwill, Salvation Army, and other 2nd hand stores are in much larger supply than pawn shops.  There's a few, but they're mostly stocked with hunting equipment, car parts, and old Sarah Palin calendars.  Would probably have to go to Williamsport or Scranton for a half decent pawn shop. 

[Sgt PSN]

Best pawn shops in the world though are located near large military bases.  This is an absolute fact. 

When I was stationed at Camp Lejeune, a buddy of mine bought a farging late 90s Jeep Wrangler at a Jacksonville pawn shop for like 2 or 3 grand.  And it was fully functional with minimal wear and tear.

[ice grillin you]

I'm currently looking at a deuce and a half for tailgate

[Sgt PSN]

Nice.  They're bio-diesel so you can fuel them with used cooking oil from Mickey D's. 

Also, it'll attrack all the Trumpers during tailgates, so that'll be fun.

[ice grillin you]

can you turn down the volume on an iphone if no sound is coming out of it?

[PhillyPhreak54]

I don't understand the question

I keep my ringer set to vibrate and volume at 0

[ice grillin you]

like if a song is playing out of your phone you hit the down and up button on the side of it....but what if nothing is playing....no sound is coming out of the phone...is it still possible to adjust the volume?

[PhillyPhreak54]

Not that I can see

I have a 7+ and just tried and it only adjusted the ringer volume and in settings it only has something for ringer and alerts

[ice grillin you]

so annoying

technology fail

[PhillyPhreak54]

Yep

There's also no way for my phone to not auto play my music in my truck. I have Bluetooth audio and the phone always auto plays it. No way to stop it.

I'd also like for them to make an out of office feature for text messages

[ice grillin you]

cant you just disable bluetooth in settings

[PhillyPhreak54]

Yeah but then it wouldn't connect my phone to use through the speakers

It's a minor annoyance and I was shocked they didn't have a disable auto play setting

[Sgt PSN]

That's one of the differences between Android and iOS that I love. 

On iPhone, there's only 1 volume setting.  So if you have volume maxed out, your ringtone is maxed out, music/video volume is maxed, and notifications is maxed. 

Android allows individual volume settings for each function.  No idea why Apple hasn't come around to doing the same.  It's not like it's some groundbreaking advancement.  As innovative as Apple is, they also seem to love digging their heels in on certain things, much to the detriment of their product. 

[Tomahawk]

In excel, how can I conditionally remove duplicates?

The column in question needs the rows with the dupilicate part numbers removed, but I need to keep the rows with all other duplicate entries (e.g., "see comments").

Remove Duplicates under the Data tab is too aggressive for my purposes. I don't want to write a formula conditionally format to highlight the specific stupid cells then manually delete the rows.