On 5/6/08 4:20 PM, in article
76DDFF66-72B2-4898-A038-F2DAA033C830@[EMAIL PROTECTED]
"bill_jba"
<billjba@[EMAIL PROTECTED]
> wrote:
> Bob:
>
> Thanks so much for your help. Sounds straight forward, but
unfortunately I
> don't get it.
>
> I added the 2 new columns and placed the formula as you suggested in the
1st
> new column. I assume I should copy/paste to fill the entire 1st new
column
> with that formula.
Yes
> In the next column, can you help me understand what "sequential numbers"
> representing the row should be?
The sequential numbers were to represent the original rows, so you could
sort it back if needed. Just enter a row number in one cell, then the next
row number in the cell under it, and then drag to the bottom of the range.
> Then it sounds like you suggest using a 3rd column for the =x2=x1
formula???
Yes, after the data is sorted, this will find the duplicates.
> How would I search for TRUE...by typing in the fx box right?
Yes, or highlight the column and then use edit find.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
|
