I have an excel file with several lists - I need to Identify the duplicate value in the long list from the short list
kindly anyone please help
thanks
Xcel forum.xlsx
I have an excel file with several lists - I need to Identify the duplicate value in the long list from the short list
kindly anyone please help
thanks
Xcel forum.xlsx
=IF(COUNTIF('Short List'!C$3:C$219,"="&C2)>0,"A","False")
in D2 and copy down, I'm not convinced you have any duplicates though.
It comes up with a full list of False but the first 1 values are exactly the same of both sheets - this is why It's confusing
Last edited by lechefox; 11-22-2013 at 11:48 AM.
nope, the one on the first list has a space in front of it, one is "06layla06" and the other is " 06layla06"
Then this is the reason
- I will remove all the spaces thx for solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks