Thread: [Solved] Macro to check against Columns & Delete Duplicates
View Single Post
 
Old 12-14-2017, 08:49 AM
jolivanes jolivanes is offline Windows 10 Office 2013
Advanced Beginner
  
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default
Attach your workbook. Change numbers but not the formatting etc.
In an empty column to the right in the first cell, put "=Len(A1)"
Drag formula 4 columns to the right and however many rows you have in Columns A to D
All numbers should correspond to the amount you need it to be. 14 For Columns A, B and C and 12 For Column D
Reply With Quote