stuckagain22
Board Regular
- Joined
- Aug 4, 2006
- Messages
- 183
I have a sheet that I want to auto sort the data in one column into another column.
In Example:
If column A contains:
peach
apple
orange
I want column B to then show:
apple
orange
peach
Is there anyway to do this using a function/formula?
In Example:
If column A contains:
peach
apple
orange
I want column B to then show:
apple
orange
peach
Is there anyway to do this using a function/formula?