<div>
Like so?<br />
Click the button called &quot;Count Numbers&quot; to populate columns DY and DZ.<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268373/678965456.xlsm" target="_blank" class="file-inline" title="678965456.xlsm (2.3 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>678965456.xlsm</a>
</div>


678965456.xlsm

<div>
Subodh Tiwari (Neeraj) Great Expert !<br />
<br />
&nbsp;Glad to see you back !!<br />
<br />
where to click ??
</div>


<div>
Sorry! I forgot to attach the file. In the file, on Sheet1, you will find a button called &quot;Count Numbers&quot; placed in column ED.
</div>


<div>
Subodh Tiwari (Neeraj) Best &nbsp;Expert !<br />
<br />
Thanks for the fast reponse <br />
<br />
in &nbsp;this situation<br />
<br />
i need count each number in the 13 set (1week)<br />
then show the &nbsp;numbers as &nbsp;the order it happens <br />
<br />
let me explain an sample<br />
<br />
1- if we goes to week 13W2014<br />
<br />
then you see<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268383/aaaaaaaa1111111111111111111.PNG" target="_blank" title="aaaaaaaa1111111111111111111.PNG (153 KB)"><img alt="aaaaaaaa1111111111111111111.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268383/aaaaaaaa1111111111111111111.PNG" /></a><br />
<br />
what i need in column <br />
DY &nbsp;DZ &nbsp;<br />
<br />
is the each count number<br />
which will give the top number<br />
<br />
in the order that happens<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268386/asasasasas11111111.PNG" target="_blank" title="asasasasas11111111.PNG (125 KB)"><img alt="asasasasas11111111.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268386/asasasasas11111111.PNG" /></a><br />
<br />
this the results<br />
after the count<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268387/00000001111111111.PNG" target="_blank" title="00000001111111111.PNG (192 KB)"><img alt="00000001111111111.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268387/00000001111111111.PNG" /></a><br />
im using this &nbsp;tools for count <br />
each column but need &nbsp;an more fastest way to complete the task<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268388/count-each-number.xlsm" target="_blank" class="file-inline" title="count-each-number.xlsm (66 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>count-each-number.xlsm</a>
</div>


aaaaaaaa1111111111111111111.PNG

00000001111111111.PNG

count-each-number.xlsm

asasasasas11111111.PNG

<div>
Can you mock up the desired output for few rows manually and upload the file again?
</div>


<div>
Try this. Run the DY_DZ macro that you'll find in Module1.<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268403/29081674.xlsm" target="_blank" class="file-inline" title="29081674.xlsm (2.5 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>29081674.xlsm</a>
</div>


29081674.xlsm

<div>
i take 12w2014 as sample &nbsp;look &nbsp;please as here<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268404/a0.PNG" target="_blank" title="a0.PNG (64 KB)"><img alt="a0.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268404/a0.PNG" /></a><br />
<br />
then &nbsp;i take the data as here<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268408/a1.PNG" target="_blank" title="a1.PNG (160 KB)"><img alt="a1.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268408/a1.PNG" /></a><br />
<br />
then &nbsp;have to be copied to be count ( i want this to be directly in the file<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268412/a2.PNG" target="_blank" title="a2.PNG (38 KB)"><img alt="a2.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268412/a2.PNG" /></a><br />
<br />
then &nbsp;paste the result in the file &nbsp;<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268413/a3.PNG" target="_blank" title="a3.PNG (138 KB)"><img alt="a3.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268413/a3.PNG" /></a><br />
<br />
<br />
then need have the data show as here<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268414/a4.PNG" target="_blank" title="a4.PNG (130 KB)"><img alt="a4.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268414/a4.PNG" /></a><br />
<br />
this the file with the sample<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268416/678965456--1-.xlsx" target="_blank" class="file-inline" title="678965456--1-.xlsx (2.3 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>678965456--1-.xlsx</a>
</div>


a3.PNG

a2.PNG

a0.PNG

a1.PNG

a4.PNG

678965456--1-.xlsx

<div>
Subodh Tiwari (Neeraj)<br />
<br />
Please let me know if i &nbsp;make an good explain until now
</div>


<div>
Martin Liss<br />
<br />
im
</div>


<div>
It seems that Martin guessed your requirement correctly. Please check the file he uploaded.
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
Thanks for the &nbsp;help
</div>


<div>
This version has a button. You'll find it near columns DY:DZ.<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268422/29081674a.xlsm" target="_blank" class="file-inline" title="29081674a.xlsm (2.5 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>29081674a.xlsm</a>
</div>


29081674a.xlsm

<div>
Martin Working for me<br />
<br />
have an question <br />
<br />
can be the 2 first to post as needed <br />
<br />
and first 3 in the &nbsp;correct cell ??<br />
<br />
<br />
like here<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268424/a4.PNG" target="_blank" title="a4.PNG (130 KB)"><img alt="a4.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268424/a4.PNG" /></a>
</div>


0001101010101.PNG

<div>
Martin <br />
i can open new question for
</div>


29081674b.xlsm

<div>
Martin <br />
<br />
&nbsp;Great JOB <br />
<br />
&nbsp;Best Expert Ever !!
</div>


<div>
I want to consult you a small issue<br />
<br />
<br />
but working great<br />
<br />
<br />
when in top &nbsp;cpunt is example 05 &nbsp; &nbsp;it show just 5 &nbsp; need be show as 05
</div>


<div>
If you format column EA as Text, you will see 05.
</div>


<div>
Working as needed !! <br />
<br />
Great Job !
</div>


<div>
Are you getting the correct output with Martin's solution?<br />
See his latest file and look at the cell DY13. It shows the count of 5 is 5 in DZ13 while I don't see 5 in numbers in the range BF6:BF16.<br />
Or I am missing something?
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
let &nbsp;me check it please and thanks for the &nbsp;point
</div>


<div>
<ul>
<li>The numbers in column DY are the single-digit numbers contained the BF column in any give week.</li>
<li>The numbers &nbsp;in DZ are the number of times the number in DY occurs. DY/DZ is sorted on DY.</li>
<li>The numbers in EA in the '1- row' are a concatenation of the first two DFY values.</li>
<li>The numbers in EA in the '2- row' are a concatenation of the first three DFY values.</li>
</ul>
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
<br />
as i see you point the only diference is the sort<br />
<br />
in my original &nbsp;files sort are from minor to &nbsp;mayor<br />
<br />
with martin solution is from mayor to minor<br />
<br />
<br />
but &nbsp; is &nbsp;working as expected <br />
<br />
becasuse all will be the same &nbsp; ((i mean the same pattern)<br />
<br />
<br />
but let me know if you &nbsp;need more information <br />
or &nbsp;suggestion &nbsp;from you will be welcome always<br />
<br />
Great Expert
</div>


<div>
i mean the sort &nbsp; when an count repat as &nbsp;in DY 13 case<br />
<br />
3 numbers count 3 times
</div>


b1.PNG

<div>
Obviously I am missing something here.<br />
This is what I understood regarding your requirement.<br />
<br />
For each week in column B, count the occurrences of all the single digits used in the numbers in the range <b>BF6:BF16</b>. Right?<br />
So the <b>DY5:DY14</b> should contain all the single digits found in the range <b>BF6:BF16</b> and <b>DZ5:DZ16 </b>should contain the occurrences of each single digit listed in <b>DY 5:D14</b>, of course after sorting them in descending order on column DZ. Right?<br />
<br />
Or the requirement is something else. Lol<br />
Sorry! If I am not getting it. :)
</div>


<div>
apart the sort &nbsp;<br />
<br />
all is working as needed <br />
<br />
<br />
but welcome any idea from you
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
i will help you get it &nbsp;let me explain
</div>


<div>
Can you just explain why DY13 and DZ13 contain 5 in them?
</div>


<div>
For each week in column B, count the occurrences of all the single digits used in the numbers in the range BF6:BF16. Right?<br />
<br />
yes you rigth <br />
<br />
<br />
one week &nbsp;then count all the digit of that week
</div>


<div>
That's what I am asking. Where is the 5 in BF6:BF16?
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
Can you just explain why DY13 and DZ13 contain 5 in them?<br />
<br />
Yes &nbsp;!!<br />
<br />
Im looking for the top &nbsp;repeat only in this situation
</div>


<div>
as &nbsp;the first 2 digit &nbsp;are &nbsp;for my<br />
<br />
the top pair<br />
<br />
and the first 3 digit are <br />
<br />
then an 3 digit &nbsp;top<br />
<br />
then thats what;s i need
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
let me know is &nbsp;you get it <br />
<br />
<br />
after all the count the most <br />
repeat are my &nbsp;guide to work with
</div>


<div>
Never mind. It hardly matters if I am not able to understand your requirement as it seems to be a tricky one. :) <br />
But the point is you have got a working solution. :)
</div>


<div>
the count show in vertical way <br />
let me see the most <br />
2 repeat then the 3 most repeat<br />
<br />
then i use like an mark
</div>


<div>
after see then vertically<br />
<br />
i then put horizontally<br />
<br />
but the first 2 &nbsp;and first 3 <br />
<br />
because that make an mark to follow
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
I hope you keep the great job and you always welcome!<br />
any time any question
</div>


<div>
Thanks for addressing the point Martin! Much appreciated.<br />
All I want to know that why there is 5 in DY13 and DZ13?
</div>


<div>
So the DY5:DY14 should contain all the single digits found in the range BF6:BF16 and DZ5:DZ16 should contain the occurrences of each single digit listed in DY 5:D14, of course after sorting them in descending order on column DZ. Right?<br />
<br />
yes
</div>


<div>
Neeraj , most the the weeks seem to be correct, but in the range you mention, there is an error since there are no 5's so DZ13 should be zero. Let me take a look.<br />
<br />
When I fix it I'll be happy to have the question opened again so we can split the points.
</div>


<div>
Subodh Tiwari (Neeraj<br />
<br />
you rigth something when wrong here<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268470/b2.PNG" target="_blank" title="b2.PNG (7 KB)"><img alt="b2.PNG" class="file-block lazyload" style="max-width: 318px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268470/b2.PNG" /></a>
</div>


b2.PNG

<div>
It took long to get the issue I was talking about. Was I so bad in explaining it? :)
</div>


<div>
Neeraj, please see post ID: 42454529. I dleted the original one and reworded post ID: 42454529.
</div>


<div>
should be like this<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268471/b3.PNG" target="_blank" title="b3.PNG (27 KB)"><img alt="b3.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268471/b3.PNG" /></a>
</div>


b3.PNG

<div>
Yes, I saw that post Martin.
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
<br />
don't say that<br />
<br />
im not an expert like yours <br />
<br />
but glad you area around<br />
<br />
MArtin i know try to make a fast solution
</div>


<div>
Here is the file. Please click the button &quot;Count Numbers' to populate columns DY:DZ.<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268473/GetNumerCount.xlsm" target="_blank" class="file-inline" title="GetNumerCount.xlsm (2.3 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>GetNumerCount.xlsm</a>
</div>


GetNumerCount.xlsm

<div>
@Adriana<br />
<br />
I am questioning myself not anybody else. &nbsp;:)
</div>


<div>
Great! :)<br />
Did you check the file I uploaded?
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
Yes is working as should be !!<br />
<br />
can &nbsp;help with 2 minor issues<br />
<br />
1- the sort can be minor to mayor when repeat count are ??<br />
<br />
2- can be &nbsp;the first 2 &nbsp;and first 3 be show &nbsp;?
</div>


<div>
I'm sorry but while my solution isn't totally correct, I don't thing Neeraj's is either. I his workbook take range BF1512 to BF!523. There are 8 4's in that range, so cell DZ1513 should be 8 and not 7. Unless I don't understand what's needed.
</div>


<div>
<blockquote>
1- the sort can be minor to mayor when repeat count are ??
</blockquote>
Right now the sort order is Descending on column DZ. Do you want it to be in Ascending order?<br />
<br />

<blockquote>
2- can be &nbsp;the first 2 &nbsp;and first 3 be show &nbsp;? 
</blockquote>
Can you explain this? Do you want to show only top 2 in column DY:DZ?<br />
<br />
Run the code in the file I uploaded, delete the values from DY4:DZ11 and manually show your desired output then.
</div>


<div>
1- i mean the sort of the number show by the count<br />
<br />
example here &nbsp;<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268477/b1.PNG" target="_blank" title="b1.PNG (87 KB)"><img alt="b1.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268477/b1.PNG" /></a>
</div>


<div>
9 <br />
6<br />
2<br />
<br />
count 3 times the same
</div>


b4.PNG

<div>
then the order of the digit &nbsp;should be <br />
<br />
2 <br />
6 <br />
9
</div>


<div>
2- can be &nbsp;the first 2 &nbsp;and first 3 be show &nbsp;?<br />
Can you explain this? Do you want to show only top 2 in column DY:DZ?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268479/b5.PNG" target="_blank" title="b5.PNG (29 KB)"><img alt="b5.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268479/b5.PNG" /></a>
</div>


b5.PNG

GetNumerCount-v2.xlsm

<div>
column EA need show the top horizontally
</div>


<div>
@Adriana<br />
<br />
It is 1:17 AM here so I will log off now and will look at it tomorrow. Hope that's fine with you. :)
</div>


<div>
You are 2 &nbsp;are the best !! Expert<br />
<br />
you 2 understand &nbsp;my solution need<br />
<br />
some times is not that easy<br />
but working togheter<br />
<br />
make the great difference
</div>


<div>
Tomorrow I will let you know if I need you to explain anything else.
</div>


<div>
Subodh Tiwari (Neeraj)<br />
<br />
yes for sure i really apreciatte you &nbsp;time and big help<br />
<br />
have a good rest !
</div>


<div>
Martin <br />
<br />
you with me always<br />
<br />
i know you doing the best not now but always
</div>


29081674c.xlsm

<div>
Martin will need the same but in column <br />
DC &nbsp;AND DD
</div>


<div>
I'm glad you have what you need for DY:DZ and I think DC/DD should be a new question. Please request attention for this question and have a moderator reopen the question so that you can give part of the points to Neeraj.
</div>


<div>
Best Experts &nbsp;!!!<br />
<br />
&nbsp;Great JOB !!
</div>


<div>
<div class="content wysiwyg-content">
column <br />
DY &nbsp;DZ &nbsp;<br />
<br />
is the each count number<br />
<br />
from column BF<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268371/asasasasas11111111.PNG" target="_blank" title="asasasasas11111111.PNG (125 KB)"><img alt="asasasasas11111111.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/800_1268371/asasasasas11111111.PNG" /></a><br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268372/0001101010101.PNG" target="_blank" title="0001101010101.PNG (13 KB)"><img alt="0001101010101.PNG" class="file-block lazyload" style="max-width: 499px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268372/0001101010101.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268370/678965456.xlsx" target="_blank" class="file-inline" title="678965456.xlsx (2.3 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>678965456.xlsx</a>
</div>
</div>


678965456.xlsx

column 
DY  DZ  

is the each count number

from column BF





count  each number column

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.