One is to use the IF function (set the IF function in the cell on the line), but the file is larger, if the data is not much, this method is simple;

The other is a macro (VBA), suitable for big data (tens of thousands of lines is not a problem).

I am still building with VBA macro method, the efficiency is very high, the file is very small, you can manage tens of thousands of lines of data.

Can Q me 1227898574.