Please note that when you add more data, #N/A could also represent new companies with correct names. Go to the CorrectionMaster table and copy the data at the bottom of the table.Įnter the correct names for the new entries. Why? Because our correction master does not have entries for these new mistakes.įilter on #N/A and copy only the Company column data. Table will also copy the VLOOKUP formula automatically. Now copy it and paste it below the Base file data. There is additional data available now.Ĭlick anywhere (except the header row) inside the Incremental data and press Ctrl A. Use VLOOKUP to get the Corrected column from the CorrectionMasterĬreate a pivot table and use the Company Name column If you add calculated columns at the end, incremental copy paste is very easy. Why not add it next to Company column? Because next month, you have to copy paste more data and that data will not have our calculated column. Rename this column to Company Name (or any other suitable name) DO NOT add it next to the original Company column. Add a column in original data to get the corrected names But for future updates, this effort is going to be reused. Table Tools – Design – Change Name to CorrectionMasterĬreating this table for the first time will require effort. Now go through the corrected column and actually replace the erroneous data with the correct spellings. It was created just to get a list of unique Companies. Rename the first column as Original.ĭelete the Pivot Table. In a real-life situation, this can be in a separate file.Ĭreate a table. Now it will select the entire column in ONE CLICK!Ĭreate a new sheet and Paste the data TWICE. Move the mouse cursor just below the title till it becomes a think down arrow. Select the list of companies from Pivot and copy it. Go to base file and create a pivot table. This method gives you a long term solution to managing mistakes. #Corect spelling for quiri update#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |