Excel Help - Page 3 - Antsmarching.org Forums

Go Back   Antsmarching.org Forums > General Discussion > alternativefactsC


Want to hide all ads on Ants? Click here
Reply
 
Thread Tools Display Modes
Old 06-11-2016, 10:40 PM   #61
rconverse
 
rconverse's Avatar
 
Join Date: May 2003
Location: It's how, not where. I live to dance!
Posts: 63,267

Shows Seen: 25

Re: Excel Help

Quote:
Originally Posted by ExistenceNow View Post
What would that formula look like?
It's not a formula. What version of Excel are you using?
__________________
Quote:
Originally Posted by opshannon View Post
You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
rconverse is offline   Reply With Quote

  • Want to hide all ads on Ants? Click here
  • Old 06-11-2016, 10:42 PM   #62
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,292

    Shows Seen: 100

    Re: Excel Help

    Google Sheets.

    __________________
    -Matthew
    ExistenceNow is online now   Reply With Quote
    Old 06-11-2016, 10:44 PM   #63
    justink
     
    justink's Avatar
     
    Join Date: Jan 2002
    Location: Panther41's Head
    Posts: 33,066

    Shows Seen: 49

    Re: Excel Help

    you want some excel help?

    this is what i do, check it out:

    step 1: send it to my younger sister.
    justink is offline   Reply With Quote
    Old 06-11-2016, 10:46 PM   #64
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,292

    Shows Seen: 100

    Re: Excel Help

    Quote:
    Originally Posted by justink View Post
    you want some excel help?

    this is what i do, check it out:

    step 1: send it to my younger sister.


    I haven't used Excel for realz since I was a Social Work major at Texas and had to take SW Stats, which was when I was a Freshman... 16 years ago. So yea, any middle school kid is probably infinitely more proficient than I.
    __________________
    -Matthew
    ExistenceNow is online now   Reply With Quote
    Old 06-11-2016, 10:48 PM   #65
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by ExistenceNow View Post
    Google Sheets.

    Okay, well I don't have a gmail account so I can't go and investigate and I'm about to leave to watch a fight, so just go ahead and use the if statement. Given what you're doing, I don't think you're going to have to worry about overburdening your worksheet (or Google sheet).
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 10:50 PM   #66
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,292

    Shows Seen: 100

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Okay, well I don't have a gmail account so I can't go and investigate and I'm about to leave to watch a fight, so just go ahead and use the if statement. Given what you're doing, I don't think you're going to have to worry about overburdening your worksheet (or Google sheet).

    No, certainly not. No biggie at all, I was just curious and I know you like this type of stuff.

    What I have will work.
    __________________
    -Matthew

    Last edited by ExistenceNow; 06-11-2016 at 10:53 PM.
    ExistenceNow is online now   Reply With Quote
    Old 06-11-2016, 10:55 PM   #67
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by ExistenceNow View Post
    I haven't used Excel for realz since I was a Social Work major at Texas and had to take SW Stats, which was when I was a Freshman... 16 years ago. So yea, any middle school kid is probably infinitely more proficient than I.
    I don't have any kids but I honestly think that Excel or some equivalent should start being taught in like 7th or 8t grade and kind of be required as you move through school.

    I would equate it to learning how to play any instrument. Besides being able to play that particular instrument, it will unlock your brain in so many ways that will pay dividends down the road.
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 10:59 PM   #68
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by ExistenceNow View Post
    No, certainly not. No biggie at all, I was just curious and I know you like this type of stuff.

    What I have will work.
    Well, what I would have done is just used the standard SUM(B1:C1) formula, which clearly doesn't contain the IF statement which takes up more calc time. With that, you can highlight all of column D and set the conditional formatting to change the font white when the value in cell D isn't equal to 0.

    But you'll be totally fine the other way. I'm used to dealing with 69k rows and lots of columns of formulas, so calc time comes into play. (But that's how it would work since you were curious.)
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 11:03 PM   #69
    AllifromOhio
    Samurai Cop
     
    AllifromOhio's Avatar
     
    Join Date: Jan 2005
    Location: Columbus
    Posts: 38,683

    Shows Seen: 83

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    I don't have any kids but I honestly think that Excel or some equivalent should start being taught in like 7th or 8t grade and kind of be required as you move through school.

    I would equate it to learning how to play any instrument. Besides being able to play that particular instrument, it will unlock your brain in so many ways that will pay dividends down the road.


    It's an amazing tool, I wish I knew more about it. It's like the ocean, I can only see a little bit of it and the best is way in there.
    AllifromOhio is offline   Reply With Quote
    Old 06-11-2016, 11:08 PM   #70
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,292

    Shows Seen: 100

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    I don't have any kids but I honestly think that Excel or some equivalent should start being taught in like 7th or 8t grade and kind of be required as you move through school.
    I learned how to use spreadsheets in middle and high school on a fundamental level, but never took any classes in high school that utilized it beyond that; and I took some advanced accounting classes (we used graph paper for fuck's sake). Of course, the internet was still AOL chatrooms at that point too, so I'm sure times have changed.

    Definitely a skill I wish I had.

    Quote:
    I would equate it to learning how to play any instrument. Besides being able to play that particular instrument, it will unlock your brain in so many ways that will pay dividends down the road.
    Another skill I wish I had. Allison can play piano and played french horn in the Longhorn Band. Her brother can play pretty much anything on piano or drums by ear. Their mom had them in piano lessons from the time they were toddlers.
    __________________
    -Matthew
    ExistenceNow is online now   Reply With Quote
    Old 06-11-2016, 11:19 PM   #71
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by ExistenceNow View Post
    Another skill I wish I had. Allison can play piano and played french horn in the Longhorn Band. Her brother can play pretty much anything on piano or drums by ear. Their mom had them in piano lessons from the time they were toddlers.
    Yeah, I wish I could play an instrument. The reason I compare Excel to playing an instrument is because, from what I've been told, learning another instrument is easier and the next easier after that. Once I learned Excel, every other application came almost naturally whereas prior everything was foreign.
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 11:20 PM   #72
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by AllifromOhio View Post


    It's an amazing tool, I wish I knew more about it. It's like the ocean, I can only see a little bit of it and the best is way in there.
    It really is. I've created some things in Excel that literally people wouldn't know was in Excel because you can "bend" the program so much more than people realize.
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 11:24 PM   #73
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,292

    Shows Seen: 100

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Yeah, I wish I could play an instrument. The reason I compare Excel to playing an instrument is because, from what I've been told, learning another instrument is easier and the next easier after that. Once I learned Excel, every other application came almost naturally whereas prior everything was foreign.

    Like language. Definitely heard that once you become fluent in a second language, it becomes easier to pick up others.

    Really wish I'd been forced to learn Spanish from K on, like kids in other countries do with English.
    __________________
    -Matthew
    ExistenceNow is online now   Reply With Quote
    Old 06-11-2016, 11:30 PM   #74
    AJF_41
     
    AJF_41's Avatar
     
    Join Date: Mar 2005
    Posts: 59,960

    Shows Seen: 25

    Re: Excel Help

    my boy rog is wicked smat
    __________________
    Adam

    but where does the meat go?
    AJF_41 is offline   Reply With Quote
    Old 06-11-2016, 11:33 PM   #75
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by ExistenceNow View Post
    Like language. Definitely heard that once you become fluent in a second language, it becomes easier to pick up others.

    Really wish I'd been forced to learn Spanish from K on, like kids in other countries do with English.
    Yeah, for sure. I'm the same way. Wish I would have learned and instrument starting younger and taken my Spanish more seriously.

    The difference with Excel is that it's probably prevalent in like 80% of jobs. Not that the other two don't have amazing benefits but if I had to prioritize, it'd be Excel first.

    Ideally do all three.
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 11:33 PM   #76
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,292

    Shows Seen: 100

    Re: Excel Help

    So this is a Havad bar? I thought they'd have equations and shit on the walls.
    __________________
    -Matthew
    ExistenceNow is online now   Reply With Quote
    Old 06-11-2016, 11:37 PM   #77
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,292

    Shows Seen: 100

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Yeah, for sure. I'm the same way. Wish I would have learned and instrument starting younger and taken my Spanish more seriously.

    The difference with Excel is that it's probably prevalent in like 80% of jobs. Not that the other two don't have amazing benefits but if I had to prioritize, it'd be Excel first.

    Ideally do all three.


    No doubt on the practicality of Excel in the real world.


    With Spanish here though, even working shit jobs you can get a couple dollar an hour bump over your coworkers if you're fluent.

    I know enough to do the business I need to do with non-English speaking folk (and they usually know enough English to meet me half way), but not nearly enough to trouble shoot complicated stuff and earn that pay bump.
    __________________
    -Matthew
    ExistenceNow is online now   Reply With Quote
    Old 06-11-2016, 11:52 PM   #78
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by ExistenceNow View Post
    No doubt on the practicality of Excel in the real world.


    With Spanish here though, even working shit jobs you can get a couple dollar an hour bump over your coworkers if you're fluent.

    I know enough to do the business I need to do with non-English speaking folk (and they usually know enough English to meet me half way), but not nearly enough to trouble shoot complicated stuff and earn that pay bump.
    Oh, yeah. Like I said, a combination of being multi-lingual, app/logic comprehensive, and creativeness (I attribute being able to play an instrument and create music to being creative) is like the trifecta of education, IMO.

    That's not to say that my life would be radically different if I could speak another language or play an instrument but I can't see where it would hurt my overall brain function and, to your point, afford me a few extra bucks in my job.
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 11:54 PM   #79
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by AJF_41 View Post
    my boy rog is wicked smat
    Quote:
    Originally Posted by ExistenceNow View Post
    So this is a Havad bar? I thought they'd have equations and shit on the walls.


    Love GWH references!!
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 07-20-2016, 05:02 PM   #80
    FromTheMorning
     
    FromTheMorning's Avatar
     
    Join Date: Dec 2011
    Posts: 9,610

    Shows Seen: 29

    Re: Excel Help

    Need to convert a date-time to just a regular date. The format of the date-time is "Apr 1 2014 12:00AM" and all I want is 4/1/2014
    FromTheMorning is offline   Reply With Quote
    Old 07-20-2016, 05:04 PM   #81
    drop2d
     
    drop2d's Avatar
     
    Join Date: Dec 2003
    Location: NH
    Posts: 14,163

    Shows Seen: 30

    Re: Excel Help

    Quote:
    Originally Posted by FromTheMorning View Post
    Need to convert a date-time to just a regular date. The format of the date-time is "Apr 1 2014 12:00AM" and all I want is 4/1/2014
    Right click on the cell
    Format Cells...
    Select "Date" from category
    Then select the Type you're looking for.
    __________________
    Quote:
    Originally Posted by bonzo48280 View Post
    I'd rather be wearing an American Flag T-shirt blasting Foreigner through a boombox in Pyongyang than ever set foot in St Louis ever again.
    drop2d is online now   Reply With Quote
    Old 07-20-2016, 05:08 PM   #82
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    If you're in 2007 or later, it's on the home tab to just click on "short date".
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 07-20-2016, 05:23 PM   #83
    DIDriveOut2SPAC
    American Aquarium Drnkr
     
    DIDriveOut2SPAC's Avatar
     
    Join Date: Aug 2006
    Location: New York City
    Posts: 25,352

    Shows Seen: 35

    Re: Excel Help

    This fucking program....
    __________________
    RateYourMusic 2011
    DIDriveOut2SPAC is offline   Reply With Quote
    Old 07-20-2016, 06:31 PM   #84
    FromTheMorning
     
    FromTheMorning's Avatar
     
    Join Date: Dec 2011
    Posts: 9,610

    Shows Seen: 29

    Re: Excel Help

    Quote:
    Originally Posted by drop2d View Post
    Right click on the cell
    Format Cells...
    Select "Date" from category
    Then select the Type you're looking for.
    I suppose I should've mentioned it wasn't in date format. It was literally as if someone just typed "Apr 1 2014 12:00AM" into the cell. So even when I selected "short date" it didn't do anything. I got a coworker to do it. He's an Excel master and it took him like 10 minutes. Used 4 or 5 different functions. Really impressive.

    I wish I had copied the formula before I changed it to a value.

    Last edited by FromTheMorning; 07-20-2016 at 06:35 PM.
    FromTheMorning is offline   Reply With Quote
    Old 07-20-2016, 07:50 PM   #85
    NKAWGNEATO
     
    Join Date: Jun 2016
    Posts: 435

    Shows Seen: 0

    Re: Excel Help

    Quote:
    Originally Posted by FromTheMorning View Post
    I suppose I should've mentioned it wasn't in date format. It was literally as if someone just typed "Apr 1 2014 12:00AM" into the cell. So even when I selected "short date" it didn't do anything. I got a coworker to do it. He's an Excel master and it took him like 10 minutes. Used 4 or 5 different functions. Really impressive.

    I wish I had copied the formula before I changed it to a value.
    You might even say.....Excel lent!
    NKAWGNEATO is offline   Reply With Quote
    Old 07-20-2016, 10:27 PM   #86
    daveshookme
    Bing Bong, Bing Bong!
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Mind - Godric's Hollow; Body - Albany, NY
    Posts: 41,967

    Shows Seen: 38

    Re: Excel Help

    Quote:
    Originally Posted by NKAWGNEATO View Post
    You might even say.....Excel lent!
    http://vignette2.wikia.nocookie.net/...20160306145509
    __________________
    #BeltMelt2k14 never forget

    Tyler made me change my sig and I did because you just don't fuck with poop-apples.
    daveshookme is online now   Reply With Quote
    Old 07-22-2016, 02:28 PM   #87
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,267

    Shows Seen: 25

    Re: Excel Help

    Quote:
    Originally Posted by FromTheMorning View Post
    I suppose I should've mentioned it wasn't in date format. It was literally as if someone just typed "Apr 1 2014 12:00AM" into the cell. So even when I selected "short date" it didn't do anything. I got a coworker to do it. He's an Excel master and it took him like 10 minutes. Used 4 or 5 different functions. Really impressive.

    I wish I had copied the formula before I changed it to a value.
    Probably something like this..

    =DATE(MID(A1, FIND(201, A1, 1), 4), MONTH(LEFT(A1,3)&1), MID( A1, 4, 2)*1)
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 07-22-2016, 02:37 PM   #88
    scrock25
    This team is great!
     
    scrock25's Avatar
     
    Join Date: Aug 2002
    Posts: 60,001

    Shows Seen: 22

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Probably something like this..

    =DATE(MID(A1, FIND(201, A1, 1), 4), MONTH(LEFT(A1,3)&1), MID( A1, 4, 2)*1)
    haha

    LATFH
    scrock25 is offline   Reply With Quote
    Old 10-20-2016, 02:34 PM   #89
    FromTheMorning
     
    FromTheMorning's Avatar
     
    Join Date: Dec 2011
    Posts: 9,610

    Shows Seen: 29

    Re: Excel Help

    Please help me convert this into a standard short date:

    Column A: numeric month (e.g. 12)
    Column B: year (2016)

    There is no day but I just have to make them all the 1st of the month. So in the example above I'm trying to get that to read 12/1/2016
    FromTheMorning is offline   Reply With Quote
    Old 10-20-2016, 02:38 PM   #90
    thebridge15
     
    thebridge15's Avatar
     
    Join Date: Jun 2008
    Posts: 66,424

    Shows Seen: 18

    Re: Excel Help

    =date(b,a,1)
    __________________
    Quote:
    Originally Posted by Rebecca De Mornay View Post
    bills are paying the jags o-line coach 4 million this year.

    that will be a tough one for the aliens to figure out.
    thebridge15 is online now   Reply With Quote
    Reply

    Bookmarks

    Thread Tools
    Display Modes

    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is Off
    HTML code is Off

    Forum Jump


    Want to hide all ads on Ants? Click here

    All times are GMT -4. The time now is 09:37 AM.


    Powered by vBulletin® Version 3.8.6
    Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.


       
    Site LinksAbout AntsAnts MobileTweet Tweet
    Home
    Ants+
    Tour Central
    Search bar
    RSS Feeds
    About Us
    Contact Us
    The Ants Blog
    Advertise on Ants
    Ants on your cell phone
    iAnts
    mobile news
    mobile setlists
    antslive!
    Ants' Twitter
    DMBLive Twitter
    Matt's Twitter
    Jake's Twitter
    Joe's Twitter