bank

I have data in Sheet1 and in Sheet2. I have three columns in Sheet1 Bank, Branch,Branch Code in A B & C column. In sheet2 I have Bank Branch Code in A B & C column In C2 of Sheet1 I want that IF A2 and B2 matches the criteria it will get the Branch code from sheet2 Range A2:C100. For example...

Hi, I need to put a formula in Column M which will search through column L and match it (partially or completely) with column O and display the value available in same row in column P. If VBA code will do it faster then provide VBA code please. e.g. in Column L, it is written as "Salary of...

I took a vehicle car loan for $777,700 at 8.85% for 7 years. I used PMT and got a monthly payment of $12,453. The bank has a payment of $12,473 I inquired the bank why the difference and they said it was the difference between 360 days vs 365. I don't know what is this. How do I calculate it...

<tbody> <colgroup><col><col><col><col><col></colgroup><tbody> OLD NEW Account Description Account Description 042101002 House Fund - General Cashier 1000 HOUSE FUNDS 042101003 House Fund - Human Resources 1010 BANK REVENUE ACCOUNT 042101004 House Fund - Materials Manager 1011...

Hi to all the members I have 7 sheets in my excel work book. Sheet 1 is called Cash Sheet 2 is called Cheques Sheet 3 is called Transfers Sheet 4 is called Online Payments Sheet 5 is called Bank Sheet 6 is called Data Sheet 7 is called Summary. In this sheet I have running down the columns...

Hi all In cell J4 I have the date 01/11/2018. In cell B15 I want to return the date of the first Monday in the month of November (calculating off the date in J4 (which will always be the first of the month)) BUT where the Monday is a Bank Holiday return the date for the Tuesday, if the bank...

So I am trying to find a formula that will pull out unidentified charges from our bank account. I have a list of the known item charges and I would like to create a formula that will list all the items in the description that do not match those charges. So for instance, KNOWN CHARGES: APPLE...

Hello, I am creating a worksheet to log certain transactions so that I can automatically get the data in other worksheets. I added a button to start a series of inputboxes to get information about the transaction. The transaction is always at 1 of 2 bank, let's say Bank A or Bank B. I know...

Hi guys - I manage the work coffee club and each fortnight need to balance the bank account and petty cash. I'm hoping a simple WB will help me and others with transparency and simplicity. I currently have a WB with two WSs: data and balance. DATA: <tbody> A B C D E F 1 DATE CREDIT DEBIT...

Hi all, i would like to create a VBA code so that to run through row "1" and where find the text "Bank list' should create the below formula: "=VLOOKUP(RC[-10],'[PAYMENT LIST.xlsx]Sheet1'!R4C1:R5000C32,25,0)" Kindly note that the formula should begin from row "2" till last fulfill row based...

I have the following data set for which I need to divide into decile for a particular year and also want to view the banks in a particular deciles. Is It possible to create this on the basis of a calculated column in Power BI. I used a simple Decile formula, but that doesn't work...

I have a data set with 4 columns - Original Bank , Acquiring Bank, Acquired Status ( Yes/ No) , Final Bank Name Depending on whether the acquired status is yes or no, I want to copy the bank name to column Final Bank Name. Following rules apply :- a) If the bank under column Original bank has...

Hi I am trying to create a Macro see the below requirement. One file name is Jeeten 20180806. I am working for different company so for each company I have smiliar workbook but in the company name floder I have saved the workbook in company folder because data are different for example ; Jeeten...

I use Google Calendar with a script that counts up the revenue. I use Wave accounts to import bank transactions. I does 3 lots of tax including US, tax credits and UK self assessment. Please let me know if there is anything suitable? Thanks

Hi, I have set up a pay date sheet which shows when monthly pay is due up to 2030. I want to bring the date forward to the prior working day if the pay date falls on a weekend or bank holiday. Bank holidays have been set in a range called "Hols".. I can get it to move the pay date to the...

Hi All, I am currently trying to write a code with SUMIFS formula but I'm having difficulty as I'm still a newbie at VBA. I tried using other codes from different forums including here but to no avail. Would also like to know if the code can loop for all blank cells in case other criteria...

Hi guys For work I have to keep an Excel version of our company card bank statement and day by day I have to update it, and then annotate it on Excel with notes. When exporting the Excel version of the bank statement, sometimes the order changes and a transaction or two appear amongst...

Hello everyone, I have 3 different columns containing Name, sort code and account No. as "C cuthell", "974627", "59418670" , i want to combine these and match with a column from my bank statement which is "c cuthell CHARLOTTES MONEY BGCFrom: 97-46-27 59418670" and ultimately i want to use...

Hey Guys, Im looking for a file that I can use to recon my bank. I know there has to be something out there. Right now we use excel and I literally make green each matching deposit. It would be nice if I had some automation that would pick up the easy deposits first and match them and then I...

Hi. My apologies for asking a question that seems to get asked frequently. However, I was not able to figure out a solution from the previous posts, and I have not been able to find a video on the Mr. Excel or ExcelisFun youtube pages that go over "Duplicates" errors in Power Pivot. I am hoping...