3
I have a table of banks and codes in two columns.
Ex.:
Banco do brasil S/A 001
Banco do Estado do Rio Grande do Sul - Banrisul 041
Banco Santander do Brasil 033
Banco Mercantil do Brasil 208
Banco Itaú S/A 341
Some expressions repeat themselves as "Brazil", "Bank", "S/A". So I have to look for specific terms. Sometimes the specific term is in the middle of the name, as "Rio Grande" or "Mercantil".
I can only use "PROCV" if I know the exact sequence from the beginning of the name, and I still run the risk of locating another bank with the same expression. If I know that at some point in the column there is a database that has "Rio Grande" in the name, but I don’t know how the rest of the name is written, how do I search in an entire column an expression within the text of each cell of the column?
Can’t find the code?
– Math
It is a spreadsheet of filling several data.
– Vieira Porto
One of them is the Cód. of the bank. but I had to create a side screen where the user can search the code by the name of the bank, in case he doesn’t know the color code.
– Vieira Porto