price

Do your best to write a formula that will automatically calculate total price for any amount of units placed in C12. Unit Quantity Price per unit below 4 36 5 to 10 34 11 to 30...

Hi guys, so i have a set of data with 600k rows, and i was using index-match to lookup value but its really slow, so i'm starting to look into vba, but, i still dont quite understand the concept of two dimensional arrays, am i able to reference a column with a header name (like python)? and is...

is there any way that I can coloured the first two rows in a worksheet automatically after applying the filters?This is the overall problem :I have got a sheet with columns like thisitem price criteria1 criteria2I have to frequently filter and note down the price of the first two rows of the...

Hi All, I have three columns. Column A - ID , Column B - Price and Column C = Variation In Price. I need to first filter column A for one ID, then apply the formula in the second visible cell in Column C not counting the header - =IF(1-(B3/$B$2)=0,"OK",-1*(1-(B3/$B$2))) and drag this formula...

HI all, I have just joined as i have spent the last hour unsuccessfully searching the net trying to sort out an excel question i have, what i'm trying to do seems pretty simple but i cant figure out how to do it... I'm a basic excel user, using it mainly to create pricelists. So here is the...

Hi. I have difficulties with resolving the following issue: I have the prices for the Product #1 that are monthly revised (Table _ Primary data). Some months are blank, that means there were no price review in this period (e.g. as of 3/1/2019), thus, the price of previous month remains actual...

I have a spread sheet that i am needing a formula in cell "AE3" in it that executes the following: Take the first 3 letters of the value of cell "M3" and if those first three letters equal RUP then populate AE3 with "Run Unit Price".....but if the first three letters in M3 equal CTP then...

HI everyone, im requesting you help to understand the followin issue, im learning about VBA and most of my formulas are translated into VBA by using the recorder, but with this one: =IF(A2="Dash Record"," -PO Title: "&CHAR(10)&B2&CHAR(10)&" -Item Description: "&CHAR(10)&U1&CHAR(10)&" -Cost...

Hi, I am trying to do a function in excel but i am having difficulty coming up with the formula for it. So basically what i want to do is: Column A(Cells in this column are drop downs) Column B Column C Column D Column E Product A...

Hello, I apologize in advance if this has been asked and answered already, i have not found any suitable answer that resolves my problem I will try to explain. I am trying to create a simple inventory valuation template which multiplies price by quantity for items line by line, accumulates the...

Hi there, Im looking for help to write the correct measure to pick the price based on the latest date and time. A simplified version of my data set looks like this : <tbody> ID Price Time 21 15,2 21.05.2019 10:00 21 15,9 21.05.2019 10:10 21 15,5 21.05.2019 10:20 21 14,7 20.05.2019...

Hello All, I've been trying to find a macro to group data from a report. The problem is that the hierarchy it spits out is different so I have been having trouble finding code to work for my scenario. Below is how the data comes in and what it represents. I'm really stuck :/...

Hi there, I have created a macro which saves a sheet from a workbook in a location that that changes daily. This is captured in the macro by using formulas in excel. The macro seems to create the file as expected however I get to the following line and it fails to save .SaveAs...

Hi All, I have a table with a Product Name in column A and a Product Price in column E. I have a 2nd table that has a Product Name in column A, From Cost in Column B, To Cost in column C, and Mark up Cost in Column D I wan to lookup each product in the 1st table into table 2, and if the price...

Hello, hope you guys can hep me with this problem. Below is an example of what my file looks like. I would like to create a unique ID in column A by concatenating the Types in column C and the Product ID also in column C above each table. So for Product A, the expected result in column A...

Hi, I'm trying to do a lookup / match based on both on specific criteria (Product and Type), but also on a date that isn't exact. Here is a sample of the table. It's a list of products, types and Effective Price Dates. <tbody> A B C D Product Type Effective Price Date Price Hats...

Hi all, l got a below sheet template for my business. l would like to calculate the total price to my customer based on the information below & there are some challenge on it when l decide to use "query & if error" function for returning the result...

Please refer to the attached spreadsheet, my property analyzer. You'll see all the columns on the left that show all the important metrics I look for when analyzing potential investment properties. After entering a minimum of data I look to the YEAR 1 COC ROI (COC) (Cash on Cash Return on...

Hello Experts,i have a little challenging question but not challenging for you for sure , i have some customers data and stock and prices , i need to fill in a table for invoices and distribute the stock randomly between the invoices so that each invoice value does not exceed 5000, same...

Which formula would return in Column Q the first value to the left in that row back to Col A. I have numerous columns of price history from a vendor and I would like to use Col Q to reflect the current price, which would be the first value to the left of Col Q in that row.