hello everyone,
Im looking for assistance, I have a bunch of random numbers from 1 -50. I wish to display in 1 column, how often each number appears, and in a second column rank in order the most frequent number to the least. eg:
1st = 12
2nd = 7
3rd = 28
4th =etc.
seems like a pretty simple one, though if only new to excel and came across this site in search of answers, any assistance would be greatly apprecaited
See the attached. Column A has the raw data. Column D has the candidate list and column E has the frequency of occurrence. Columns G & H are the same as D & E, but sorted by occurrence to show the rank.
Gary's Student
Hi Jakobshavn,
Thanks for your help, the frequency counter works fine, though when I try and change the raw data, nothing changes in column g or h. cant seem to find a formula in or around that area either.
That is because I manually copied columns D & E into G & H and then manually sorted G & H. In this version
I have included a sorting rank for each of the candidates and then performed the "sort" through Match()/Index().
Last edited by Jakobshavn; 03-15-2015 at 11:05 AM.
wow you are good, so close! perhaps it my explanation that is the fault here. Ive attached a layout that would work for best for what we are trying to achieve, maybe this would explain it better.
I will review your worksheet tomorrow.
Will this help? Put a helper column in P of your uploaded workbook with this formula copied down from P2:P11.Then in O2 this array-entered formula.Formula:
Please Login or Register to view this content.Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter. Then fill / copy down to O11.Formula:Please Login or Register to view this content.
The file is attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks