Hi there
I have found a old thread where "daffodil11" showed a way to find duplicates this seemed to fit my criteria well but I just can not seem to get the exact result I am looking for.
I have a large list of sites on worksheet HOST LIST, I want to return the sites Host Name based on the matching site name provided in column E, due to some sites not being on the Host List yet and having backup services they will have 2 entries in column E so I need to create them with a 1 or a 2 so that the results contain no duplicates. the formula is used in column D2 and copied down.
Below is my current formula and it works if I point it to column to but then if it has duplicate entry the formula only returns 2 for those Host Names
Formula looking at column D
Results = 0
Formula looking at column E
Results = All Host Names with duplicate entries contain -2
example attached.
Please let me know if you need any more ifno.
Thanks
Bookmarks