Ahhhhh I get it, hahahaha. Lemme see if it will work

 

So do I have to type all the numbers I am dealing with in E then?

 

All of the numbers that you want to lookup.

 

Use the Mode function.

Remember Mean Median and Mode from school?

 

YEa, that still means I have to go through 2000 numbers

 

Can I post?

 

The easist way is in Access.

In excel - name the number colum "myNumbers"

Close excel

Open access - click c_reate new database

Import the data from excel into a new table called myNumbersTable

Create a new query - change the view to SQL

Type in: (see picture)

Now click save - and give the query a name. Run the query.

You will get each number and the number of times it shows up.

Copy the result

Open excel

Paste.

Access is the best tool for aggregating data... it's not that hard to learn either... and will save you a lot of time in the future.


[IMG]local://upfiles/9650/B4D8BA032EE34B9A8CFF0EA624A4F9D6.jpg[/IMG]

 

So I download access then I take it?


I will definitely give it a try.

 

Many versions of the office software come with Access. If you don't have it, you won't be able to get it cheaply/legally... it's part of the office suit.

It it certainly a tool I recommend to anyone dealing with that type of data at all frequently.

It is my job to move data around... so I must use SQL, and one common desktop software is Access. I use other databases as well, but they aren't going to be as easy to use for the normal person.

The alternative that is free might be in Open Office called "Base" - but that is one database tool I have not used. It looks, as do all the other tools, like a Microsoft clone.

http://www.openoffice.org/

http://download.openoffice.org/index.html

It is a free to use, open source office suit... it has tools that do 90% of what the MS Office suit can do... and it's legally free.

 

Maybe I'm just being dumb, but can't you either cut 'n paste the numbers in, or export them from one program to another ? No flames, please, I'm looking for answers too. I did a merge once.....he he