Is there a formula that will allow me to search for duplicates in a column using the first 4 letters and last 4 numbers in a cell?
Is there a formula that will allow me to search for duplicates in a column using the first 4 letters and last 4 numbers in a cell?
can you provide a sample file
the countif i think can give you that something like
=COUNTIF(C1:C6,"="&LEFT(A1,4)&"*"&RIGHT(A1,4))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks