I have a line of results (text based) that I would like to have a formula show if there are duplicates appearing.
One Five Six Eight ( This would be a False returm)
One Two One Six ( This would be a True return)
I could do this with an IF nest but thought there might be a duplicates formula to simplify it.
Cheers
A
Andrew
andrew.mcmillan@det.nsw.edu.au
Technology Adviser
Dept. of Education and Training
Deniliquin District
New South Wales
Australia
One Five Six Eight ( This would be a False returm)
One Two One Six ( This would be a True return)
I could do this with an IF nest but thought there might be a duplicates formula to simplify it.
Cheers
A
Andrew
andrew.mcmillan@det.nsw.edu.au
Technology Adviser
Dept. of Education and Training
Deniliquin District
New South Wales
Australia
