a have this case:
<tbody>
</tbody>
I have to find the address of the cell in B column which is related with the last cell in a row (A) which contains the cells with the same text/value.
In the table case above the outcome should be B4, if the condition is to search for "0150358", or B7, if the condition will be to search for "0160001".
Thank you in advance
A | B | |
1 | 0150358 | 100 |
2 | 0150358 | 200 |
3 | 0150358 | 250 |
4 | 0150358 | 30 |
5 | 0160001 | 80 |
6 | 0160001 | 120 |
7 | 0160001 | 90 |
<tbody>
</tbody>
I have to find the address of the cell in B column which is related with the last cell in a row (A) which contains the cells with the same text/value.
In the table case above the outcome should be B4, if the condition is to search for "0150358", or B7, if the condition will be to search for "0160001".
Thank you in advance