Excel users... help me

TheSneakiness · 10-10-2005, 03:22 PM

I'm going to try my best to explain what I wanna do In Excel to sort something out...

I have a list of numbers, some are repeated more than twice. I want a formula that counts the numbers and the number that comes up the most I want to display in a different cell, and not how many times it comes up.

I couldn't find anything in Excel that could help. If someone does, let me know, I'm blind.

Danny · 10-10-2005, 03:27 PM

No excel Users here. Try the Hyundai Forums

:

Sorry, Im pretty shockin at Excel too

TheSneakiness · 10-10-2005, 03:30 PM

Quote:

Originally Posted by Danny

No excel Users here. Try the Hyundai Forums

:

Sorry, Im pretty shockin at Excel too

You know, that's pretty clever. Would've never thought of that.

EA2BA · 10-10-2005, 03:30 PM

well first you have to unique the list, then use that to count the numbers, then use a formula base on the outcome to show only those numbers, more then likely a macro i think is what you need, if it is to be repeated many times.

my username AThotmail.com on MSN if you want some help.

TheSneakiness · 10-10-2005, 03:31 PM

Hang on, I found something that may work...

neb · 10-10-2005, 03:31 PM

easy one.... =MODE

TheSneakiness · 10-10-2005, 03:32 PM

Quote:

Originally Posted by neb

easy one.... =MODE

Yeah, found it eventually.

:

FPV329 · 10-10-2005, 03:33 PM

Do a google search, I needed a calender to save a lot of typing and a quick search got me a beauty!

10-10-2005, 03:36 PM

Perhaps the =Count fucntion?

This sounds like a statistical problem.

in any cell press = then, up the top, next to the tick, cross, and fx; there should be a pull down box, click on "more functions."

Edit - forget about me...

TheSneakiness · 10-10-2005, 03:51 PM

New one for y'all...

I want to get values between two numbers, and display how many times a number between the two numbers comes up.

EA2BA · 10-10-2005, 03:54 PM

so you have 10 and 200 you want a count how many numbers are between 10 and 200 in a random list of numbers ?

TheSneakiness · 10-10-2005, 03:55 PM

This is my example...

I have a list of shed widths. I want to see how many widths come up between two numbers (9 and 10). So 9.01, 9.02 comes in between those two numbers.

EA2BA · 10-10-2005, 03:57 PM

well i usually just run a colum besdie to mark the cells with an "X" that meet the criteria I want then count the "X"'s if it is a quick thing.

TheSneakiness · 10-10-2005, 04:00 PM

Quote:

Originally Posted by Dellboy999

well i usually just run a colum besdie to mark the cells with an "X" that meet the criteria I want then count the "X"'s if it is a quick thing.

Make it sound so easy. I'm trying to be a smart-****.

EA2BA · 10-10-2005, 04:09 PM

=IF(A2>=9,IF(A2<=10,"X",""),"")

then run a count =COUNTIF(B2:B8,"X")

TheSneakiness · 10-10-2005, 04:12 PM

Quote:

Originally Posted by Dellboy999

=IF(A2>=9,IF(A2<=10,"X",""),"")

then run a count =COUNTIF(B2:B8,"X")

I'll try that then. Thanks.

EDIT - Some reason I can't get it to count properly. I'll just keep trying different things.

DOC · 10-10-2005, 04:42 PM

Quote:

Originally Posted by AUII_SE_Ute

I'll try that then. Thanks.

EDIT - Some reason I can't get it to count properly. I'll just keep trying different things.

hI Bud, i work on excel for a living ( in my spare time ) PM me you email address and ill send you an email for you to attach it to and send to me, and ill sort it 2 seconds for you and even get it to sing happy birthday if you want

cheers
Pete

try this ( adjust range to suit )

. =COUNTIF(D8

24,">9")-COUNTIF(D8

24,">10")

the faces should be a semi colan ( : )

FGX-351 · 10-10-2005, 06:08 PM

press f5 or f4(cant remember which one) then under reference type in caps X97:L97, then press enter or click ok...ect then when ur back in the spreadsheet after that press tab once i think it will come up m97, then push ctrl, alt, shift and click on the wizard bar graph icon at the top right at the same time, then a hidden version of flight simulator will open up, left click is forward, right click is backward and steering is with the mouse....enjoy

TheSneakiness · 11-10-2005, 08:42 AM

Quote:

Originally Posted by DOC

hI Bud, i work on excel for a living ( in my spare time ) PM me you email address and ill send you an email for you to attach it to and send to me, and ill sort it 2 seconds for you and even get it to sing happy birthday if you want

cheers
Pete

try this ( adjust range to suit )

. =COUNTIF(D8

24,">9")-COUNTIF(D8

24,">10")

the faces should be a semi colan ( : )

OK, thanks Pete. If this works, I'll have to buy something off you.

EDIT - Well, well, well. It worked. Order coming Pete.

DOC · 11-10-2005, 11:38 AM

Quote:

Originally Posted by AUII_SE_Ute

OK, thanks Pete. If this works, I'll have to buy something off you.

EDIT - Well, well, well. It worked. Order coming Pete.

AU11_SE_UTE, Just read this, my help was not in intention of getting an order, the help was without obligation and you should only order if thats what you want to do, not because of any help.

Glad it worked for you and if you need any further help ( without obligation ) please ask.

Pete

TheSneakiness · 11-10-2005, 01:46 PM

Quote:

Originally Posted by DOC

AU11_SE_UTE, Just read this, my help was not in intention of getting an order, the help was without obligation and you should only order if thats what you want to do, not because of any help.

Glad it worked for you and if you need any further help ( without obligation ) please ask.

Pete

Nah, nah, nah. I need to get some cleaning products anyway Pete. Gotta have the car looking good for Indy.