Hi all
I have made an example of my problem:
example.xlsx
I have made a range with data, but i only want to display each unique data entry once and in the same order as in the data set as shown in the example. Is it possible to make an automatic function for this purpose, that I can expand over a wider area whenever my data table is augmented? I cannot use index/match, lookup or something similar, because I don have the required information for these formulas in my real data set.
Best regards
Lasse
Bookmarks