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.
Thanks for the input, that would work if I was looking for a fixed value if the condition is true, and if my database was small.
| GROUP | CODE | SUM |
| MICROSOFT | 101245128587-7781.777 | 35 |
| EXCEL | 926348178587-8817.987 | 48 |
| WORD | 101245128587-7781.777 | 21 |
| POWERPOINT | 517398175634-2616.827 | 52 |
| SQL | 926348178587-8817.987 | 10 |
My original sheet looks more like this (+2000 rows). How do I change “SQL” to “EXCEL” for example while also changing “WORD” to “MICROSOFT” because they share the same code? Is there a formula for this?