Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table sort
I am new at using MS Excel 2000. My spreadsheet comprises amongst other
data,six columns whose content comprises positive integers range in value from 1 to 50. I would like to do the following : 1 Sort each row in ascending order in the table, at one go. 2 Determine the frequency of appearance of these integers. ie In the total listing, 3 appeared 100 times,34 appeared 20 times etc. 3 Determine whether any row of integers has been duplicated in this o other tables. -- Thanks for the help Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
How do I sort a pivot table with 2 data rows desending? | Excel Discussion (Misc queries) |