PSN Off-Topic - Happy Thanksgiving Chumps and Chumpettes!

Status
Not open for further replies.
tylerh1701 said:
K, my Access/Database knowledge is weak.

Right now I'm using a software program to make these calls, we're not calling using lists straight from Excel. But I import the lists using Excel. I asked my software rep and he couldn't comprehend what I was asking. Seems like it could possibly be a tool they have built in, maybe I need to dig a little more. But since my rep wasn't very helpful I thought maybe I could just handle it myself in Excel.
Click to expand...
http://howtovlookupinexcel.com/vlookup-between-two-workbooks

 
GatorBeerGeek said:
I did some google searches, and it sounded like the quickest method was to paste the second list into the same page as the first. Then use the remove duplicate function. Sounds easy enough...
Click to expand...
The remove duplicate function is only gonna remove one of the two listings that I need removed, not both of them. As far as I can tell, anyway.

My boss and everyone else just tells me to "de-dupe" it, but I don't think that's gonna work.

And everyone, thanks for the info. I'll try to figure out what all of you are saying then see if I can't implement it myself.

 
Last edited by a moderator:
GatorBeerGeek said:
I did some google searches, and it sounded like the quickest method was to paste the second list into the same page as the first. Then use the remove duplicate function. Sounds easy enough...
Click to expand...
That will just remove one of the entries, not delete both. Conditional formatting is the way to go (under the home tab of my Excel: Conditional formatting -> Highlight Cell Rules -> Duplicate values).

 
GatorBeerGeek said:
Well that clarifies what you said a bit. You did not mention anything to do with styles in that last post I quoted. It sounded like you were essentially saying all beer tastes the same when I read that post.

I agree that some people assume a beer is bad because it is made by a certain brewer, and I think that is nuts. Many people will no longer drink Goose Island because it is owned by InBev now just like Budweiser is. I do not give a shit who makes it if it takes good and Bourbon County Stout is one of the best beers made, IMO. However, at the same time, I can drink Blue Moon and I really really hate Shock Top. So I do not think the two of them even though they are the same style taste similar.
Click to expand...
Too lazy to find the other post you had about what I said I liked, but a good kolsch is better than any macrobrew.

I was kidding about the microbrew. I drink a lot of sam adams seasonal beers. I think their porch rocker is really good for spring/summer weather. One of my more liked beers lately has been Yazoo Summer. I generally rotate around through a bunch of different beers. Oh and Lazy Magnolia Southern Pecan is really good to me too.

If im going to be drinking all day, Miller Lite is what I go with.

 
Gentlemen (and ladies), Face/Off is now on Netflix. I have never seen it. But hey, so is Orca: The Killer Whale! Decisions, decisions….

 
eldergamer said:
No love for a good Malbec? Shiraz? Temprallino?

Or a Tawny Port or Cream Sherry for desert?
Click to expand...
drunk-ron-swanson-tv-funny-dancing.gif


 
tylerh1701 said:
Are any of you guys good with Excel and can help me?

Say I have an Excel list of 5,000 names of people to call. Then I get an email from another department, saying "Don't call these 500 people, we want to call them" and they send me another spreadsheet with 500 names.

How can I easily remove that list of 500 names from my list of 5000 names?
Click to expand...
I had something like this I had to do yesterday. Here's the approach I used and it worked pretty well:

http://www.extendoffice.com/documents/excel/774-excel-find-duplicates-in-two-columns.html

  1. Copy the row of 500 names into a new column on the sheet with 500 names.
  2. Create a new column and put this formula into it:
    =IF(ISERROR(MATCH(A2,$C$1:$C$13,0)),"",A2)
  3. Modify the columns to match what's in the sheet you're using. That part should be pretty obvious if you look at the link. Just keep in mind that A2 should be the first data cell of the 5000 column and C$1:C$13 is the range of first to last cell for the 500 column.
  4. Once you drag the formula down so it applies to all 5000 rows, the formula column will fill with all the names available in both columns (5000 names and 500 names).
  5. Call the people whose names appear in the duplicate column and skip the ones with empty cells.
I'm sure there are better ways to do it, but I'm not a huge Excel nerd.

Edit; Actually the other approaches were easier. My requirement was a bit different, though; I wasn't trying to delete duplicates, but rather find the list of items that weren't duplicates.

 
Last edited by a moderator:
I finally saw The Good, the Bad and the Ugly on Netflix. Great western that I've always wanted to see. Tombstone is still my favorite though.
 
