# deposit

1. ### If(And) with a Vlookup

Hi everyone, I have a situation where I've got a spreadsheet with 2 different columns of data that must match. If they match, I'll need to do a vlookup in order to find a specific account ID on another sheet. What I want to do is from sheet 1, if Acct Type = "Deposit", and Tender Type =...
2. ### Mach one value from one colum with multiple values in second column

Hi, honestly i have no idea wich formula to use in excel2010 - to solve this problem. I need to check if deposit 1 is equal with deposit 2. it is easy when there is only one value in both columns (row 1) simple deposit 1 =deposit 2 to give me true or fale value in the check column. However the...
3. ### multiple search criteria

I have this code that searches a list for "Deposit". I would like to search for Deposit & Withdrawal. How can I adjust this code to accomplish this task. Thank you kindly for your help... Do Until Cells(RowNum, 19).Value = "" If InStr(1, Cells(RowNum, 20).Value, "Deposit"...
4. ### Selecting date based on column

I have a spreadsheet in which I need to report the deposit date for transactions. However, the spreadsheet has separate columns to enter deposits dates. For example, cc deposit dates are entered in column A, check deposit dates are in column B, and EFT deposit dates in column C. For the...
5. ### Sumifs

Please see attached doc in the link below. How I return total amount deposit in Deposit Info Tab column C for the right store and date ? http://s000.tinyupload.com/index.php?file_id=92403949706254717342 Thank you!
6. ### Obect variable appears to loose definitions after sucessive cancel clicks in userform

I wrote this project some 15 years ago and my wife has used it successfully for all these years to maintain our household finances. Very infrequently (maybe once a year) she will get the "Object variable not set" error. Of course I can get her up and running in a minute but I was always unable...
7. ### Stuck on Percentage Calculation

Hello all! I am trying to make a simple calculation to work out a property value. If a bank is willing to loan 360k with the understanding that you must put down a 10% deposit on a house, then you can buy a house up to 400k in value. I want to be able to enter the loan amount, and the deposit...
8. ### Applying a set value to columns until the value is reached

Hi and thanks for helping. I'd like to apply a known deposit amount (B1) to a set of projected income for the year (B3 - M3) If the monthly income is less than the deposit a "No Invoice" is returned under the related month (example B4 & C4) If the deposit is applied, but there is a remainder...
9. ### Color range on some condition with VBA

Hi, I have data, and I want to color cell on the column B ("Deposit") and column C ("Withdrawal"), on some condition. Condition:- Rule 1 :- Deposit & withdrawal entry for same date and same amount - color code "green" Rule 2 :- Deposit & withdrawal entry for different dates with same amount...
10. ### Formula to remove text string given certain conditions

Hi, Thank you so much for this forum, it has rescued my formulas so many times with a quick search of the forum posts! I need some help please with a formula I am working on. I am trying to remove a beginning text string in a cell ("DEPOSIT ") but only if it is followed by letters and not...
11. ### Promoting first row as headers (Power Query) - Minor issue

Hi there I am using Power Query to import some standard customer payment reports (csv format) and then clean them up further. The customer payment reports would be in the following format: The first 6 rows would describe the payment file in general (eg. Payment reference #:, date of deposit...
12. ### bank reconciliation file

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...
13. ### if lookup doesn't work...?

Hi Excel Gurus, I have a list of invoice number such as: 12RD000252 15RC000564 18MD000548 18MC004512 type: RD deposit RC credit MD withdraw MC credit I would like to lookup the respective invoices whether it is a deposit or a credit or a withdraw.. I have the respective formula...
14. ### Help needed with PMT Function with an initial down payment

I need help solving the following problem. I know what to do with the standard PMT Function but what does one do when one has an initial deposit or down payment. I have to solve the following problem: A client is interested in a certain insurance product. She expects to earn \$11, 0000 after 18...
15. ### Interest on Term Deposits as on today

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I need to calculate the interest paid out as on today for a large number of Lump sum Term Deposits. Interests on the deposits are paid every calendar quarter...
16. ### how to enter a particular text with respect to other column

Hi I m New to this.and I m very weak in this excel subject A1 B1 C1 WITH DEPOSIT rani general Without deposit hema deepam Without deposit prakash deepam Without deposit sai deepam When ever i ll...