Is there a function in excel to find duplicates

Question

I am not finding duplicates in excel, whenever I try to, it crashes excel. and whenever I try to open it after, it takes time to load, and also it gets down slowly.

Answer 1

1. You can use Conditional formatting inside the home tab with highlight cells rules -> Duplicate values.

2. You can use delete duplicates inside the data tab.

3. Using pivot also you can find duplicates.