Microsoft Excel 2007 Question

soccerdude · 01-26-2008, 03:59 PM

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.

soccerdude · 01-27-2008, 06:05 PM

Anyone?

I-KILLED-U · 01-27-2008, 07:50 PM

i dont think anyone is going to be able to help you without actually seeing it or doing it.

soccerdude · 01-28-2008, 10:03 PM

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?

soccerdude · 01-29-2008, 01:13 AM

This is exactly what I want to do except in Excel 2007. http://www.mrexcel.com/tip092.shtml

Does this help?

INTELCRAZY · 01-29-2008, 02:30 AM

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?

cosine4 · 01-29-2008, 03:11 PM

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.

Trizoy · 01-29-2008, 04:12 PM

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?

soccerdude · 01-29-2008, 11:01 PM

Ok I got it thanks Trizoy.

01-26-2008, 03:59 PM	#1 (permalink)
soccerdude Platinum Member Join Date: Jul 2006 Posts: 804	Microsoft Excel 2007 Question 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.

01-29-2008, 04:12 PM	#8 (permalink)
Trizoy VIP Member Join Date: Apr 2005 Location: Campbell, Ca Posts: 4,647	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? __________________ 01100110 01100001 01110010 01110100

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Microsoft Office 2007.....is it any good?	ADE	General Software	17	10-27-2006 10:37 PM
Quick Microsoft Office Question	kgod86	General Software	4	10-19-2006 08:55 AM
Different Excel Question	magicman	General Software	2	09-02-2006 06:08 PM
page error question????	rhondas	Operating Systems	12	02-11-2006 12:59 PM

01-27-2008, 06:05 PM	#2 (permalink)
soccerdude Platinum Member Join Date: Jul 2006 Posts: 804	Anyone?

01-27-2008, 07:50 PM	#3 (permalink)
I-KILLED-U Silver Member Join Date: Dec 2007 Location: Sunshine State Age: 26 Posts: 149	i dont think anyone is going to be able to help you without actually seeing it or doing it.

01-28-2008, 10:03 PM	#4 (permalink)
soccerdude Platinum Member Join Date: Jul 2006 Posts: 804	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?

01-29-2008, 01:13 AM	#5 (permalink)
soccerdude Platinum Member Join Date: Jul 2006 Posts: 804	This is exactly what I want to do except in Excel 2007. http://www.mrexcel.com/tip092.shtml Does this help?

01-29-2008, 02:30 AM	#6 (permalink)
INTELCRAZY banned Join Date: Feb 2007 Posts: 6,060	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?

01-29-2008, 03:11 PM	#7 (permalink)
cosine4 New Member Join Date: Dec 2007 Posts: 14	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.

01-29-2008, 11:01 PM	#9 (permalink)
soccerdude Platinum Member Join Date: Jul 2006 Posts: 804	Ok I got it thanks Trizoy.