PLease see attchemnt for explanation of formula needed.
I have cloumn B that has some identical lot numbers, one for good production and one for bad scrap, I need a formula to find the matched lot numbers and will add the good into the same row as the bad scrap
Bookmarks