I have an array similar
1 2 3 6 7 8 9 aaaaa
2 5 8 7 9 4 5 bbbbb
...
we gt 56 yu 89 d5 fr ccccc
how to search in array to the last item based my_var=bbbbb
In this case return:
2 5 8 7 9 4 5
you can know:
not possible duplicates in last item of array
Printable View
I have an array similar
1 2 3 6 7 8 9 aaaaa
2 5 8 7 9 4 5 bbbbb
...
we gt 56 yu 89 d5 fr ccccc
how to search in array to the last item based my_var=bbbbb
In this case return:
2 5 8 7 9 4 5
you can know:
not possible duplicates in last item of array
Since you've been doing programming for awhile (since 2005) no sample code for you, only hint:
1. loop through array (For - Next or Do - While/Until);
2. use InStr or InStrRev function to find a match;
3. If match is found use Left or Mid function to get the output.