There are some period e.g. 1ABCD,2AC in column A .I want to map them to row such as 1A,1B,1C, etc in row 1
Put 1 where mapping is found and 0 where mapping is not found
Please find attached excel sheet with the expected output
There are some period e.g. 1ABCD,2AC in column A .I want to map them to row such as 1A,1B,1C, etc in row 1
Put 1 where mapping is found and 0 where mapping is not found
Please find attached excel sheet with the expected output
try this in B2 (then you can fill right and down)
Please Login or Register to view this content.
Last edited by scottiex; 06-14-2018 at 09:01 PM.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Actually this will get scenarios like 7AB8CD wrong because it will think you want to include 7C and 7D.
This might be too complex for a formula if there could be any combination of codes in there.
Is there a reason why the initial format has to be as it is?
One way:
=COUNTIF($A2,REPLACE(B$1,2,0,"*")&"*")
@Phuocam- Your formula is not working right for 8B and 8D ..But I have modified your formula and created COUNTIF($A2,"*"&REPLACE(B$1,2,0,"*")&"*")...This is working perfectly
test if for scenarios like "7AD8B"
I think you will find it fails in the way I described above for mine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks