what is the formula for excel when cell value changing from 0 to 1, the calculation formula in next cell will start.
=IF(COUNTIF($C$2:C2082, C582)>1, 1,0)
I search for any duplicated items in the column with the above excel formula. Once it meets any duplicates, the cell value will change to "1". Then, I want to start the calculation in another cell. Any ideas, please. Thanks.
I've tried. But I still haven't figured it out.