Need help with function to sort ID # by number of instances

I suspect the easiest way would be to insert a Pivot Table.

I have a list of user id numbers with column for project codes. I need a column of user numbers in order of most frequent to least frequent users and the first and second most common project code for each individual user.

Given the upload data this seems counter intuitive. All the user ID numbers (column A?) are unique. There are no "most frequent users".

Do you mean the other way around? Those instructions are only doable with column B.

See what I mean in the upload.

Formula in E2 and filled down is array-entered. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

The formula in F2 is also array-entered, filled down and across until you get blanks.

Formula:

Please Login or Register  to view this content.

The results of the first formula look like this. Column D has the counts of each item in column E. It is there for visual confirmation and has no function in either of the above formulas.

	D	E
1	Counts	Freq. Users (?)
2	6	45.0
3	4	92.0
4	3	90.1
5	2	99.0
6	2	86.0
7	2	66.0
8	2	64.0
9	2	55.0
10	2	44.0
11	2	23.0
12	1	90.3
13	1	90.2
14	1	67.0
15	1	65.0
16	1	58.0
17	1	52.0
18	1	46.0
19	1	28.0
20	1	22.0
21	1	21.0

Another (simpler way), although the counts in column D are now helpers to this formula. The formula array-entered in F2 can be

Formula:

Please Login or Register  to view this content.

filled down and across until you get blanks.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

You're welcome. Thanks for the rep.