Forum Discussion

ccgbalarin's avatar
ccgbalarin
Copper Contributor
May 06, 2022

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 ...
excel
Formulas and Functions
Macros and VBA
ccgbalarin's avatar
ccgbalarin
Copper Contributor
May 06, 2022

OliverScheurich 

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.

 

GROUPCODESUM
MICROSOFT101245128587-7781.777                          35
EXCEL926348178587-8817.987

                          48

WORD101245128587-7781.777

21

POWERPOINT517398175634-2616.827

52

SQL926348178587-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?

OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 06, 2022

ccgbalarin 

Doesn't the formula for your first question work for a large database in your sheet? I've tried it for 1300 rows and it works perfectly in my sheet.

 

For your second question (your original sheet in which you want to return multiple groups) you can try this formula.

=IF(COUNTIF($B$2:B2,B2)>1,INDEX($A$2:A2,MATCH(B2,$B$2:B2,0)),A2)

 

Resources