Re: Excel question

Monica,

I can't know why your rows sometimes duplicate themselves, but here's
one way to find duplicate rows. I've used ZZ to indicate the last
column, you should use whatever that column is instead of ZZ. This
method is not slick or elegant, but it should work.

1. Sort your data, using any column as the primary key
2. Insert a new column A
3. Enter this formula in cell A2: =AND(B1=B2,C1=C2, ... ,ZZ1=ZZ2)
4. Copy cell A2, and pasted it down into from row 2 to the last row of
column A.
5. The value in for each cell of column A will display as TRUE for any
line that is a duplicate of the line above, FALSE otherwise.

HTH, PM

Monica Mack wrote:
> I've got a strange problem that I've seen happen a couple of times
> now, but can't figure out how, hoping someone here can help.
>
> I create spreadsheets with several columns and rows. A couple of times
> now several of the rows duplicate themselves so I end up with
> duplicate data. If I catch it, there isn't an easy way to delete the
> duplicate rows. Unfortunately I didn't catch it the last time and it
> has caused all kinds of havoc since I used it to upload data into our
> database.
>
> Any help would be appreciated.
>
> Thanks in Advance,
> Monica
>
>
> ------------------------------------------------------------------------
> The following was automatically added to this message by the list server:
>
> For information about Micronet, including subscribing to
> or unsubscribing from its mailing list and finding out
> about upcoming meetings, please visit the Micronet Web site:
> <http://micronet.berkeley.edu/>.
>

-- 
Paul Mackinney
2111ABC Etcheverry Hall
University of California at Berkeley
Berkeley, CA 97420-1740
510/643-0106
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.