ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 304
- Office Version
- 2016
- Platform
- Windows
I have a long is of Id numbers, some of have a letter attatched some of whole numbers. Can any one help me find the second whole number in a list. "Id" is in A1. Through Match I can find 835 (I need the number of rows from A1, So I return 5. I need to find the number of rows 839 is from 835. Any help would be appreciated.
Id
<colgroup><col></colgroup><tbody>
</tbody>
Id
834e |
834f |
834g |
835 |
832f |
473m |
835c |
835d |
835e |
835f |
839 |
832g |
346g |
836c |
<colgroup><col></colgroup><tbody>
</tbody>