# Anyone Here Good At Microsoft Excel (Sorting Things)?

Discussion in 'BlackHat Lounge' started by coreygeer, Jan 20, 2013.

1. ### coreygeerBANNEDBANNED

Joined:
Oct 30, 2007
Messages:
527
932
Ok, I need a way to sort data from a table.

There's (x) amount of rows and (20) columns. They're all one or two digit numbers.

How can I

1) Sort all of the numbers
2) See the percent of all the numbers and how many times they're displayed?

For example: If 77 is displayed 5 out of 100 times in the selected data, I want to be able to group all the 77s together and know the percent of how many times it came up (which is 5% in this example).

2. ### antsaooSupreme Member

Joined:
Oct 1, 2008
Messages:
1,292
637
What do you mean to sort all numbers ?

well you could do find all and calc the total found from all the numbers manually. There are most likely a function for that you could make macro from.

• Thanks x 1
3. ### geomussRegular Member

Joined:
May 19, 2011
Messages:
243
110
If you can't use excel copy and paste all the data into something like notepad ++
land manipulate data from there

• Thanks x 1
4. ### coreygeerBANNEDBANNED

Joined:
Oct 30, 2007
Messages:
527
932
Here's an example:
I want to be able to sort all of these like the 1s with the 1s, the 5s with the 5s and so forth.
Then, I want to be able to find out how many times each number is present like if 52 is present 27 times and what percent that is.

4 8 20 32 33 37 39 43 44 45 46 50 58 62 63 69 70 72 73 78
3 17 26 28 29 34 35 36 41 44 46 50 54 60 61 63 65 69 71 72
2 4 6 8 12 14 15 28 30 32 34 35 36 37 44 48 54 61 71 72
7 11 13 16 20 23 24 25 32 37 39 42 45 54 59 63 66 73 76 78
2 11 15 18 20 24 25 26 33 38 40 48 55 57 62 66 67 75 77 78
16 19 21 24 26 35 38 39 40 41 54 55 65 68 70 72 74 76 78 79
5 12 13 15 18 28 29 38 39 41 42 49 64 66 67 72 73 76 79 80
4 6 11 22 25 26 32 35 39 40 50 51 52 53 54 55 56 63 71 77
3 5 9 14 15 18 19 26 33 35 39 41 46 47 53 55 59 61 63 65
3 16 18 20 22 25 27 29 33 40 43 44 51 55 58 59 61 67 71 79
1 2 4 8 11 21 30 32 35 45 46 47 50 57 59 61 67 68 69 78
2 4 6 8 12 13 18 24 27 38 41 42 45 47 50 52 54 59 68 79
2 4 5 6 14 16 18 20 25 27 28 30 33 39 55 56 58 61 65 67
1 2 13 14 21 29 30 32 37 38 51 54 56 57 62 65 68 70 71 74
3 7 10 15 19 24 31 38 40 45 50 52 55 56 57 60 61 66 67 73
7 10 11 13 14 16 23 35 37 38 39 41 43 44 52 54 65 72 74 80
3 5 6 12 22 25 27 36 42 45 46 48 57 59 61 67 69 72 73 80
2 5 15 17 21 23 28 34 39 42 50 53 54 57 61 63 67 73 75 76
1 8 9 10 20 25 35 36 38 40 51 53 54 59 62 64 65 68 75 78
5 19 23 24 25 31 33 35 36 41 45 51 57 59 63 66 72 74 77 78

5. ### pooinmylooRegular Member

Joined:
Mar 16, 2012
Messages:
307
218
Location:
Welsh Wales, boyo.
Add an extra line before the first column and add a title. Highlight that line, click on data, then filter. You can then click the drop-down box and choose whichever number you want, this will then show you how many times that number appears in the spreadsheet. There's probably an easier or better way of doing this.

In regards to the sorting just click Data, then sort.

• Thanks x 1
6. ### imseriousSenior Member

Joined:
Mar 27, 2009
Messages:
950
561
You can paste all the columns one below the other and can then sort the data. To find out the percentage and number of times - you can do a pivot table on that column. It is available in the insert tab. Just select the whole sheet and then go to Insert > Pivot Table and then just choose the values in the row and column as you want it.

• Thanks x 1
7. ### coreygeerBANNEDBANNED

Joined:
Oct 30, 2007
Messages:
527
932
I'm probably going to utilize the App I have on my phone. I have to enter them all manually but it'll give me a percent and a number amount of how many times every number has come up total.

Been at this for a while scouring the internet for solutions. I've seen some people recommend plugins in Notepad++ and the only thing I can think of at the moment is to manually enter them and let the App sort them out.

• Thanks x 1
8. ### panda23Regular Member

Joined:
Apr 10, 2012
Messages:
232
112
Occupation:
Self-Employed
Location:
Hawaii