spacebouncer
Board Regular
- Joined
- Feb 7, 2014
- Messages
- 109
Hi. I'm trying to write a function to return a range. The function should look through a column, and return only one cell that has each value. Or to put another way, it needs to return a range that includes every unique cell, and just one cell from any that have the same value.
My best idea at the moment is to sort, and if the cell is not equal to the one below, then add it to the range. This seems pretty inelegant, and it would be preferable not to sort. Anyone have any better ideas for doing this? Thanks
My best idea at the moment is to sort, and if the cell is not equal to the one below, then add it to the range. This seems pretty inelegant, and it would be preferable not to sort. Anyone have any better ideas for doing this? Thanks