sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
Can someone show me how to find the row number last exact match in column C?
The values are all numeric, so it needs to be a precise match and must be the last value found as there will be duplicates.
Sheet1
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
In the example above, if I searched for '1234' I'd expect the result to be row 9.
The values are all numeric, so it needs to be a precise match and must be the last value found as there will be duplicates.
Sheet1
C | |
1 | 1234 |
2 | 12345 |
3 | 1234 |
4 | 1234456 |
5 | XXX |
6 | 1234 |
7 | XXX |
8 | XXX |
9 | 1234 |
10 | XXX |
11 | 3447589 |
12 | 3816444.5 |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
In the example above, if I searched for '1234' I'd expect the result to be row 9.