Ref. TEST222.XLSX
In this i am trying to match last 5 digits of SHEET "TWO" with entries of SHEET "ONE". Formatting should be applied to SHEET "TWO".
PLease help.
Ref. TEST222.XLSX
In this i am trying to match last 5 digits of SHEET "TWO" with entries of SHEET "ONE". Formatting should be applied to SHEET "TWO".
PLease help.
Ask me how to hate XL.
try CF with formula
Formula:
Please Login or Register to view this content.
Sheet2!$B$1:$B$10 - are the 5 digits of SHEET "TWO"
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