if cell value matches then copy another cell
Back to DataCollector's suggestion, why can't you add another column
containing a sequence - i.e. fill it with 1,2,3, etc, then you can
always sort the data back into the original sequence, then remove this
column. Like him, I do similar things with upwards of 40,000 rows, so
3,500 shouldn't create too many problems.
Pete
|