And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. I hope this helps you to clean up your data, FASTER. Note: Before taking this ‘clean’ list to SharePoint as a choice dropdown – sort it alphabetically – users struggle finding the correct choice if not displayed A-Z. Click on OK to remove the duplicates after which you can now remove the misspelt locations. In my example Rivonia was misspelt as Rivonias. This is a great way to also spot spelling mistakes. Click on OK (4) to perform the function.Įxcel will now display the shortened (single value) list. As I am only cleaning up one column – it only displays one. The settings box will open where you select the columns. Now click on the Data Tab (2), then on Remove Duplicates (3). I always copy this column to a new sheet as I don’t want to change the existing data (I only need the dropdown list with no duplicates). In Excel you need to select the column (1) which contains the data you want to clean up. You might want to remove duplicates to eliminate errors. Keep in mind that Removing Duplicates works in Excel – regardless of whether you want to take the lists to SharePoint or not. This means that going forward users will not type the location, but choose it from a dropdown. As this is either a manual input by users, or a report from external systems, I would like to get the exact list of locations that I will use for my choice dropdown in SharePoint. As the goal should always be to manage the input of data, you need to apply as much validation as you can to ensure clean and correct data.įor example: My spreadsheet has a column for the location. I convert a lot of existing Excel spreadsheets to custom lists in SharePoint. In this post I will show you exactly how to do that. Seeing as Excel can have over a 1,000,000 rows of data, Doing it fast and easy would be the objective. #Office365Challenge – Excel Removing Duplicates – As most of our data calculation, manipulation and reporting still happens in Excel, it might be necessary to check for and remove duplicates at times.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |