How To Remove Duplicates In Google Sheets (4 Easy Ways)

everyone if your table is flooded with duplicate values if you delete them and they suddenly reappear then this video is for you I'm going to show you two ways to remove duplicates in Google Sheets first let's learn how to delete duplicates under our control and then automatically let's get started maybe you didn't know but duplicates are afraid of bright light so let's highlight them to do this choose format and click on conditional formating after that the wonderful world of conditional formating opens up to us here we need to select the range in which we are going to search for duplicates you can select either a single column or a whole table I select several columns at once now we need to write a formula that will search for duplicates to do this open the format cells if menu scroll scroll to the bottom and select custom formula is in the value of the formula write count if then our range and after a comma the address of the first cell A1 then we close the bracket and say that we only count cells with more than one identical value more than one and then you only have to choose the style that will be applied to such cells that's up to you I'm going to leave the default style let's check what we have done I enter the number 44 different cells and nothing happens why because we forgot the equal symbol because it's a formula at the same moment the duplicate value is highlighted after that it's not hard to delete them if you find this method to beit difficult I present you the fastest way to instantly remove duplicates to do this select the dat data section at the menu in the section click on the data cleanup and select remove duplicates also you can trim wi space here click on remove duplicate oops we forgot to select the rage let's fig that I select the columns select remove again check if your table has a header so you don't accidentally remove it to here you can also select G and the columns in which to look for duplicates bum remove duplicates no duplicates are found because in this case unlike the previous one duplicates are searched not by cells but by rows that is only completely identical rows are removed let's check it again and select only one column click delete duplicates again confirm remove duplicates the duplicates are removed but the cells are shifted upwards this is not good that's why the most correct option is to select the row completely let's do that select data clean up remote duplicates and select the necessary columns for example A and B and we have deleted two rows with the repeated text how to personally I miss the option of automatic deletion of cells without upward shift well for this case I use the first option with highlighting duplicates and manual deletion it's more reliable I mean who knows what this artificial intelligence will do thank you for watching to the end good luck in mastering the world of tables and all the best

Channel: Codex Creator

Views: 226

Keywords: remove duplicates in google sheets, how to remove duplicates in google sheets, remove duplicates, remove duplicates google sheets, how to remove duplicate data in google sheets, google sheets remove duplicates, google sheets duplicates, highlight duplicates in google sheets, google sheets tutorial, how can i find duplicates in google sheets, find duplicates google sheet, removing duplicates google sheets, google sheets, duplicates google sheets

Id: tHbbRRIHPjs

Length: 3min 47sec (227 seconds)

Published: Thu Jan 18 2024