loads of data to search and sort

[Alan]

Have a spreadsheet with over 40,000 rows with a multitude of information

Data has been entered in sequential number fashion and 8 seperate rows
should be recorded for each entry, however having looked through some of the
data several items have mbeen missed

I am looking for a solution that searched column A, if there are 8 sets of
information to the one reference, then the rows are hidden or moved otherwise
the remaining rows of 7 or less inputs remain to be audited and updated.

This process has to be applied to all the 40000 rows of data ???

Any help would be appreciated

Many thanks

 

[Frank Kabel]

Hi
try in a helper column (e.g. column D) the following formula:
=COUNTIF($A$1:$A$40000,A1)
and copy this down for all rows (you may want to disable automatic
calculation though)

After this filter all values wich ware not equal to 8