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 o...
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.
It works splendidly! The only problem I am having is that in the first line I have a zero displayed instead of the first item. I was very careful to copy your formula exactly, So I am not too sure what I am doing wrong. This is a minor inconvenience, however. Thank you for the help!
Andrew
