loads of data to search and sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data set filtation 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Conditional Formatting using blocks of rows 7
Search and Combine Rows 4
Searching data in multiple rows using search criteria 2
complex sort search and replace macro 2
re-organize data in fixed blocks 3
Sorting and grouping data with varying number or rows 1

Back
Top