bank

Hi. I am using CF to highlight all Mondays in a week using this formula =WEEKDAY(P5)=2 When I populated the dates from left to right across my columns, I filled right with this formula: =WORKDAY(S5,1,Holidays) However, since I've got my Holidays range to ensure that bank holidays aren't...

Hi, I have a database of different company names and their respective stock symbols (spreadsheet 1) and in another spreadsheet I have company name and descriptions (spreadsheet 2) that aren't exactly written the same way as they are in my initial database. I would like to try to use some parts...

For some reason my credit card doesnt give excel statements. How would I separate gibberish like this into columns? I'd like 4 columns please. I used LEFT, MID, RIGHT, FIND commands for the first 3 columns, but then I got stuck. Jan 07 Jan 07 GOOGLE *OkCupid g.co/helppay#NS 2.52 Apr 01 Apr 02...

Hello, VBA to merge two worksheets into a new worksheet based on criteria. Input Sheets : APA, BANK, GA Output Sheets: APA PAYMENT & GA PAYMENT I want to do the following: Copy all data from APA sheet and paste to APA Payment Copy data that contains "APA" in Column B from BANK sheet and...

Just looking for a little help with this formula as I cant seem to get it to work. Basically I'm looking to return an F if the "PP - 3" is greater than 0. Returning a P if "pp - 1" + "PP - 2" is greater than 0 and if when you add all three together it returns a 0 then leave the cell bank. If...

I'm trying to make balancing my checkbook easier, but finding it hard to find a macro or formula that does what I need. I have two columns, one that has the charges according to my bank, and the other which has charges that I've documented myself. It's easy to find values that occur only in the...

hello, is there a fomula to NOT incude bank hols, sat & sundays? for example:- (a2 ) 23/819 (b2) =a2 + 5days ( not inc sat/sun & bank holiday) = 2/9/19 many thanks in advance KR Trevor3007

Hi, I was wondering if this is even a possibility or if anyone has done something like this where they could help me. I receive spreadsheets from our clients (with two columns) the amounts they need us to withdraw from their bank account weekly. and there's a rounding issue. Example, even...

Hi All Our accounts software accepts bulk upload of journals from excel, the format is as below: <colgroup><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody> Batch Date Batch Description Batch Type Main Location Nat Dept Amount Description Journal Code 20/08/2019...

Hi, Below are two banks, Bank A and Bank B where i am intending to withdraw based on the annual increase in withdrawal of 3% starting at age 70. Everthing works ok for me and and I provided the formula below that i am working on. However, I could not get the formula out for withdrawal. Given...

Hi, I am trying to automate a way of searching through my bank statement and returning a reference number based on the narrative that appears on the statement (sample data attached). We get hundreds of items every day and the narrative that is quoted on the bank statement is always different...

I am working on a salary sheet and stuck on this situation. Sheet has a to z columns with these headings. What i need is, if employee name and employee code repeat several times, then i get sum of his duty, wages, pf, esi, pt, gross salary, advance, uniform, add money, take home, bank cheque...

So basically we have set up electronic cover sheets and the formula I am looking for is when i am putting names of the bank staff covering the shift i want the corresponding ward to appear above the bank person's name. Anyone help?

Hello, I'm trying to make life a little more efficient for some of our accountants but have hit an excel brick wall. Background: We consolidate about 7 company's financials into one consolidated financial statement. For reasons unknown, these financials are not in a standardized format so I...

Hello guys, Please find attached an EXCEL I created for Daily Expenses / Outputs and Daily Sales/Inputs. (cant find attachment feature here) Unfortunately I can't use the FILTER properly. -If you try to filter BANK category to show only, it also includes Cash. -If you filter CASH category to...

Hello, I am trying to create a macro that does the following: Loop down sheet and copy the Description (Column E) Ex: Copy "Cash in Bank" [Note: the empty cells at the category description level (Beg and End)] Paste the description in (Column L) next to each transaction Ex: Paste "Cash in...

Hi Guys What I am trying to do here is to copy data from a sheet [called Full Bank Statement] that is between 2 dates held in A2 & B2 of the sheet and where the data meets the criteria, copy from columns 1 - 6 into the first empty cells of the sheet [January] I only want to copy the cells in...

<tbody> a b c d e f g h i j k income expend bank Date Description Rec Income Vouch expend CHQ No Deposits Withdrawal balance Cash 1/1 B Forward 100.00 10.00 1/1 Test 1 1 10.00 1 100.00 20..00 2/1 Test 2 1 20.00 1 20.00 80...

Hi i have a formula that returns the correct result =IF(ISNUMBER(MATCH(A2,V8:V13,0)),IF(A2=B2,"eombh","bh"),IF(A2=B2,"eom","normal")) A2 = a date V8:V13 is a column of dates however i want to introduce another variable (system)...

Dear all It's been a long time since I sought help from your goodselves and I have forgotten so much that even this seemingly easy task is alluding me. I have scoured the boards to see if I can canabalise code for my purpose but with little success. So here goes - please go easy on me and...