show the numbers appear in 4N week PAIR

You haven't told me the source sheet or column(s) or shown me what the results should look like.

Martin

in this question is Weeks Selected 2n the source

i mean an week can have a lot of top for that week

then i think an button to resume  and count the the tops

then show in a new sheet  as resume  the count

call this new sheet "Resume ct wk 2N"


in this sample  3W2014  and 4W2014

could be show like this

but any suggestion is welcome

but need show all the pairs for the selected weeks

in this case is 3w2014 and 4w2014

"20" appears many more than 2 times, so if there are, say, 100 of them do you want hit times to say "100"? Do you want column 'C' to be sorted largest to smallest?

"20" appears many more than 2 times, so if there are, say, 100 of them do you want hit times to say "100"?

Yes ! Please

Do you want column 'C' to be sorted largest to smallest?

yes !

Martin

after the selected week is show
then i just need count the repeats by the first row

that why i say 20 appear 2 times

That doesn't agree with the result picture so please show me what you want for rows 11 and 12.

Martin

for the resume sheet  just the first row of  data for count
no other row will be use

Great JOB

Best Expert !

Martin

A great improvement would be to see the dates selected in the summary

in this case i select 2 weeks  then run the summary as show

Great JOb !

Best Expert !