Extract changes in value from list in excel

[Brandt]

Good day all

I made a list of 110000 rows but, only every 220 or so the value in row A changes. I want to be able to extract those rows. Is there a formula or method to do this. Please see uploaded file for example.

 

[vletm]

Brandt
A-column value seems to change in every row.
Which A-column value steps would You extract those rows?

 

[Brandt]

Thank you for your reply. I would like to extract the rows when it changes from ex. 0.00 to 0.01 to 0.02 etc. it goes up to 4.76 and I need a list of every event when it changes.

 

[vletm]

Brandt
'one possible' ...
1)
for Cell D2 =ISODD(INT(LEFT(A2,5)/0,005))
for Cell E2 =IF(AND(D1=FALSE,D2=TRUE),TRUE,"")
copy both formulas down
2)
Do Filter from columns A:E to find E-columns TRUEs
and You'll get those '0.01'-steps

 

[Brandt]

Thank you very much will give it a try....

 

[vletm]

Brandt
... if You would like to try other method,
(eg no need to copy 110000 rows formulas)
then press [ Do It ].