Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
Consider this dynamic range of cells:
I am looking for a VBA solution in which I can find the highest value of a particular seriers in that range.
For instance, if we assume a series being = 44451W, what is "x" - the largest value (determined by the last three numbers of the string) in that series. In this example, "x" = 6.
Thank you for yuour help!
wloopkdata_13.xlsm | |||
---|---|---|---|
P | |||
1 | 44451W001 | ||
2 | 44451W002 | ||
3 | 44451W003 | ||
4 | 44451W004 | ||
5 | 44451W005 | ||
6 | 44451W006 | ||
7 | 44451S001 | ||
8 | 44451S002 | ||
9 | 44451S003 | ||
10 | 44451S004 | ||
11 | 44452W001 | ||
12 | 44452W002 | ||
13 | 44452W003 | ||
14 | 44452W004 | ||
15 | 44452W005 | ||
16 | 44452W006 | ||
Sheet1 |
I am looking for a VBA solution in which I can find the highest value of a particular seriers in that range.
For instance, if we assume a series being = 44451W, what is "x" - the largest value (determined by the last three numbers of the string) in that series. In this example, "x" = 6.
Thank you for yuour help!