amount

Hi all I am trying to analyse the following dataset and get the total amount of first 5 items of each group(2 grps in total). I tried to use sumifs but since there are too many unique items in my data, selecting and filtering makes the table too complicated. Thanks for the help in advance...

Hello, please could someone advise me ... this is probably simple for experienced users but I am stumped :eeek: I have strings similar to this (Date, Place, Amount) 30/12/2017 Ultra City Harrismith 393.29 and need to extract the text in the middle ... extracting the date and amount are easy...

Hi all Help! I need to proportion how much in Column C relates to amount column E based on the gross amount in column A (C/E*/A) or (E/A*C) etc. If I manually calculate and add each row individually the total is 6.97 but my formula for all returns 7.30. My example below is a condensed...

Good afternoon: I have 180,000 rows in Excelof bid numbers and award amounts. The problem is the award amounts repeat inevery row. How do I only keep the first award amount and delete the duplicateaward amounts without deleting the entire row. Bid Number Award Amount 1...

Hi I have a dynamic field for get total in my working sheet, Total column is same but row can be variable depending on description include Example cart is here <tbody> S.No Description Code Country Ctn Qty Price Amount VAT % VAT Amount Total Amount Gross Weight (Kgs) Net Weight (Kgs) 1...

I am needing three formulas to help counting dates <colgroup><col width="760" style="width: 570pt; mso-width-source: userset; mso-width-alt: 27794;"> <col width="360" style="width: 270pt;"> <tbody> The number of dates / rows shrinks and grows daily and there is a lot of other information...

I need some help. I have a spreadsheet that has two sides. A shortages side and a Surplus side. The numbers on the two sides two will always remain seperate Basically a Debits and Credits Accounting type setup. Each side of the spreadsheet is an every growing and shrinking with the number...

Hi, I'm trying to find a logical way of doing a task that's not going to take me 100 hours, which I'm learning that this isn't a bad idea as it teaches me more and more about excel. I'm trying to the total amount of people showing up for duty on certain days. My call center sends out a...

This formula works for me except that if 'oas recovery tax'!D5 is greater than a certain threshold, in this case 125650, then it is returning a negative amount. I am hoping that there is a modification to the formula that will ensure that it never returns a value less than 0 (zero)...

I need so assistance with a formula. I am trying to use and if statement to determine a amount. I have a column that has a value of 1,2,or 3. If the value is 3 I need to take the amount in another column and multiply it by -1. Also if the value is 1 but the amount is already a negative...

I am trying to reconcile a bank statement that has a single dollar amount and that dollar amount is made up of potentially 100 individual deposits. My list of single amounts is approx $116k and the amount that cleared is $106k Is there a macro that will test,in a loop fashion, the sum of...

I have multiple columns with alot of data in them. I want to know how many i need of specific items. my table currently looks like this <tbody> Week number Container type Times appeared 1 Grey Tray 10 Black box 5 </tbody> The times appeared column is calculated using countifs but it...

Hello I am trying to create a formula that shows the overdue amount based on amount of days overdue. In this case i am looking to sum up the values that are overdue more than 8 to 14 days. The cells that are overdue are marked with a negative sign...

I have used court calculators in the past to calculate the amount of interest (simple) owed, to-date, on a judgment but have been tasked with something I am unaware how to solve. My best best was to figure out an Xcel formula in hopes of simplifying my life. Judgment was awarded on December...

Hi, Just wondering if anyone has any experience using Teradata database connections and might be able to give me some advice on how to get around the Spool space issues. I am trying to find a way to potentially join a table before query imports the table to cut down the amount of lines that...

Hello forum friends, I have a formula that needs adjustment so that it will show a gradually diminishing dollar amount based on data in an adjacent cell. The formula as it stands is shown below. Excel 2016 (Windows) 32 bitEF62OAS$ 687.00income analysisCell FormulasCellFormulaF62='cpp &...

My formula below works when the value in F69 is higher than the value in E27. However, if the value in F69 is lower than the value in E27, it is returning an amount that is higher than D27 and for the purposes of this workbook, this will not work. This is the problem that I am having trouble...

Hi all I have list of details have dots at the end I want formula to remove all please help me in this. <colgroup><col width="153" style="width: 115pt; mso-width-source: userset; mso-width-alt: 5595;"> <tbody> Match Type . . . . . . Address Number ( # ) . Mailing Name . . . ...

I heard that VBA / Macro could help me with color coding a range of cells based on adding a character to another cell. In this case I am trying to clear an amount from a balance sheet. If I add a C to clear the item I need the three cells to the left of the amount to color code yellow. Can this...

Dear All, I have two worksheet (i.e. Emp_Master & Leave_Paid) I want to update Leave_Sal paid amount from "Leave_Paid" sheet to "Master" Sheet For Example Leave_Paid sheet a2 having emp no 1111 then Macro to copy that number and search in "Master" Sheet Column "A" and then it should Copy...