retail

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)...

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...

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...

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...

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)...

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)...

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...

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"...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...