Forum Discussion
Nonrepetitive Sorting Function
I am working with a large volume of data, and I want a function that will be able to scan through my data and look for id tags, then copy that tag and place it in a new column. An important element of this formula is that it doesn't repeat id tags, that is, once it finds an id tag, it skips every other id tag that matches that first id tag What this will do is scan through a column of data, and then make a new column that contains one row for each unique tag. I have been trying to find something that can do this and so far I have been unsuccessful. Hoping someone on here will be able to point me in the right direction. Thanks!
Andrew
- please create a sample excel and clear the output you need. I will follow you.
I need a formula that will look through the list above and then put the items out, such that it doesn't repeat entries. For instance, there is only one instance of food in the list below, even though there are multiple entries above.
Please go through the attached file.
