• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IMEI Scan only 14 Digit

Rancuneta

Rancuneta

New Member
Good Day!

Hi I have problem scanning IMIE for mobile and It has 14 digit, the problem is I only know is highlight the duplicate. I need help regarding how can I scan only 14 digits/ IMIE and not other barcode appear

  • or some pop message can appear show wrong code like that
  • or error wrong input scan again

    thank you in advance for solution :)
 
Hi ,

I am not able to understand what you want ; can you explain :

1. What is your input data ?

2. What do you want to do with this input data ?

3. What is the output you are looking for ?

Narayan
 
sorry for my bad english


1. If I Scan only 14 digit IMEI it appears no ERROR message will pop out

2. If I Scan 13 digits below or 15 digits above are scanned = ERROR message will pop out should be appear.

3. Duplicate input imei = ERROR message will pop out “Duplicate” or “Highlight”

Thank you sir
 
Hi ,

It will be easier to suggest a precise answer if you can upload a workbook.

Checking for a code of exactly 14 digits is possible using the LEN function ; checking for duplicates is possible using the COUNTIF function.

Narayan
 
Hi ,

Can you explain how you scan an IMEI code into the workbook ?

Data Validation will work only when the code is entered by a user into the cell , not when it is copy-pasted.

Conditional Formatting can turn the cell RED when the data entered is invalid. But Conditional Formatting cannot pop-up a message.

Is VBA acceptable ?

Narayan
 
Sir,

I just put only example to get highlight..

I scan an IMEI using barcode scanner

VBA is acceptable :)

Thank you sir
 
You must log in or register to reply here.
Back
Top