maldonadocj
Board Regular
- Joined
- Oct 19, 2004
- Messages
- 103
Hello,
Can someone pls. assist me with providing a formula, ideally using the index/match functions, to locate the first absolute (may have positive or negative values) number in a column? I have added snapshots of how the data would look on the two sheets they are currently located on.
Thank you in advance.
Sheet 1
<colgroup><col width="118" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4315;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
Sheet2
<colgroup><col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;">
<col width="152" style="width: 114pt; mso-width-source: userset; mso-width-alt: 5558;">
<tbody>
</tbody>
Can someone pls. assist me with providing a formula, ideally using the index/match functions, to locate the first absolute (may have positive or negative values) number in a column? I have added snapshots of how the data would look on the two sheets they are currently located on.
Thank you in advance.
Sheet 1
ID | Value |
12345678A | NULL |
12345678A | 100 |
12345678A | 150 |
12345678B | 200 |
Sheet2
ID | Expected Result |
12345678A | 100 |