- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Need some Excel Spreadsheet help
Posted on 4/6/17 at 1:56 am to tokenBoiler
Posted on 4/6/17 at 1:56 am to tokenBoiler
quote:
Upload that shite
Do you really have profanity disabled?
fricking asslicker frickshit shite face
1
Posted on 4/6/17 at 6:24 am to GatorReb
Ctrl+A then Delete
95% of the time, it works every time.
95% of the time, it works every time.
Posted on 4/6/17 at 7:48 am to Winston Cup
quote:
fricking asslicker frickshit shite face
This made me Hyena Laugh! Thanks!
Posted on 4/6/17 at 7:50 am to iAmBatman
quote:
Pivot table
Excel 101. One of it's best features IMO.
Posted on 4/6/17 at 7:52 am to TheAlmightySmash
Not really.
Not many use datasets that would need to be visualized in such a way. IMO.
Not many use datasets that would need to be visualized in such a way. IMO.
Posted on 4/6/17 at 7:57 am to Pectus
a lot of people, including myself, have to deal with massive datasets that are usually very detailed. I still think everyone should at least be familiar with pivot tables and how they work.
Posted on 4/6/17 at 8:01 am to TheAlmightySmash
It seems like an unneeded extra step. So what, you made a chart from lots of data? What are the important parts? Do that.
Posted on 4/6/17 at 8:31 am to tokenBoiler
quote:
Yeesh.
Save it as a csv, use either cut or awk to pick out the column and pipe it through sort | uniq -c | sort -n
About 20 seconds of work, and you're done.
Double Yeesh.
Just highlight the entire column, click on Data then Remove Duplicates.
Posted on 4/6/17 at 8:33 am to jefforize
quote:
Or... just dump it into a sql server and select distinct with count.
SELECT DISTINCT (column), COUNT (column) AS Total
FROM yourexcelfile
GROUP BY (column), COUNT (column)
Upload that shite to the cloud and hammer out a uSQL statement
Talk about going overboard on a simple request. haha
Takes about 20 seconds to do with a simple PivotTable.
This post was edited on 4/6/17 at 8:35 am
Posted on 4/6/17 at 8:50 am to Pectus
quote:
It seems like an unneeded extra step. So what, you made a chart from lots of data? What are the important parts? Do that.
I hope that this post is in jest. Yes, using lots of data to produce visualizations is at the heart of most industry now.
From the data he described, he could build a density curve that shows how a SKU is being sold.
Posted on 4/6/17 at 9:10 am to GatorReb
Send email to IT help desk. Ask Goober to fix your problem.
Page 2 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News