Forum Discussion
Change a cell name based on a duplicated value
Hi! Can anyone help me solving an issue? I need all cell values from column 1 to be replaced to have the same name if the cell values from column 2 are the same (example below). GROUP ...
=IF(COUNTIF($B$2:$B$13,B2)>1,"Excel",A2)Maybe with this formula which seems to work in my sheet.