I have a table with the range being B4:O99, and I would like to make a list of each value (numbers can range from 1-96) that appears more than once in this list. I would like this list to be sorted in order of priority (number occurring most often being of highest priority). Any help would be appreciated! Thanks,
Daniel
One way to do this it is to do have all data in one column and make a pivot table from your data.
On the row section you would have the field and in the data section the "count of" field, in descending order.
Last edited by Portuga; 04-15-2008 at 03:50 PM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
Another way to do it is to have countif formulas for each value:
=countif($B$4:$O$99;1)
And then sort the column with the formula, descending.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
XCBeast944 
Register To Reply
Bookmarks