PDA

View Full Version : [SOLVED] Detect the same value on cell and merge them



rong3
10-01-2017, 08:23 PM
Anyone suggest me a solution for this as theard name. Thanks

YasserKhalil
10-01-2017, 09:32 PM
Hello
Your request is quite unclear. Can you give more details and attach sample of your data?

rong3
10-01-2017, 10:54 PM
Hello
Your request is quite unclear. Can you give more details and attach sample of your data?
Hi, sorry for unclear question.
I have two columns A and B that as suppliers and the code of goods as image below.
So i want to check if the column A has the same value with each other then merge all same suppliers for clearly view.

20538

mdmackillop
10-02-2017, 02:33 AM
Post a realistic sample in a workbook. Your "Example" does not show how data is set up, ordered or otherwise organised

Bob Phillips
10-02-2017, 03:06 AM
Do you mean something like this

20543

This is achieved with conditional formatting, select all the cells to be managed, and use a formula of =E2=E1, with the format of font colour set to white

20544

rong3
10-03-2017, 02:13 AM
No, it is about merging all the same data on column into one. But thanks for all, i solved.

mdmackillop
10-03-2017, 02:38 AM
Please post your solution for the benefit of others.