Hi all
I have workbook with data in sheet(data).range("A1:Ai) , i= last row
Now I want to mark YES with conditions match row and column for each Cell in range(cells(2,3),cells(lr,lc)) , lr = last row in column B, lc = last column in row
Else will mark NO
Data and result like table belove. Please help me.
<tbody>
</tbody>
I have workbook with data in sheet(data).range("A1:Ai) , i= last row
Now I want to mark YES with conditions match row and column for each Cell in range(cells(2,3),cells(lr,lc)) , lr = last row in column B, lc = last column in row
Else will mark NO
Data and result like table belove. Please help me.
A | B | C | D | E | |
1 | A12345-B9123456-C123454-D20193-00 | A12345 | A12346 | ... | |
2 | A12345-B9123456-C123456-D20193-00 | C123456 | YES | YES | |
3 | A12345-B9123456-C123455-D20193-00 | C123455 | YES | NO | |
4 | A12345-B9123456-C123456-D20193-00 | C123444 | NO | NO | |
5 | A12346-B9123456-C123456-D20193-00 | ||||
6 | A12347-B9123456-C123456-D20193-00 | ||||
7 | ..... | ||||
8 | |||||
9 |
<tbody>
</tbody>