estatefinds
07-14-2017, 09:11 PM
I need to know if there is a way of for example:
select a combination like 1-2-3-4-5. Then do a search after selecting this 1-2-3-4-5, to search for a partial match of no less than three matching numbers, and up to four matching numbers and finally and exact match which would be the complete five numbers for example 1-2-3-4-5.
i would select in column C the 1-2-3-4-5 then a macro would search in a range of combinations
That would be found in a range of Column E1 to AM9276.
So if a partial match is found like 1-2-3 it would highlight the cell in red, if the partial match of 2-4-5 is found it would highlight the cell red, if 1-2-3-4-5 is found it would highlight the cell in red. If a partial match of 1-3-4-5 is found the cell would highlighted in red; Of course there will l be multiples of these so they would be highlighted. Is this possible to do in excel vba???
i have been struggling with this for a while.
thank you very much in advance for any help on this!!!!
I will attach an excel file soon
select a combination like 1-2-3-4-5. Then do a search after selecting this 1-2-3-4-5, to search for a partial match of no less than three matching numbers, and up to four matching numbers and finally and exact match which would be the complete five numbers for example 1-2-3-4-5.
i would select in column C the 1-2-3-4-5 then a macro would search in a range of combinations
That would be found in a range of Column E1 to AM9276.
So if a partial match is found like 1-2-3 it would highlight the cell in red, if the partial match of 2-4-5 is found it would highlight the cell red, if 1-2-3-4-5 is found it would highlight the cell in red. If a partial match of 1-3-4-5 is found the cell would highlighted in red; Of course there will l be multiples of these so they would be highlighted. Is this possible to do in excel vba???
i have been struggling with this for a while.
thank you very much in advance for any help on this!!!!
I will attach an excel file soon