Statistics of Random Numbers

[Hlias]

Hello there m8's.
This is my first time in this forum and I'm really excited with your knowledge.
I was try to find in to many posts an answer for what I need but there are so many of them that is not possible to find what i need if this what I need is possible.

So. I have two rows in a sheet with random numbers (1 till 90).
Those numbers in those two rows I change them every 5 minutes with new one still from 1 to 90
I need a "way", in one side of my sheet (lets say in column B) to count how many times a number was repeated after finish my work (example after 2 hour's)

Is that possible with excel 2007 ?

I hope you understand my bad English

[JBeaucaire]

You won't be able to do this with normal worksheet formulas, you will need a macro.

How are the values in the two rows getting changed? A macro can be triggered many ways.

If you are manually entering numbers, we could use a Worksheet_Change() macro to watch those rows and increment the correct value in column B each time you enter a value by hand.

If the values are coming in some other way, we might still be able to use a Worksheet_Change() macro to do it, or a simple basic macro that you can trigger manually whenever you want to increment the column B totals.

What would be your preferred method/frequency of triggering a macro to do the counting for you?

[Hlias]

Macro sound's good.
I was try to make one but I don't know how. The only think that I was make
(after some changes from an example in this forum) was some button's each one different number (90 of them) and every time I had to push for changing +1 the amount of this concrete number at B. But this take's me to long time.
The best way to do is copy the whole row from site and paste in my workbook.

Those numbers at those rows I'm writing by hand or copy/paste from a site (I think this "copy/paste" you can say it's also by hand)

Thank for your answer and your time !!

[JBeaucaire]

OK. A few things...

Can you post up the actual workbook so the macro I create will work first time out of the gate?

Can you change the entries in column A to just read:

1
2
3
4
etc...

Make sure the uploaded doc accurately shows which cells have to be "watched" by the macro if it differs from the example given above.

[Hlias]

Hello again.

This is how I want to look the "end product".
I was inserted and some numbers only to show you how it will works (you can delete them all).

I hope that I was understand what you want to send you and send the right thing.

[JBeaucaire]

Please Login or Register  to view this content.

I had to fix the data range for the chart, but this seems to work now.

[Hlias]

“Actually, I *am* a rocket scientist.” - JB

NO !!!! YOU ARE A STAR !!!!!!!

Thank you, thank you, thank you !!!

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)