Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for counting frequency then sorting
Hi guys,
Need some help with this one. My worksheet looks a little like this; Col F Col X Barcode Round Number 14 1234123412341234 12341 15 8687686876868686 86876 16 7543275432754327 75432 17 2482482482482482 24824 18 8687686777777777 86876 The worksheet is a year-to-date summary of all claims submitted to my department from our clients (data starts at row 14). Various data is submitted but I am focussing on the worst performing rounds. The round number is formulated as the first 5 digits of the barcode. Every week, we add to this sheet with the previous weeks claims. By the end of they year we expect appx. 1400 rows of data. I want to have (on the same sheet) a table that extracts the most frequent round numbers that appear in Col X and also puts a count in the opposing cell. I want this to automatically update each week. Say, the 20 most frequent. Is this possible? I appreciate your time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency Counting | Excel Worksheet Functions | |||
Sorting by Frequency? | Excel Worksheet Functions | |||
word frequency counting | Excel Discussion (Misc queries) | |||
Counting Numbers of Same Frequency | Excel Discussion (Misc queries) | |||
Sorting - Frequency distribution. | Excel Discussion (Misc queries) |