Search results

OK! This appears to have worked! I understand why multiplying the booleans works, but I wonder why the AND function doesn't? I suppose it must have to do with the order of evaluation... In case it's of some added value to any forum readers, here is my "ultimate" array formula that takes...

Thanks - btw :) In the example data in my post, e.g. in row 2 the result would be 0.97 that way (see "values in array"), not 1.

That will only calculate the current row intersect. It would be more correctly written with @ for all references in that case, but it's only a subset of the calculation this way.

An alternate solution would be to NOT modify "Master file" with your macro, but copy the desired data from Master File to a nwe workbook, and save that instead.

Did you try the suggestion of putting your code in another workbook besides "Master file"? With your overall approach to the task, you will have the exact problem you are having. Try creating a new workbook such as "Master File Automater" or what have you. Put the code there. You will have...

Oh, one more suggestion. You could consider keeping all the transaction tables in one table to begin with. In that case, you would probably want an added column to indicate which bank/bank account the transaction was associated with. Then, you could filter that table on bank account when...

Depending on your needs, there are various ways to merge tables that are laid out differently. One simple way is to manually modify the layout to be the same, then copy and paste the data from one sheet to the other (or both to a new sheet). The topic you linked to appears to be dealing with...

Hi wxmeddler (are you meddling with the weather?? :D ), I'm going to make some guesses as to your terminology... verification: the actual amount of precipitation measured verification range: bracketed margin of error of the forecast One basic solution, given that you understand the...

Hi everyone, Excel 2010 I previously asked for help with this formula on the EXCEL-L mail list (LSOFT) but didn't get a solution. I have a worksheet that has a table with three date/time columns: The first column of interest, DATE, is a calendar day (i.e. September 24, 2011). The second...

Hi, I'm Asa. I just found your site looking for some articles to recommend to someone on a particular Excel question they had on the EXCEL-L MS Excel Developers mail list (Chandoo, I linked to your excellent article with a broad take on form controls) In the 90s I worked as a programmer and...