OK, I will give that a whirl.....Thanks
If you happen to figure out how I can compare partial matches then I would love to know. Im guessing that its not possible!
Thanks again
Jamie
Thanks Luke.
Would that work essentially the same as CONCATENATING all of the cells and then checking for duplicates in the concatenated column?
Im a novice, so im just trying to undertsand what the formula would do.
Thanks!
Luke M. Thanks for your post. I checked that out and I don't think that will work for this issue. I'm not actually looking to delete any duplicates, but only to identify them.
But I guess the key difference is that I do not want to compare 'individual cells', but actual full rows against...
Hi Guys,
Wonder if someone can help me with this one.
I have a large array of data, with each line representing a number of values which are very similar, but generally not identical.
I would like to highlight full rows in the array which are identical. Is this possible to compare rows...