Hi Guru's,
I have a 10k++ series of data containing same order number with different product. I want to sort same order number with different product only(example: to show 1001, 1002 & 1003 only)by using excel function but somehow I couldnt get the answer I want. Please help
Order no. Product
1001 Toys
1002 Mee
1002 Beer
1003 Chips
1001 Apple
1001 Juice
1003 Jelly
1007 Coke
1001 Banana
1008 Bread
1009 Chicken
Bookmarks