Hello all,
Here’s a quick question that I hope I could get some help with
------------------------------------------
Say I have this on my worksheet:
(Starting in cell A2, with each new line representing the next cell down . . .)
Apple
Orange
Banana
Banana
Apple
Apple
Apple
Orange
Banana
Mango
Orange
Orange
Is there an *Excel Function(s)* (I'm purposely trying not to do this with VB Code/macros) that will sort through the list and 'remove' the copies to return me sort of an index of the above.
So going off the above list, the function(s) would somehow give me this result:
(Preferably each in its own cell underneath)
Apple
Orange
Banana
Mango
I hope that makes sense . . .
I also don't want to use a Pivot Table, however the effect I'm after, i.e. the way a pivot table condenses a list, removing the duplicates, is the effect I’m after
Basically I want to take a list, and condense it, producing another list which will contain only one instance of each of the values found in the first list.
Can it be done, or do I need to go beyond the simple excel function(s)?
Any help would be greatly appreciated . . .
Thankyou for your time,
Kind Regards,
KJ
Here’s a quick question that I hope I could get some help with
------------------------------------------
Say I have this on my worksheet:
(Starting in cell A2, with each new line representing the next cell down . . .)
Apple
Orange
Banana
Banana
Apple
Apple
Apple
Orange
Banana
Mango
Orange
Orange
Is there an *Excel Function(s)* (I'm purposely trying not to do this with VB Code/macros) that will sort through the list and 'remove' the copies to return me sort of an index of the above.
So going off the above list, the function(s) would somehow give me this result:
(Preferably each in its own cell underneath)
Apple
Orange
Banana
Mango
I hope that makes sense . . .
I also don't want to use a Pivot Table, however the effect I'm after, i.e. the way a pivot table condenses a list, removing the duplicates, is the effect I’m after
Basically I want to take a list, and condense it, producing another list which will contain only one instance of each of the values found in the first list.
Can it be done, or do I need to go beyond the simple excel function(s)?
Any help would be greatly appreciated . . .
Thankyou for your time,
Kind Regards,
KJ