1. J

    debits do not = credits due to rounding when using % to calculate

    <tbody> <colgroup><col><col span="2"></colgroup><tbody> See below example. D671 = 41,298. 41,298 x %. All % = 100% but when the result hits the debit or credit column, debits do not = credits by a few cents. Any suggestions? JE AMT DEBIT CREDIT </tbody> <strike></strike>...
  2. S

    Combinations and permutations

    I have some work, in an Excel spreadsheet. Create an excel where there are 22 players list and create all the possible combinations for 11 players team. The conditions are as below :- Create your Dream11 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget...
  3. C

    Formula HELP!!?

    <tbody> remaining Old Contract Credits 10 Price 30 New Contract Credits 50 Price 25 Out of contract (no credits) Price 35 Remaining Credits 60 </tbody> Order <tbody> order 1 number of books order 2 number of books order 3 number of books Book 1 2 2 2 book 2 3 40 0 book...
  4. H

    SumIfs question

    Hello, I am trying to figure out how to create a formula that will feed into a different worksheet. I have most of it figured out but I am stuck at two parts. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> AsOfDate BankId AccountNumber AccountName BaiControl Currency...
  5. N

    Is it possible to dynamically update an Excel Table and have the master report shrink and grow?

    My goal is to update information in a master report whereby adding information to Excel Tables on other worksheets and have the master report automatically shrink or grow the area required as the data between sections can change? I've looked into several ways to attempt this however in Excel...
  6. leopardhawk

    IF statement

    Hello forum friends, I am having an issue with a formula that I need to modify. I think I am missing an IF statement? Not sure. I know that this is going to be a fairly complex formula and I will be grateful for any help that I receive. The formula in question resides on the 'income analysis'...
  7. V

    combination that nets to zero. and exclude others which are not zero

    I am new to Macros and having a little trouble in identifying a solution I have a row which contains more than 500 items/numbers in postive as well as in negative. these rows match with each other and net to zero just like reconciliation, however, there may be more than 4 negatives which make up...
  8. T

    VBA Import data from Excel to PDF text boxes

    Hey guys/gals, I'm trying to use VBA to populate an interactive PDF with data used from excel. Please refer to the following link, which describes what I am trying to accomplish: Excel data will consist of accounting values, such as various line items...
  9. K

    IF Statement to find Grade Level

    Hi all! Our school require all students to have 23 credits to graduate. For the students to be in 9th grade, they must have less than 6 credits. To be in 10th grade they must have between 6 and 11.99 credits. To be in 11th grade, they must have between 12 and 16.99 credits. To be in 12th grade...
  10. A

    Live Total at Top of Worksheet?

    Hello, I have an accounting worksheet that already has over 1,000 rows, and will continue to gain many more. I was wondering if there is a way to set up cells in the locked row at the top that will always have an up-to-date total of various columns. Ideally, I would have a cell with the total...
  11. T

    Automatic circle lettering

    Hello, Below is a code I got assistance with that automatically letters groups of cells that net out to 0 and makes them red font color: Dim R As Long, X As Long, StartRow As Long, LastRow As Long, Total As Double Dim Status As String, EText As Variant, FNumbers As Variant On Error GoTo...
  12. T

    Automatically letter debits/credits

    Hello, Random question. Is there any way to automatically put in letters for each pair of debit and credits I have in journal entries within excel? For example, I would need A, B, C, D, etc. in a red circle. Thanks, Tony
  13. T

    How to delete credits and debits off the same column?

    Hi, I am trying to go through 5000 odd rows to check if a debit and a credit for the same value exist in column E. Basically, what i need is a macro to check the reference number in column B and delete rows that have the matching debit and a credit for that reference number e:g <TABLE...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back