![]() ![]() Using Conditional Format of =COUNTIF(A:A,A1)>1 the color of the cell will change to Red if we encounter a duplicate. ![]() We have a problem in that some of the documents being scanned contain duplicate bar-codes and I am trying to identify them. ![]() I am scanning in bar-codes that are 30 digits in length. But I am hoping you guys might have another work around. I know that a workaround would be to change the column to text format. ![]() I have researched the Excel's 15 digit limitation in this forum as well as others.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |