Count the number of typing specific number in a cell

[YasserKhalil]

Hello everybody
I have this code that I need to fix .. I want to type numbers in range("A1") and in range("B1") to represent counter for each entry

Say I entered 15 in A1 >> B1 would be 1
Entered 20 in A1 >> B1 would be 1
Entered 15 in A1 >> B1 would be 2
Entered 30 in A1 >> B1 would be 1
Entered 15 in A1 >> B1 would be 3
Entered 20 in A1 >> B1 would be 2
And so on..

I tried this code to store my entries as an array and from the array to count specific items

Please Login or Register  to view this content.

But I can't fix it as my knowledge of arrays is so weak
Thanks advanced for help

[zbor]

Store typed values in other sheet and just use COUNTIF in first sheet.

[YasserKhalil]

Thanks Mr. zbor for this great idea ..
But I need to learn how to use arrays to store values entered in range("A1") and how to restore the count of specific value withing this array
Thanks advanced

[PCI]

YasserKhalil,
Are open to use "Scripting.Dictionary" ?
PCI

[YasserKhalil]

Thanks Mr. PCI
Can you help me doing that ..Using "Scripting.Dictionary"?

[JasperD]

Put in worksheet area of your code (so not in a module).

Please Login or Register  to view this content.

This seems to do exactly what you ask for

Please click the * below if this helps

[YasserKhalil]

Thanks Mr. JasperD for this wonderful code
Try enter 1 and 11 and 1 again .. See the results

[JasperD]

Bad attitude to people who try to help you is never appreciated...
Solution to it is rather simple though.

Please Login or Register  to view this content.

[PCI]

See how next code is working
in the worksheet code

Please Login or Register  to view this content.

in a module

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Mr. JasperD for this magic code
And I appreciate your help of course .. I just put my remarks at first and I won't forget to appreciate you..
Thanks a gain for your great help.

[YasserKhalil]

Mr. PCI
I didn't reply on your post till test it
Really wonderful and works like a charm
Thanks a lot for your help
Thank you for these wonderful solutions

[PCI]

YasserKhlil,
Because you were mentioning the use of array see here a remake with array, just for the fun.

Please Login or Register  to view this content.