Auto Hide a row based on cell contents

[Fred]

Here's a riddle for all the Excel gurus...

How do you automatically hide a row based on the contents
of a single cell in that row?

I have several pairs of records that I need to merge into
a single row. Presently, I am comparing the record ID
(Column A) to the next row's record ID. If they match
then data is extracted from row 2 and placed in row 1.
However I need to produce a report showing only the "odd"
row numbers.

Right now I highlight each row then hide it. But my list
continues to grow daily, and I am looking to automate this
process. Any ideas?

 

[keepITcool]

Fred,

insert a column with a formula that gives a true/false result..

g2=($a2=$a1)
or
=mod(row(),2)

then use data/autofilter on that column..



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >