Thank you. This is great. My only issue is that I will be running the report monthly so the location of the Financial Class header may be in a different location and I was trying to avoid having to enter unique formulas under each financial class. Perhaps the easiest way to avoid this is the...
Hello Ninjas,
I need help modifying a formula that will populate general ledger codes from the "Adjustments Crosswalk" tab column B into the "Adjustments" tab column E. I would like a formula that populates the general ledger code from the Adjustment Crosswalk tab if it finds the matching...
Hello Ninjas,
I am looking for a formula that will calculate Rhode Island Job Development tax rate of .21% on a wage base of $23,000 in columns K and S. I am attaching an Excel spreadsheet that shows the correct tax amounts in columns J and S for months July and August respectively.
I...
Thank you G. Unfortunately, I cannot concatenate the columns on my spreadsheet or it will corrupt all my other formulas on the spreadsheet that were not displayed but I do appreciate your assistance.
Thank you,
Gina
Hello Ninjas,
I am looking for a formula that will populate the values from column C (sheet 2) to column C (sheet 1) if it finds matching data in both columns A & B in sheet 1 and sheet 2. If it does not find matching values in columns A & B, then populate column C, if columns B match in...
Hello Ninjas,
I created a combined if is error and sumproduct formula but it is populating zero values. I am having difficulty determining what the issue is. I am looking for a formula that looks at the matching data in columns a, b and c and populates the amounts from sheet 2, column d to...
I'm sorry. It looks like I spoke too soon. The formula is not working on my actual spreadsheet. I submitted a scaled down version of my actual workbook. The only difference is that my formula is entered in column G versus column E. Would this change the IF(OR) formula that was added at the...
Hello Ninjas,
I would like to modify the formula in the attached document in the 1st sheet, column E so that it also searches for any general ledger (GL) expense account numbers beginning with numbers 6,7 & 8 in the 2nd sheet (see amounts highlighted in yellow, rows 122 to 255) and populates a...
Hello Ninjas,
Attached is the file where I as able to insert the formula to populate the correct amounts from the balance sheet tab to the trial balance tab. I just need to add a condition that converts the amounts highlighted in yellow (liabilities and equity) on the balance sheet tab to the...
Hello Ninjas,
I need help with a formula that will populate values from the Balance Sheet tab to the Trial Balance tab referencing the general ledger account numbers. The issue is that the account numbers in the balance sheet tab vary in length, are listed in different columns, and the...
Thank you Narayan. The formula works great.
Thank you Narayan. The formula works great! Thank you so much. The only issue I see is that the formula needs to modified so that any accounts starting with "4", "N4", "A4", "5", and NG4, need to be populated from sheet 2 to sheet 1 with...
Hello Bosco,
I am trying to incorporate your formula into my actual spreadsheet, sheet 1, cell g80 and I can't get it to work. The correct values for the first 3 rows are in Column H for your reference. Can you assist? Best, Gina
Hello Ninjas,
I need help editing a formula in the attached workbook, sheet 2, cell G80. I believe it has something to do with the offset formula criteria but I am not sure. I appreciate any assistance. Thank you!
Hello Bosco,
You are a genius! Once I changed the B5 to B6, the formula worked! I would love an explanation on the breakdown of this formula and if there are educational materials out there that would help me develop a formula similar to this. You are the best! Happy New Year!
Thank you Bosco. Very impressive :). The only issue I found is that sheet 1, cell E26 is populating the total from sheet 2, M35 of 156,124.60 total 4002ng instead of M34, 4002ng adjustments other 2,936.96.
I was studying your formula and I believe the formula needs to be modified to look for the GL code (i.e. N40010) and to search for the dept number in cells M1 and N1 in sheet 2. For instance, $5,644, cell M10, sheet 2 should be in cell E7, sheet 1. Amount $7,667, N61, sheet 2, should populate...
Thank you for your quick reply. The formula didn't work for all cells because the GL account codes are not all in column H. Some are in column d, e, f, g, & h. Also, it appears that some values are duplicating in sheet 1. For instance, the revenue amount of 5,644 from sheet 2, cell M10 is...
Hello,
I am looking for help on a formula that will search for the dept (i.e. 10, 20) in row 1 and a GL account (i.e. N40010) in a column anywhere on the page on sheet 2 and populate the values on sheet 1, column e. The challenge is that the GL accounts on sheet 2 are not in the same columns...