Dear Excel Community
I would like to use VBA code to
to find duplicate entries and 2 criteria should be checked and another column. Last but not least, I would like to see the result of the text in one of the columns.
column D (article numbers 51541, 51541 , 51542, 51544 etc.)
find duplicates here first
As soon as a duplicate is found
E.g. 51541 - should be searched for in column B according to 2 criteria, namely "Web" and "Flyer", which are shown as text in column B respectively and e.g:
Column B / Column D
1. advertising november flyer / 51541
2. advertising november web / 51541
If both criteria are present/fulfilled, then please add/show "web and flyer" in column C with text. Here is the example:
Column B / Column C / Column D
1. advertising november flyer/ web and flyer / 51541
2. advertising november web / web and flyer/ 51541
I am hoping for a super simple VBA macro solution and am open to ideas.
Thank you in advance for your time and help and I look forward to seeing the solution.
Bookmarks