Kevin Schultz

Posts: n/a

Sorting numbers, please help?

I ahve a spreadsheet that contains 5 columns of whole numbers rangeing from 1
to 100. I need to count how many times each number appears in each column or
even in all 5 columns together. Ex. the number 1 appears 252 times, etc.

Does anyone know how to sort the data that way? I have imported into an
access table as well if that's easier.

Please help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting Numbers with Multiple Decimals (cont.)	Intern Ian	Excel Discussion (Misc queries)	5	September 21st 05 12:04 AM
Sorting numbers with brackets	Itsy	Excel Discussion (Misc queries)	4	August 7th 05 11:07 PM
Sorting alphanumeric numbers	maurice.centner	Excel Discussion (Misc queries)	2	May 6th 05 02:00 AM
Sorting when some numbers have a text suffix	confused on the tundra	Excel Discussion (Misc queries)	5	December 18th 04 10:19 PM
Sorting imported "numbers"	Confused on the tundra	Excel Discussion (Misc queries)	5	December 17th 04 07:33 PM

All times are GMT +1. The time now is 07:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us