Crunchewy said:
Fargo (the movie) is one of my all time favorite movies. I don't think I can stomach a TV spinoff, but I suppose I'm curious about it a little.
Click to expand...
It's awesome and I love the film.

But don't let the name give you some pre bias, go in raw bb.

Also everyone should watch pumping iron if they want to succeed in life.

 
Last edited by a moderator:
I think Disgaea has jumped the shark, tbh. Way too much in the way of individual color squares and characters of varying sizes and such. It was wacky with 1, but 3 was just dumb and 4 looks way too visually jumbled to be better.

 
CrazyDiamond84 said:
I finally saw The Good, the Bad and the Ugly on Netflix. Great western that I've always wanted to see. Tombstone is still my favorite though.
Click to expand...
I think that's the one I've seen. I've seen one of those Clint Eastwood spaghetti westerns and it was great. I need to see them all. I have never seen Tombstone, but Unforgiven is great, as far as more recent westerns go.

 
CrazyDiamond84 said:
I finally saw The Good, the Bad and the Ugly on Netflix. Great western that I've always wanted to see. Tombstone is still my favorite though.
Click to expand...
Ever watched The Magnificent Seven? Pretty awesome western remake of Seven Samurai by Akira Kurosawa. It has Yul Brynner, Charles Bronson, James Coburn and Steve McQueen.

 
Crunchewy said:
I think that's the one I've seen. I've seen one of those Clint Eastwood spaghetti westerns and it was great. I need to see them all. I have never seen Tombstone, but Unforgiven is great, as far as more recent westerns go.
Click to expand...
Its part of a 3part series of westerns. Haven't seen whatever the other ones are but do want to. Unforgiven is a movie I still need to see ASAP.
 
mpaullin said:
That will just remove one of the entries, not delete both. Conditional formatting is the way to go (under the home tab of my Excel: Conditional formatting -> Highlight Cell Rules -> Duplicate values).
Click to expand...
Zimm108 said:
After you highlight the dupes, you can then sort by color and get them all in one fell swoop.

BOOM GOES THE DYNAMITE
Click to expand...
Geniuses. Thanks to you both! And to everyone else who commented. I'm sure there are multiple solutions, this one is just the perfect one for an average Excel user like myself.

 
micbelt said:
Ever watched The Magnificent Seven? Pretty awesome western remake of Seven Samurai by Akira Kurosawa. It has Yul Brynner, Charles Bronson, James Coburn and Steve McQueen.
Click to expand...
No, I haven't seen a lot of the older westerns. There are too many to keep track of. Does that have anything to do with the Tarantino one coming out. Something about eight?
 
https://twitter.com/Rogozin/status/494919386185355264/photo/1

Gosh damn, how I wish Putin was our president.

 
Last edited by a moderator:
tylerh1701 said:
Haha, thanks to CAG my last 20 minutes have been super productive AND now I don't have to listen to any more idiots here tell me "just dedupe it" and I can even tell them what to really do.
Click to expand...
what the fuck do they mean by dedupe? Do they mean go in one by one and delete each of 500 rows? Are they fuck ing 5?!?

 
Equistina said:
Well one of my neighbors just hit a car and drove off…that's really smart.
Click to expand...
Our car was hit and totaled on Super Bowl Night (speaking of football) by a drunk driver. I mean while it was parked on the street. We were asleep. He hit our car hard enough to knock it up onto the curb. He also hit it hard enough that part of the transmission fell out of his (rental) Ford Edge, which ended up in our yard, along with the car. He abandons it there and walks home. We woke up the next morning to find this big ass Ford Edge in our yard. Called the police and they come. They open up the car and inside is the rental agreement. He left it there, along with the keys. Turns out he's right up the street and around the corner. They drive up the street and arrest him. This guy is not a genius. It totally sucked because we really didn't need a new car payment and our Matrix had nothing wrong with it. Probably could have gotten another 100k out of it. I went to court and it was postponed because the drunk ass was in jail still and they didn't bother to bring him over. Waste of fucking time. I didn't have to go in the second time as I was on call and it got postponed again - I don't know why. At least the drunk ass didn't kill anyone else.

 
Status
Not open for further replies.
bread's done
Back
Top