Excel unique value in range

Excel unique value in range Hi I need to ensure the values unique in range with if possible with a high performance way. Sample data as shown below:
Asked by: Guest \| Views: 264

Total answers/comments: 1

Comments display order:

Guest [Entry]

"{=IF(SUM(((A6>=$A$1:A5)*(A6<=$B$1:B5))+((B6>=$A$1:A5)*(B6<=$B$1:B5)))>0,""OVERLAP"","""")}

If you put this in C6 and you put your next numbers in A6 and B6, C6 will say 'overlap' if any do.

Don't type the curly braces {}. Instead enter the formula using control+shift+enter, because it's an array formula."