Hi, Can anyone help?
I have an excel 2010 worksheet and I have created a list called lstA from the part number column on the 'Full list' sheet.
I now need to paste separate parts lists and highlight the part numbers on these seperate sheets that are the same as the part numbers in the lstFull list. I have tried to use the countif function and conditional formatting (=COUNTIF(lstA,B6)>0), but it returns all the numbers as being duplicates, when I can manually see that they are not all the same.
Can anyone see where I have gone wrong with this.
Note: Some if the part numbers are text, some are numbers formetted as text and some are pure numbers.
I have an excel 2010 worksheet and I have created a list called lstA from the part number column on the 'Full list' sheet.
I now need to paste separate parts lists and highlight the part numbers on these seperate sheets that are the same as the part numbers in the lstFull list. I have tried to use the countif function and conditional formatting (=COUNTIF(lstA,B6)>0), but it returns all the numbers as being duplicates, when I can manually see that they are not all the same.
Can anyone see where I have gone wrong with this.
Note: Some if the part numbers are text, some are numbers formetted as text and some are pure numbers.
