Try in B55 copied across and down
=IF(B$54="",FALSE,IF(LEFT($A55,LEN(B$54)+1)=B$54&",", TRUE, IF(ISNUMBER(SEARCH(","&B$54&",",SUBSTITUTE($A55," ",""))),TRUE,FALSE)))
This can be shortened to
=OR((LEFT($A55,LEN(B$54)+1)=B$54&","),(ISNUMBER(SEARCH(","&B$54&",",SUBSTITUTE($A55," ","")))))
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Nearly but both methods lose the last numbers;
in row 1 - 7,8 is displayed as FALSE when it should be TRUE
in row 2 & 3 - it's 5,6
row 4 has no TRUE results when it should have 7,8
etc
i'm guessing this is because of the formula checking to see if the value matches B$54 & ","
So long as it works it doesn't really need to be eloquent, lol.
Again it's just slightly off - the rows which have more than one column being TRUE work, but rows 58 (7,8) and 62 (13,14) still show all as FALSE.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks