Microsoft Excel 2007 Question

S

soccerdude

New Member
Hi guys,

I have Microsoft Excel 2007 on my computer and I have a question. I have a list of numbers on a piece of paper. I need to find out how many times the numbers came out by using Excel. Then by doing that I will also need to graph it.

Anyone know how to do this?

Thanks

Btw I know in older versions of office you were able to do it by using a Pivot Table but I find in 2007, the Pivot Table is totally different to use then in previous versions of office.
 
Ok... let me rephrase the question. I have a bunch of numbers and I want Excel to tell me how many times that number has come up. How can I do that in Microsoft Excel 2007?
 
Why don't you give me the list of numbers? And I will make the graph and show you how to do it..

And let me get this straight, you want it to display how many times a given number appears?
 
I am not sure about Excel 2007 but in most other versions the "countif()" function will do this. Then you can just plot the outcome.
 
The pivot table will work perfect for you...

Highlight the numbers
-Insert-->Pivot Table-->Select ok

If you have one column with the numbers in it then drag it into the row and the value section... yes you can use it twice now.

Anything else?
 
You must log in or register to reply here.
Back
Top