counting the number of equal rows

hi there,

my problem is the following: i have a worksheet with about 8000 rows and 200
columns. i have to find out the row (that has 200 fields) which exists the
most within the 8000. so i thought excel ought to take the first row e.g.
and compare it to the second, the third and so on. after comparing the row
with the last one there should be a counter saying that my "sample-row" is
there xx times. then it should take the second row, compare it to the rest
and so forth.

is it possible to tell excel to do as described?

plz excuse my really bad english, it's been a while...

Hello Malte,

first of all, is there any connection between the rows data in the fields,
or can vary without any relation?

a) might be able to find it using a pivottable?? or
b) using access might be the right way ??
c) or else :-)
please, some examples to be able to tell...

Best regards,
ANdras
(Hungary)

"Malte Lindner" wrote:

> hi there,
>
> my problem is the following: i have a worksheet with about 8000 rows and 200
> columns. i have to find out the row (that has 200 fields) which exists the
> most within the 8000. so i thought excel ought to take the first row e.g.
> and compare it to the second, the third and so on. after comparing the row
> with the last one there should be a counter saying that my "sample-row" is
> there xx times. then it should take the second row, compare it to the rest
> and so forth.
>
> is it possible to tell excel to do as described?
>
> plz excuse my really bad english, it's been a while...
>
>
>