Napa Lite 3,278 Posted July 24, 2013 Share Posted July 24, 2013 Forgot to ask...why would it have been bad form to text my former employee condolences and to offer myself as a reference? Link to post Share on other sites
InternetExplorer 2,609 Posted July 24, 2013 Share Posted July 24, 2013 if you were on even footing with the guy in that job and offer a reference post-mortem it sounds like you're putting yourself above him [presumably because he was fired and you were not]. that is how I would take it. if it's a close friend it's a different story, but I would still not be offering a reference. Link to post Share on other sites
Napa Lite 3,278 Posted July 24, 2013 Share Posted July 24, 2013 Most places ask for coworker and manager references though. And I was the closest to a friend he had here. I don't know, I guess I just think I would appreciate it if I was in that situation. Link to post Share on other sites
Ron_Mexico 4,219 Posted July 24, 2013 Share Posted July 24, 2013 Plus, you have to give a couple of days. I would write "hey man, I just heard. I'm so very sorry. If you need anything, please let me know. Well, anything besides money and my free time, because I cant spare any of that." Link to post Share on other sites
iZuma 764 Posted July 24, 2013 Share Posted July 24, 2013 yeah but you also drive without brakes so another excel question: can a "fuzzy" vlookup be done (without downloading a plugin or something)? for instance: I have one column with leading zeros such as 000123 and another column without such as 123. not all numbers have leading zeros and the ones that do have varying amounts of them. any way to do this without altering the zero having data? think that might mess up some other formulas Link to post Share on other sites
NickCave 194 Posted July 24, 2013 Share Posted July 24, 2013 Most places ask for coworker and manager references though. And I was the closest to a friend he had here. I don't know, I guess I just think I would appreciate it if I was in that situation. Offering a reference is patronizing, or is likely to come across as such. If you want to offer your condolences, that's fine. Link to post Share on other sites
Ron_Mexico 4,219 Posted July 24, 2013 Share Posted July 24, 2013 I am sleeping too much as of late We will head into the bedroom at around 9:00-9:30, channel surf for an hour, then I'll go to sleep and basically sleep until 7am. I shouldnt need that much but damn could I stay there for another 2 hours We just got the new bed stuff in june. Mattress, box spring, frame, etc. it was a little shoddy, as mass produced furniture can be, so we punched that thing up this weekend and now that thing is perfect, and could hold at least 2 more girls if need be. Link to post Share on other sites
Napa Lite 3,278 Posted July 24, 2013 Share Posted July 24, 2013 Yeah, Shake, there is. But Im not going to tell you Link to post Share on other sites
Napa Lite 3,278 Posted July 24, 2013 Share Posted July 24, 2013 Huh, you people and your self-esteem. Glad Im to lazy to actually go through with it. Link to post Share on other sites
Ron_Mexico 4,219 Posted July 24, 2013 Share Posted July 24, 2013 Napa, I did enjoy your FB post and Lebowski line. Love when people dont get the movie line and respond oddly. Makes me like them a little less when they dont get it. Makes me think they dont get me. We were doing classic Dennis Farina lines yesterday from Snatch, Midnight Run and Get Shorty. Link to post Share on other sites
Napa Lite 3,278 Posted July 24, 2013 Share Posted July 24, 2013 Ronnie, in refernce to your fb comment, check my status update from a few days ago. Link to post Share on other sites
InternetExplorer 2,609 Posted July 24, 2013 Share Posted July 24, 2013 yeah but you also drive without brakes so another excel question: can a "fuzzy" vlookup be done (without downloading a plugin or something)? for instance: I have one column with leading zeros such as 000123 and another column without such as 123. not all numbers have leading zeros and the ones that do have varying amounts of them. any way to do this without altering the zero having data? think that might mess up some other formulas where did you come up with this fuzzy term? new column, =value(fuzzy data), do the vlookup referencing the new column. Link to post Share on other sites
Cha! Cha! 628 Posted July 24, 2013 Share Posted July 24, 2013 They say the fucking smog is the fucking reason you have such beautiful fucking sunsets. Link to post Share on other sites
InternetExplorer 2,609 Posted July 24, 2013 Share Posted July 24, 2013 I was thinking, if I were shake, I would make up an excel question, then just arbitrarily tell everyone who tries to help, "this was not the correct answer." that's the sort of thing I'd do to help my mood if I were feeling down. Link to post Share on other sites
iZuma 764 Posted July 24, 2013 Share Posted July 24, 2013 ur mom yeah the value formula screwed it all up. gave me a bunch of value errors. it's all because the original data was imported as text to save the leading zeros which I need for some lookups but it messes up others. I fixed it by just recreating the data multiple times and using whichever set I needed for whichever formula. not simple but it works. Link to post Share on other sites
InternetExplorer 2,609 Posted July 24, 2013 Share Posted July 24, 2013 seems pretty simple to me? my biggest problem lately? I need MM/DD/YYYY for today, but not generated such that the underlying value is the date value (e.g. 41479). right now I'm just pestering the user with a popup box each day but ultimately there has to be a way to do it. I have tried stuff like, =text(today(),"MM/DD")&20&text(today(),"YY") but excel is still helpfully changing that into a date value. which breaks the shitty god awful web app these dates need to be imported into. it's not a huge deal but it looks bad. Link to post Share on other sites
Napa Lite 3,278 Posted July 24, 2013 Share Posted July 24, 2013 I would have told you to do =iferror(vlookup("*"&cell&"*",table,column,false),vlookup(cell,table,column,false)) But screw you. Link to post Share on other sites
InternetExplorer 2,609 Posted July 24, 2013 Share Posted July 24, 2013 oh shit. wildcards work in vlookups? learn something new every day. Link to post Share on other sites
InternetExplorer 2,609 Posted July 24, 2013 Share Posted July 24, 2013 my favorite line for when they ask me for 1-10 on my excel skill? "I'm going to say 8, because in my experience anyone claiming 9 or 10 is probably being a little overconfident. I always learn some new or different way to do something in excel whenever I watch someone else use it, regardless of their experience level." Link to post Share on other sites
Napa Lite 3,278 Posted July 24, 2013 Share Posted July 24, 2013 I say basically the exact same thing! Even the 8! Link to post Share on other sites
Ron_Mexico 4,219 Posted July 24, 2013 Share Posted July 24, 2013 Those were 5 posts easily skipped Isnt there an excel thread? Kidding, I'm not a content monger Link to post Share on other sites
InternetExplorer 2,609 Posted July 24, 2013 Share Posted July 24, 2013 excuse me, the preferred nomenclature is "content defecator" 1 Link to post Share on other sites
InternetExplorer 2,609 Posted July 24, 2013 Share Posted July 24, 2013 I say basically the exact same thing! Even the 8! it's possible that I stole it. but seriously, everyone is overconfident as **** about everything in their interviews, I gotta feel like an interviewer would like to hear a little humility once in a while. I am sure people say 9 all day long. Link to post Share on other sites
Napa Lite 3,278 Posted July 24, 2013 Share Posted July 24, 2013 Doubtful. We're probably just on the same wavelength. I don't say the other people part. I do say the "once i think i have it figured out, always learn something new or a better way to do it. And if I don't know how to do if, Im really good at using the Internet to figure it out". Link to post Share on other sites
Dawson Leery 12 Posted July 24, 2013 Share Posted July 24, 2013 Try: =CONCATENATE(MONTH(TODAY()),"/",DAY(TODAY()),"/",YEAR(TODAY())) Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now