Recent content by persol

Sorry folks, you must have me confused. That other person is probably copying or doing a similar thing. This happened 6 or 7 months ago with a different user. I certainly am aware of the rules and am sure there is a similar but not the same case. Now, to SirJB7, thank you very much for your...

Alright SirJB7, I never suspected that formula, it took me a bit to realize what the numbers meant. Thank you so very much. However, I am still not there entirely. I shortened the list where I have names mixed in with and without spaces, with and without caps, and mixed with last names. I...

I would like to find a way to find the names from LIST 2 in LIST 1 (see lists below), mark them in some color, and pull any additional information in the next column. IS that a difficult formula? Please note that the names from LIST 1 are mixed with other words or are low caps, yet are still...

Hi Montrey, thank you so much, I appreciate it very much.

Hi Montrey, I appreciate it very much but the link does not show me how to get there, did I miss it at all?

http://awesome.good.is/transparency/web/1010/political-climate-chart/interactive.html

NP SirJB7, I am almost done with it. Thank you so much for your help and support. Cheers, persol

Hi SirJB7, I thank you very much for the follow up. I did what you suggested and helped a great deal, but it is moving very slow. I was also looking into the "sounds like" formula my boss asked me to look into. I have never heard of such string, did you?

Hi SirJB87, I came across a snag. That is, if the address is missing a letter or the address is incomplete it gets ignored. Is there a way that a formula can read at least part of the address or find a word that is the sane in other addresses? For instance: if i had "1230 Pensilvania Ave."...

Hi SirJB7, yes =CONTAR.SI(A:A;A2)>1 worked fine. WOW! thank you so much. Cheers, Persol

Hi, it helps a lot, however, my keyboard and software follow the Canadian version - all is in English. I gather the meaning of all the words , except the word buscar which means to find but i would appreciate the english version (it is not the "find" is it?) . I tried to replace it as follows...

Hello, I am confronted with a file with over 1000 records of invoice numbers and customer numbers, I would like to find out if there is a formula that could detect the missing invoice numbers or the missing customer numbers. Please note that these numbers are all system generated and are...

Hui, that was totally unexpected. Very clever. Thank you so much for your suggested solution. It is my new keeper.

Hi Everyone, Can you help me define a formula that will check the contents of 3 or 4 cells from different columns to see if the data in that raw repeats (duplicates) anywhere else in the file (3 or 4 columns)? For instance: Columns A Column B Column C Column D...

Hi Saneesh, I like your suggestion even better. Thank you so much. BTW - what do you mean "but...i don want to color the row of duplicate with red .for easy identification.."?