Hello,
I'm in need of an excel ninja as I have a few hundred items that have been put into an excel sheet but have came from 5 different places and they have been arranged in 5 different columns but some of these items have duplicates and need some sort of formula or idea of being able to have all the duplicates to arrange together on the same row and if there are not any duplicates then I would like them have all the non-duplicated parts pushed under the duplicate's?
any ideas or something similar that could help me out would be helpful,
thanks Dean.
Bookmarks