Inserting a row
This seems to work except when there is a single instance interspersed in the
data.
If there is a single instance, it appears to insert 2 rows above the 1st
difference and none above the 2nd.
3279090
3279090 TRUE
3280000 FALSE
3299880 FALSE
3299880 TRUE
3299880 TRUE
Otherwise, that was a very interesting trick.
--
Kevin Vaughn
"Herbert Seidenberg" wrote:
Or without VBA...
Enter this formula at B2 and copy down:
=--(A1=A2)
Copy Paste Special Value
Go To Special Column Differences
Insert Entire Row
|