Hi,
Instead of using array formulas, I'd do a very quick Pivot Table and drag the Fruit to the Row box. Then you can copy and paste, using values only the unique values in the fruit column. No formulas needed if you know about Pivot Tables.
Hi,
Instead of using array formulas, I'd do a very quick Pivot Table and drag the Fruit to the Row box. Then you can copy and paste, using values only the unique values in the fruit column. No formulas needed if you know about Pivot Tables.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks