Hi All,
i need to categorized items just in one formula. attached file will show you what i need exactly. sheet1 all items with duplicate, sheet2 unique item list and sheet3 to show item category shortly not to detail with sizes. there are lot of sizes in specific items but i don't need sizes to categorized.
can anybody tell me formula to categorized this?
Thanks.
Bookmarks