price

  1. S

    How to analyse correlations?

    Price change % is my column of interest. I would like to measure whether or not there are correlations between Price change % and any of the other columns. What visualisations would be best for this? What I've tried so far is creating pivot tables and grouping by Production year, Category...
  2. G

    Need some help a formula Please

    I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...
  3. G

    Need some help a formula Please

    I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...
  4. VBE313

    Udf vlookup

    I have a table of items that are assigned a fixed cost. Example: Item) Name) Price 1) Red Ruby Shirt) $35.22 2) Blue Tuxedo) $47.90 On a separate sheet I have a UserForm with a list box that grabs the table from the other sheet. I would like...
  5. J

    Working out Minimum Amazon Selling Price

    Hi Guys I'm hoping someone can help. I have a spread sheet with all my products which include the purchase price, shipping costs and fees etc. I have a column for the minimum sale price, and this needs to be the break even price after VAT @ 20%, amazon fees, packaging costs etc Here is an...
  6. K

    SUMIFS Question

    Hello, I have a table that contains 5 different groups of items. Each of those items have a price, on a separate reference table. I am trying to determine the total price of each group using a formula. <tbody> A B C D E 1 ITEM 1 ITEM 2 ITEM 3 ITEM 4 TOTAL PRICE 2 apple...
  7. raj2206

    Need SKU of duplicate/same items sourcing from different Suppliers with best price

    Hello All, I need help on getting SKU value of duplicate/same items sourcing from different Suppliers with best price in the column F. Col # Title Column A Supplier Name Column B SKU Column C Model # Column D Count of Model# Column E Price After...
  8. S

    Help with how to get the data please

    Good Morning, I have two spreadsheets: 1. Is a master file of 10,000 cutomers that contains all information such as name, ID, address, payment schedule, price charged, item brought 2. Is a file that has some information in, but has lots of missing data. I want to use file 1 to populate file 2...
  9. M

    Access Query

    I am wanting to return all records in an Access table that meet a query criteria. The query I have built via VBA code is - SELECT ID, Price, QtyOut, ValueOut, InStock, ValueInStock, Allocated FROM GoodsIn WHERE Item = '9oz Squat Plastic Cup' AND DateIn <# 22/08/2019# AND Allocated = False ORDER...
  10. F

    Find last value in column >0

    Hello all, I'm trying to find the last value in a column that is greater than one. I've got a bunch of columns each with 110 rows of expense data. Each column is a different product type, and each row is a date of the price. Some dates have a zero for the input, as there was no charge on that...
  11. 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...
  12. P

    Search for a value with two criterias

    Hello all! I have a project with a client and I would like a slick solution instead of what I usually come up with, which is bulky and slow. I am calculating a shipping price, where i have the zone and weight of the container. This held together with destination country should give me the...
  13. C

    IF Statement - brain fog!

    Good morning everyone, can anyone help please as Im having a Real brain fog day! My if statement is =IF(G4=E4,F4,IF(G4>E4,SUM(C4-D4*G4))) which is not returning the value expected and I cannot work out where I have gone wrong. Column info C=price 1, D=price 2,E = sum of qty received 1...
  14. I

    Pivot, Vlookup, Index and Match, Powerpivot? What is the best method???

    Hello, Looking for some advise on the the best method for accomplishing this task. I'm working on a project that involves pricing. We want to be able to analyze some pricing, but to do so, I need to transpose multiple lines of data into one line. Here is an example of the data. Customer -...
  15. M

    Vba copy and paste different rows

    I wanna copy rows number 2 and then 9,16... (i+7) from sheet "daily price data" and paste them on sheet "weekly price data" can any body help me on this VBA code?
  16. I

    Assign a cell a specific value

    Hi, I'm not sure if i have the correct title on this thread, here is what i am trying to achieve. I have 4 shipping templates. 1. Flat Rate Envelopes 2. Small Box 3. Medium Box 4. Large Box I also have an excel sheet that has products, each product has one of those shipping methods above...
  17. R

    LBS OZ formula

    Hi, I have done a lot of searching everywhere and came up with a few different ways of doing this, but the final formula that started working for me needs help. Here is what I need: I can only export the data i need from a price field ie: 0.00 due to the limitations of the program I use. A...
  18. M

    Conditional Formatting Formula

    Dear Forum I have a table of data; Columns G to M. This range contains prices, however some columns have no prices so are blank I have added conditional formatting to highlight the lowest price using the Min function, however this highlights all of the blank cells I have tried to correct...
  19. I

    Find last value in row that is not a percentage value

    <tbody> A B C D E F G H I J K L M N 1 Price 2017 Price 2018 Price 2019/01 Price change Price 2019/02 Price change Price 2019/03 Price change Price 2019/04 Price change Price 2019/05 Price change Price 2019/06 Price change 2 20 22 23 4.5% 25 8.7% 25...
  20. D

    Removing spaces from cell with numbers

    Tried formatting the column to Text, Numbers, General, Currency but cannot seem to remove the spaces https://ibb.co/kQXF4GV Both columns are aligned to the left and have spaces in front of them. <tbody> Worksheet Formulas <thead>#DAE7F5[/URL] "] Cell Formula </thead><tbody> #DAE7F5[/URL] "]J2...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top