i have two sets of data and i would like to combine into one.
Problem is some may have duplicated part number.
my current method is copy & paste data from 2 different tab in to one and using data, remove duplicated to get what i needed
just wondering if there is a better way to have it done by formula w/out using code
any suggestion is appreciated.
Bookmarks