How to Find Duplicates in Excel

[{"selector":"#anim-88aa35d8-9224-4a6f-b8fe-d3df9adaded2","keyframes":{"transform":["translate3d(-241.17648%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-35318c7c-5758-47f9-991e-36f8b443b524","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b74e18b6-cfb9-4612-8031-9bd67e6ee77e","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-75977f47-6360-4a86-9901-10a1b7f6af77","keyframes":{"opacity":[0,1]},"delay":0,"duration":4000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-16da80c7-604b-426b-8d0d-3e00a8c4ce8c [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":4000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Step 1. Click on any cell or in the dataset from which you need to eliminate copies.

[{"selector":"#anim-66e09c29-a3e5-43f7-a5bd-433cfb538b4f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-41.601562329338584%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":4000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-3e6ad8d4-4953-4d2e-97d3-990a327e6f50","keyframes":{"opacity":[0,1]},"delay":0,"duration":4000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Step 2. Click on Data tab → Data Tools segment → Remove Duplicates

[{"selector":"#anim-734e108b-08ad-46a3-9ecb-204d31788164 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":4000,"easing":"cubic-bezier(.14,.34,.47,.9)","fill":"forwards"}] [{"selector":"#anim-5d04329f-e14f-4201-b357-9ef9b2667c54","keyframes":{"opacity":[0,1]},"delay":0,"duration":4000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Step 3. Now click on OK.

[{"selector":"#anim-29033d28-99ac-4712-8b4e-718ee95cc007 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-55.44969503037681%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":4000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-329028a3-6bc2-493d-be24-e7f0d5d7596a","keyframes":{"opacity":[0,1]},"delay":0,"duration":4000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Step 4. Now you can see, the copy records are taken out.

[{"selector":"#anim-7c7525e2-d198-46e7-ac1e-e6c3e73c9319 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(-7.105427357601002e-15%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":4000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-8fcfcafb-3acb-4532-8849-f351604e1581","keyframes":{"opacity":[0,1]},"delay":0,"duration":4000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

For other Methods & advanced filter Options Tap on Swipe up

[{"selector":"#anim-0a531259-1c98-4542-a04d-f4fcf478f2bc","keyframes":{"opacity":[0,1]},"delay":0,"duration":4000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a932b516-f21b-4dac-8c0c-798665fd6234 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(69.74902336902211%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":3000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] Swipe Up