J
J.Scargill
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.
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.