retail

1. Macro to change VLookup Range

Hi Guys, I want to update Vlookup range in the report with respect to sheet name in cell A27. <tbody> <tbody> Business Solution </tbody> Connect Status <tbody> Business Retail </tbody> =VLOOKUP(\$B\$11,Oct!C:J,4,0) <tbody> Business Digital </tbody> =VLOOKUP(\$B\$11,Oct!C:J,6,0)...
2. Look Up value based on "X"

Hello I have a spreadsheet like below used by a sales distributor: In this sheet, 1st Column shows items the distributor sells. The next columns denotes the retail or supermarket group who buys items from the distributor. This sheet is maintained on daily basis, and if any supermarket or the...
3. Average formula excluding a specific word in column

Hi all, I am looking for help with a formula which allows me to ignore a specific word in the column. for example; column contains different departments & Retail. I want to do an average of all excluding Retail. I have used this formula to do average of only Retail. Now I need to do average...
4. Marketplace Profit Calculator - Calculating Variable Costs

I'm looking for help regarding calculating profit margins when selling on marketplaces Amazon I'd like to know if it would be possible to set the profit margin to eg. 20% and work backwards from there; have excel calculate what my selling price should be to make the 20%? Fixed Expenses...
5. help with GP% formula relating to more than one cell

Hi I need to know, if possible, I can do this please. I have 4 columns that relate to a sales formula; D = Retail Price (fixed value derived from report) F = Contract Price (fixed value only derived from report) H = Cost Price (fixed value derived from report) I = GP% (has formula as below)...
6. Help creating a formula that solves for highest and lowest X while maintaining values of A and B

Hello all, So this is probably a lot easier to solve than i am making it but i need a formula (or VBA) that will solve for the "Dealer Price" (in blue)...
7. VBA Advanced auto filter for multiple columns containing "y" or "n" - goal is to exclude rows w/ "n" in certain columns

Hi, new to VBA and have been having difficulty finding a solution on the following issue and would greatly appreciate any ideas. Would like to be able to filter the "Data" table based on the following criteria i.e. show all companies that are either "office" or "industrial" or "office" and...
8. Confused - Count in multiple fields

I am current at a loss and in need of help. Below is the data I am trying to count from. I currently have the count function of: =COUNTIF(G1,"<> 0") in column H. This works if there is a balance in column G. I wanted to take it a step farther and basically if G is zero then if F is "114"...
9. Combining data from multiple rows into one row

I am trying to combine data for users who have multiple rows into one single row. All other data is the same except for one column, so I want that one column to reflect all of the data in the first column for that user, separated by commas. Current Sample <tbody> Login_ID Sys1_ID Emp_No...
10. Help Please -Sum off multiple adjacent cells

Hi, I require some help please. I am looking for an equation to that will sum based on multiple adjacent cells have specific terms. I need to total the revenue in row D for all lines that have a specific working in Row A B and C See example below: I need a formula to automatically calculate...
11. Using excel to provide construction works based on building type

Hi all, As part of my role as a construction manager I carry out inspections of properties and tender works for them. The type of property (retail, commercial, industrial etc) determines what sort of typical works that will be required. I have a list of typical works to a building which...
12. Excel Query, difference between dates except sundays

Hello, I want to make by power query a new column that does the difference between the dates but not taking into account the sundays. i hope you can help me thank you <tbody> ORDER COMERCIAL Estado Canal START DATE FINISH DATE PRODUCT 8366934 1 Finalizada WEB 03/01/2017 21/01/2017 4...
13. Difference of dates less sundays

Hello, I want to make by power query a new column that does the difference between the dates but not taking into account the sundays. thank you <colgroup><col span="4"><col><col><col></colgroup><tbody> ORDER COMERCIAL Estado Canal START DATE FINISH DATE PRODUCT 8366934 1 Finalizada WEB...
14. Lookup and populate new worksheet

Hello, I need some help from an excel whizz if possible?? Can this be achieved in excel? My bookkeeper has informed me that the following task is beyond his scope!! Objective: Populate Worksheet 3 with a list of all current active products listing the product name, brand name, quantity of...
15. Assistance Rounding Retail aprices in Excel

Hi all, first time forum reader. Currently working on some price changes in a retail environment. Trying to figure out the best way to apply the following rounding rules: <tbody> IF UNDER 10.00 - ROUND DOWN TO CLOSEST .09 (UNLESS .09 OR .19 - THEN ROUND DOWN TO CLOSEST .99) IF BETWEEN 10.01...
16. Real Estate Rent Roll

I am having difficulty trying to figure out the most efficient and cleanest way to project and roll up for future cash flow modeling a large list of retail tenants. Each tenant has different lease start and expiration dates, rent-able SF, rent price, renewable options, and rent escalations...
17. Geocoded Sales Densities

I have a data dump of sales transactions with corresponding dollar values and delivery coordinates (latitude and longitude). I'd like to run some form of cluster analysis to output a ranked listing of where the highest to lowest density of sales is based on an input of an X-mile radius. I'm...
18. Order Numbers?

Good day, I have a question: I work at a phone retail shop, and we use Excel to make the receipts for our customers. In order to find the receipts back if there's a problem, we have to (manually!) increase a number, the order number, everytime we open the file. So, one customer comes, buys...
19. rota worksheet

Hi everyone, i dont have in depth knowledge of excel but have been trying to build a rota worksheet from scratch, but i am stuck now. I have a master rota which has everyone's ideal shifts and a weekly rota, i have copied master to weekly so when i put in a time on 1 it updates the other and...
20. Price Band help for Retail Finance

I have a list of products and their respective price (by month). In the worksheet I have the products in column A and then months across the top and their prices are the data points. I have already used an array function to count how many of the products fall within various price bands for...

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?

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

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