bank

RE: Conditional Formatting Query Hi All I have a spreadsheet where we are capturing Go live dates for a project, the sheet is called "OTR Sites Dashboard", the "Site Proposed Go Live" column is E, we then have another sheet called "Bank Holidays" and that looks up the sites from the OTR Sites...

Hi, In B1 I have the following formula to search A1. Similarly, B2 to search A2, etc. =IF(ISNUMBER(SEARCH("COSTCO",A1)), "Supermarket","") However, I need to have multiple criteria all within the above formula. For example: IF "COSTCO" then display "Supermarket" IF "TESCO" then display...

Hi guys, Someone on here will probably find this dead easy. I want to set up a spreadsheet, that will tell me how much money I will still have before I get paid again. Basically, it would show the current date and I would input the dates and amounts of when money comes out of my bank. So, for...

Hi, I am trying to write a formula that works out overtime rates. I have a staff member on 25 hours/wk. Until he has worked 37 hours all is plain time, after that it depends on the day, Mon-Fri time+qtr, sat, Sun and bank hols Time+half. The "day of the week" is in col "A", if its a Bank hol...

I'm trying to create a summary sheet of data I've put into jan thru dec sheets. I want a formula that will enter the name of the item and the amount. The names are the same each month however they can come from several different columns. I tried the following and it didn't work...

Hi All, Thank you in advance, what i need is to be able to highlight the difference between 2 worksheets in the same workbook, fig1 below is sheet1 and fig2 is sheet2. <colgroup><col span="2"><col><col span="2"><col><col><col></colgroup><tbody> fig1 fig2 DEC JAN Desc...

Hi all I am looking for some help, regarding trying to calculate the next Tuesday following a certain date. If I explain the process it might be easier, currently we have a multi stage (7 in total), process that is connected to the previous stage, and 3 of these stages can only happen on a...

I hope that someone has an elegant solution to solve my "situation", as follows: Via keywords, I make a pre-qualification of ledger entries. This works very well via the following statement in a ledger table...

Hi My data is in a quite simple, tabular format as in the image below. I can use a pivot table to get a high-level summary. What I need to do then is to prepare data for a mail merge to each person, which will provide information with more granularity. E.g. will tell Mike he has £250 with...

Hi everyone, I am happy to join to such wonderful forum. I will really appropriated if you could help this issue. I have the following table <colgroup><col></colgroup><tbody> <tbody> Day Amount Means 1 143 Bank 2 22 Cash 3 1980 <tbody> Master Card </tbody> 4 5 Debt Card 5 388...

I am trying to calculate the monthly installment on a loan of 23000, interest rate of 0.49% monthly, for 12 months. Using PMT I get a value of 1,978.26 but the bank guy tells me it's 2029.37. So who's right?

Hi everyone, i would like to enter the description "Occupancy" below NET PROFIT / LOSS using a vba code. Please note that the rows are not stable. The Schedule 1. shows the original data and schedule 2. is the expected result. Many thanks in advance Schedule 1. <tbody> A 1 Income 2...

Using Excel 2016, I have a macro that works well if the data is in the pivot table, but if not, it throws an error (Run-Time error '1004': Unable to get the PivotItems proery of the PivotField class). It is try to deselect the District Bank and Regional Trust but they may or may not not appear...

Hi all Apologies if this has already been asked / answered but I could not find it anywhere. I want to convert cell references within formulae to actual figures e.g. using the table below: =SUM(B2:B8) arrives at 271.60 but I want to make the formula say...

Hi guys I need a formula to calculate bank fees for purchase using excel, you'll find the fees details in the end of this post, however, my bank balance was 2.87€. The product I bought cost 2.81€. After the purchase was done, I noticed that the bank took out 0.12€ as fees and then my balance...

The question goes like this: Last year, the Tan household spent $11,000 on food, $5,900 on transportation, and $7,200 on other expenses. The cost increases per year by official estimates for food is 4.5%, transportation is 6.2%, and others are 8%. The family's total income in the previous year...

Hi. Good day to you. I would like to populate a "template" worksheet based on an Excel Table like this: <tbody> ClientID Bank Account Problem 2 Big bank 987987987 Didn't pay 2 North bank 654654654 Delayed pay 2 South bank 654654654 Low credit 2 Easy bank 852852852 Bankrupt </tbody>...

i am looking for a way of counting how many sales days in any month, assuming the below information <colgroup><col><col></colgroup><tbody> Day Value Sunday 0.125 Monday 1.000 Tuesday 1.000 Wednesday 1.000 Thursday 1.000 Friday 1.000 Saturday 0.250 Bank Holiday 0.250...

Hi All I have the following table (sample) <tbody> HOST Function SWC Consumption RTB/CTB for TM1 HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD SWC ? HTS ITO...

I can get Excel to insert 1 row between each row to my spreadsheet but I cannot figure out how to make it do multiple rows. john may june frank loose bank crazy I need 7 rows insterted between each row. I have over 1,000 lines..... Thanks.