Hello All,
Here is the sample DATA in range (B2:B10)
<colgroup><col></colgroup><tbody>
Toyota
Suzuki
Suzuki
Yamaha
Toyota
Toyota
Suzuki
Ducati
Ducati
</tbody>
I want formula in Range (A2:A10)
I am using this formula in cell A2 to return 1 if the condition is met...