thanks Dan,
or even =Countif(A$1:E$999,Row()) and copy that down 100 rows
(for data 1 to 100)
Dan Wrote:
you could use CountIf function on excel.
e.g CountIF("A1:A500", 1) which will should how many time 1 appear
from
range (A1 to A500).
"Kevin Schultz" wrote:
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?
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=473267