prices

I receive the following data: Book1ABCDEFGH1CodeConfigFlow rateFlor rate/pumpHeadHead unitQtySelling price2code 1D/A21.521.57bar124681.000003code 20125061.540004code 3D/A10106.5bar115857.000005code 20113583.100006code 401685.00000Sheet1 However when I try to list the codes out on a seperate...

I have a workbook with many spreadsheets for assemblies. In the assembly spreadsheets I have detail part numbers that make up the assemblies. I pull prices for each detail from another reference spreadsheet. If there is no detail listed in that spreadsheet, the price field yields an error...

So i'm at work and we have a spreadsheet where every price in cell A is 15% off. we did the right formula in the box (=A1*.85) everything was looking good so we saved it. when i went to open it this morning it hasn't saved the formula the prices are not 15% off. I tired entering the formula...

Hello, I have 2 columns of dates. The first column has all of the dates in the year and the second has dates where the stock market was open, next to which are stock prices. I would like to have the stock prices appear next to the first column where the dates match and on days where there is no...

Hey guys, So I have a sheet that has a list of items (A5 through A20,000, approx). Column B is for unit prices but they are not filled in. I want to populate this column for only specific items (as we only use maybe 100-200 of the 20,000). Is there a way to use a searchable drop down box to...

I have a spreadsheet that contains the following: I am checking prices between 5 different vendors: Columns D, G, J, M and P contains the Vendors Part Numbers Columns E, H, K, N and Q contains the Vendors Prices Columns F, I, L O and R contain the Vendors initials I am trying to set up a...

Dear people, We have received an Excel sheet of our supplier with our purchase prices from the beginning of 2017 with the invoice numbers. I want to check our latest purchase prices with the purchase prices in our ERP system. I do not know how to make one list with article numbers on the left...

Please help if you can So in column "A1" I have a part number like 12345 and in "A2" I have a number 12345C. It goes on like this for 10,000 lines. Column "B" has prices. I need the prices on the same line. I could do this using Vlookup if I could move just he parts with "C" at the end to...

Hi, I’ve been searching in the forums but without any luck I’ve seen very beautiful fórmulas for extracting numbers from text strings but in my case I only need to extract the price from a list of products which names sometimes has numbers inside them and I only need the prices from those cells...

I have a large spreadsheet listing the products manufactured, with all the components used with their prices. A Pivot Table shows each component, the number of times it has been used together with the average, max & min prices. I have been trying to find a way to highlight rows where the...

I'm trying to use a formula on one worksheet that gets data from another worksheet that has an INDIRECT formula and I can't get my formula to work. On the worksheet 'Results' I'm trying to get the data from the last entry in column G on the 'Prices' worksheet. The last row of the 'Prices'...

Hi, I run a subscription club to a club. We are putting in place new pricing, as there is a huge amount of historical prices in there that we need to get back in line. In summary, the new prices will be £40 per month. Some pay this already, so will hold that rate.. so pay a lot less... as low...

If you can help that would be great. Here's the example Dates in years 2018 2017 2016 2015 2014 Prices 5 5 5 7 10 First the lowest price is 5 but then based on that I want the most recent or closest date to current which in this case would be...

I am making a workbook for an auction. I was hoping maybe someone could answer my question. 1. I was needing a formula that would add up all the prices for a specif buyer based on his number. His number is in one cell and his price is in another.

Hi everyone! I'm making a company's stock application in VBA. I have a userform that adds orders details (including unit prices) to a sheet and I want the unit price added to be updated on another sheet (with the current stock). The updated cell would have the value added through the userform...

Hi all! So glad i found this forum, it's a wealth of information for me! At the moment i am trying do display values from specific cells in an excel document. The idea is that i upload an excel document to the server and have a web page containing products, and at the side of each product...

Hello, Happy Holidays. I would like to better analyze data for my work. I don't know how to do this but I would like to know if it is possible and if anyone doesn't mind I would appreciate help with a function that can do this. My data set is 300 columns, and 18000 rows. For this example below...

Hi I need to create a chart using excel to track the supplier history prices. To make it easier for you to understand my thread, I'll give an example: let's say the supplier set a prices for a specific product as following: Nov 07, 2017 $30 Nov 15,2017 $20 Dec 20,2017 $29 Now, the idea is...

Hi there, Would really appreciate any help with this! I have 2 sheets: Combined Data and VGBB Summary. The snapshot below is VGBB summary. What I need to do is bring over all of the prices associated with each category (e.g. Accessories) to the right of the category. My issue is that there...

Hello, I have following system for updating contracts and their prices: <tbody> Portfolio Service Start End Monthly cost (Period 1: 1.4.2016-30.3.2017) Monthly cost (Period 1: 1.4.2017-30.3.2018) Portfolio 1 Service 1 1.5.2016 100 € 200 € Portfolio 3 Service 2 1.7.2016 1.8.2017 300 € 200...