Hello,

Lets say I have a row that has several items with information.

Row 1 (Apples, Apples, Bananas, Pears, Pears, Oranges, Apples) Each item is in a cell.

Can I use the removeduplicates function to remove the duplicates? I know I can use it for columns, but could not use it for rows. Thanks for anyone who helps.