Thanks, Paul.
I managed to do the first part, but can't figure out the appropriate IF statements. Can you guide a bit more?
What i understand is that first digit in the first record will be compared with all the fist digits in subsequent records (countif will do). It will give me number of instances the first digit is appearing in later records. I can repeat this for all 7 digits. What next?
Best regards,
Saad Usman
Sent from my iPhone
On 11-Jul-2013, at 4:50 PM, Paul Vermeulen <paul.vermeulen@vulcantech.com.au> wrote:
> Hi Saad
>
> Since there are always 7 characters, you can break up the string into seven single characters in seven cells by using =mid(string,start pos, length). In your case the start position will increment by one, and length will always be one.
>
> Now you have seven new columns and you can do some binary comparisons with IF statements,zero or one, SUM them and see whether the result is more than four or not.
>
> Regards
>
> Paul
>
> On 11/07/2013, at 19:41, "Saad Usman" <saad.saadusman@gmail.com<mailto:saad.saadusman@gmail.com>> wrote:
>
> > Dear Excel Wizards:
> >
> > I have tried to google my issue, but have not been able to find a solution so far.
> >
> >
> >
> > The problem is that I receive data in the form of a list of hundreds of records where entries in one particular column (say part number) comprise of 7 digits. The list usually contains duplicate values, which I have been able to identify using conditional formatting. However some times, the data entry operator makes transposition errors (for e.g. feeding 1243567 instead of 1234567). I need to identify those cells where at least 5 digits are identical so that I can manually decide whether there is an error in data entry.
> >
> > Any help via formulas/macro would be greatly welcomed.
> >
> >
> Regards, Saad
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar