Anyone suggest me a solution for this as theard name. Thanks
Anyone suggest me a solution for this as theard name. Thanks
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.
Untitled.png
Post a realistic sample in a workbook. Your "Example" does not show how data is set up, ordered or otherwise organised
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Do you mean something like this
Req.jpg
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
Solution.jpg
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
No, it is about merging all the same data on column into one. But thanks for all, i solved.
Please post your solution for the benefit of others.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'