Hi,
I am an excel novice so please be gentle! I am currently involved in a project where a considerable amount of data is being sent to me in Excel Spreadsheets. In order to QC the data I need to do the following:
Check that all entries in Column A contain exactly 8 characters and also that there are no duplicates in Colum A.
Is there an easy way to do this?
For duplicates I had been inserting a column then using this formula
=IF((A1)=(A2),"DUPLICATE","")
I then paste this formula down the length of the new column, paste special the value of the results into a second new column then sort the data, so all the duplicates are grouped together, then delete the redundant 2 columns. Long winded definately, but as I said I am a novice.
The trouble with the above (apart from the time) is that I have to find a duplicate in the first place to apply the formula.
I do not want to delete the data I just need to identify duplicates for rectification.
Grateful if anybody can offer any help or advice on either the duplication or the checking of characters. Thanks
I am an excel novice so please be gentle! I am currently involved in a project where a considerable amount of data is being sent to me in Excel Spreadsheets. In order to QC the data I need to do the following:
Check that all entries in Column A contain exactly 8 characters and also that there are no duplicates in Colum A.
Is there an easy way to do this?
For duplicates I had been inserting a column then using this formula
=IF((A1)=(A2),"DUPLICATE","")
I then paste this formula down the length of the new column, paste special the value of the results into a second new column then sort the data, so all the duplicates are grouped together, then delete the redundant 2 columns. Long winded definately, but as I said I am a novice.
The trouble with the above (apart from the time) is that I have to find a duplicate in the first place to apply the formula.
I do not want to delete the data I just need to identify duplicates for rectification.
Grateful if anybody can offer any help or advice on either the duplication or the checking of characters. Thanks