how to search for two consecutive cells that have 2 different values?

Because I am working with a very large sheet of excel and i need to find in a specific column the last 1 before changing to 0.

is there a way to search for that ? how to search for two consecutive cells that have 2 different values ?