Hello,
How should I act when I want to retrieve number of bracket where value I'm looking for is?
Let me visualize my problem:
<tbody>
</tbody>
So basicaly formula should give me number of bracket where value(which I'm looking for) is. Value from row 2 can be in bracket located in row 20. Let's imagine that count of brackets it's 1/4 of total values. How can I deal with it?
I'm struggling with this probably due to that multiple values are located in one cell and all is splitted by space.
Any tips? Thanks
How should I act when I want to retrieve number of bracket where value I'm looking for is?
Let me visualize my problem:
Bracket ID | Value I'm looking for | Bracket Number | Bracket Content |
<formula> | 101 | A | 99 88 100 98 103 |
<formula> | 102 | B | 87 55 33 58 101 |
<formula> | 103 | C | 102 108 109 112 |
<formula> | 104 | D | 111 104 198 175 |
<tbody>
</tbody>
So basicaly formula should give me number of bracket where value(which I'm looking for) is. Value from row 2 can be in bracket located in row 20. Let's imagine that count of brackets it's 1/4 of total values. How can I deal with it?
I'm struggling with this probably due to that multiple values are located in one cell and all is splitted by space.
Any tips? Thanks