Dear Saad
Just a thought, it is not unusual for long part numbers etc to have check digits. Are you sure this is not the case ?
Meanwhile the problem you have looks like a respectable challenge.
Derek Turner
England +++
>________________________________
> From: Saad Usman <saad.saadusman@gmail.com>
>To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
>Sent: Friday, 12 July 2013, 3:42
>Subject: Re: [ExcelVBA] Re: Transposition errors
>
>
>
>
>Dear Dave:
>The list basically comprises of information that is generated outside of the organisation. We have 2-3 instances where this problem arises. One is the airway bills and other is the purchase order numbers that we receive from our customers.
>
>In order to generalise i used the term 'part number' which now has become rather confusing (sorry about that). So in the end there is no control list which i can compare my data with. We have to depend upon the data entry operator to punch correct data, which is practically impossible in 100% cases.
>
>Hope the above makes the picture more clear.
>
>Best regards,
>Saad Usman
>
>Sent from my iPhone
>
>On 12-Jul-2013, at 1:41 AM, "dmgathmann" <dmgathmann@yahoo.com> wrote:
>
>>
>> Saad,
>>
>> If the number is from a defined list - e.g. part numbers - then I'd think that perhaps a better approach would be to compare the input with the defined list. I don't see how you would determine that any particular number had transposed digits unless there were another number to compare it to. You've not given us enough information to determine whether there is sufficient information in the list that you are checking to inspect for data entry errors. For example, any unique entry in the list you are checking might have transposed digits, but unless the "correct" number is also in that list (side comment: where might it be in relation to the suspect number?), you'd not catch the error.
>>
>> Also ,as you mentioned, if the defined list had members with digits that were transposed, you'd need additional data to determine a data entry error. What is it?
>>
>> Dave Gathmann
>>
>> --- In ExcelVBA@yahoogroups.com, Saad Usman <saad.saadusman@...> 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 (6) |
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