I have some compressed data in a column in Excel. What I'd like to do is apply a filter expression to it that eliminates all the values that are repeated somewhere within the column, so that I'm just left with a list of values that are present without any repetition. So, for example:
The above filtered would return 27, 26, 26.5, 25.5, and 25. To be clear, I'm not just trying to eliminate repeated values that appear consecutively using something like ''PrevVal('tag1','*') <> 'tag1', I'm trying to eliminate repeated values for the entire column and just return the first instance of that value or any singular instance, the presence of the value is what's most important to me not the time at which it occurred. The numbers correspond to a certain type of condition, and I just want to which conditions were present during the time range. I feel like this should be doable, I just don't know the expression to get it done and I can't seem to find an example of someone trying to do something similar through my searching.
Any help anyone can provide would be greatly appreciated.