How can I remove all duplicates within a range? In the screenshot below, each blue column has had duplicates removed using the built in function, and the green range is after I manually selected each unique value from the blue.
What I really want is to be able to select a variable-sized range and end up only one instance of each value. Having the results in a single list like the green would be great but it would also be fine if the result was like the second screenshot where the uniques are in their original location.
What I really want is to be able to select a variable-sized range and end up only one instance of each value. Having the results in a single list like the green would be great but it would also be fine if the result was like the second screenshot where the uniques are in their original location.