Hello Everyone,
Hope you are fine.
I have a spreadsheet and there is a column contain duplicate value. Pls find below for example
<tbody>
</tbody>
I need a formula in B1 where result should be like below:
<tbody>
</tbody>
I want duplicate should be count once. Pls help
Let me know if you need any further information.
Regards
Rahul
Hope you are fine.
I have a spreadsheet and there is a column contain duplicate value. Pls find below for example
A | B | C | D | |
1 | 1200 | |||
2 | 1500 | |||
3 | 1200 | |||
4 | 1700 | |||
5 | 1200 |
<tbody>
</tbody>
I need a formula in B1 where result should be like below:
A | B | C | ||
1 | 1200 | True | ||
2 | 1500 | True | ||
3 | 1200 | Already Exist | ||
4 | 1700 | True | ||
5 | 1200 | Already Exist |
<tbody>
</tbody>
I want duplicate should be count once. Pls help
Let me know if you need any further information.
Regards
Rahul