Do you… Excel?

Well I don’t excel.

Problem:

I had a spreadsheet with many rows and columns in Excel. I wanted to sort a row and get a count of each “S” number. Excel can do this right? Dunno.

Solution:

– Highlight entire column
– Ctrl+C
– vi out.out
– i
– right click
– Escape (twice for good luck)
– :wq!
– cat out.out | sort | uniq -c

21 S1
13 S2
6 S3
1 S5
10 S7L
2 S7M

Comments

  1. falseflag says:

    You could probably do it with a Pivot Table. Mostly because I just learned how to make pivot tables, so I assume they can solve all my problems.

    When all you have is a hammer…