Deleting single number

[HelpExc]

Hello, how can i delete single numbers and keep numbers which are in succession.
Untitled.png

[alansidman]

I think that you need to provide more information. What is the logic behind the deletion and keeping? What is the rationale?

[oeldere]

Please Login or Register  to view this content.

and drag down.

Then filter on 1 and delete those rows.

[HelpExc]

I think that you need to provide more information. What is the logic behind the deletion and keeping? What is the rationale?

I need to delete single numbers example if number 8 will be located in cell A3 and if this same number(8) will not be located in cell A2 or A4 then this number 8 in cell A3 has to be deleted

[HelpExc]

Please Login or Register  to view this content.

and drag down.

Then filter on 1 and delete those rows.

Nice work

[oeldere]

Glad i could help.

Thanks for the reply.

If not done yet, will you mark the question solved if it is solved?