Search results

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.."?

Sorry Saneesh, I forgot to add the following: in your original question you indicated that "I have 3 cell with customer no:,date, and vendor no …. in a cell", how would you detect duplicates. That is easy, again, the formula I provided in my earlier post will give you the results. Except that...

Saneesh, also, consider using the following formulas: =IF(COUNTIF(B:B,B2)>1,"Duplicate","") or =IF(COUNTIF($B$2:$B$200,B2)>1,"Duplicate","") Both will detect duplicate numbers, labels, names, amounts, etc. Cheers, Persol

Saneesh, That is the first easy question I ever read. Take a read at the below links, they will teach you the basics and an advanced feature that Excel does now a days: http://www.youtube.com/watch?v=JK-KtWscBX4 He also has a page on his site concerning other methods:
...

Hello Asa, I am not in the finance field but I have gone mad with the topic of digit analysis. I came accross benford Law (if you have never heard of, take a read here...

Hello Daffy333, great suggestions. I found part of my answer. The trick I will use going forward is the conditional formatting. it does not involve formulas (which takes time computing in large files), the conditional formatting can also be filtered by color an column - which was my main need...

Hi folks, For a long time I have been using a simple formula that helps me detect and filter out duplicate records as in a accounts payable (duplicate invoices or payments) or an accounts receivable file with duplicate invoices or amounts, etc. The formula I have been using is...

Alright Asa, I like your updated formula. It does all that I need. It is now easier to create a table that summarizes the digits and easier to pinpoint the potential problems. I already got dynamites for my meeting scheduled for next Monday. One thing that has been bugging me, how did you...

Asa, is this the link? I get there both ways: http://www.mediafire.com/myfiles.php#nu06jp4h71iga,1

Hi Asa, I just pasted the document in a folder called Chandoo (sorry real Chandoo, it is easy to remember and identify). The folder is in MediaFire.com, se the link below: http://www.mediafire.com/?5by06dqmzffl8if the fiel is tittled "Chandoo_Test.xlsx" Now, I made sure it was...

Alright ASA, I will look into it. Other wise, I can forward it separately.