I have an excel question hoping someone can help me out with I have a macro that I run for search that highlights a specific cell with what ever I search. So in my case I am trying to find account numbers that include a specific letter. Now one of my searches includes a letter that each account number has in it. Is there a way to set a search to find only accounts that have the letter twice?
All accounts are set like this ending in a letter
Ex 6b3394e
I want to find all accounts that include 2 b's
ex 6b3394b
If I use my current macro it will highlight every single account on my spreadsheet
here is link to website where I get my current macro from
http://www.pcadvisor.co.uk/forums/1/...earch-resukts/