customers

Hello everyone, I am trying to create a common sumif formula for different ranges in different excel files. I extract complete list for all customers and then create a separate workbook for each of these customers. Hence these files relate to different customers, with whom I may be dealing in...

Hi guys, I have been given a task and am looking for advice. My boss has 9 customers. These 9 customers are ranked on 12 criteria which my boss has ordered in order of importance. My goal is this: Each of the 12 criteria can have multiple options (this is where the data validation list comes...

I need to do a allocation of time spent with customers using weighted averages I have 10 customers with a % of total of all time spent for each (I don't know the total of all time). I spend 50% of my time with Customer A004. I need to allocate the remaining 50% of my time to the remaining...

Hello, I followed EnterpriseDNA's dynamic instructions to recreate this dashboard from Decisive Data. I'm currently stuck trying to recreate TopX/BottomX in the filters. I can show Top 3, 5, 10, etc., but I cannot get the graph to display Bottom. My selection criteria are: 1st - Revenue and...

I have about 25 customers, some customers have just 1 vehicle, while others have 2, 3 or more. I maintain all of them, both the customer and their car collection. I used to keep one workbook per customer. I would like to use 1 workbook for all customers and their vehicles. This would allow me...

I have a spread sheet where in: column a I have the customer name in column i I have the sale person that sold to that customer. I am trying to list under the sales persons name on another sheet all the customers they have sold to. any help would be great ( I wish to avoid VB if poss)

Experts: I need your help with creating a conditional name range. Here's what I have thus far. Cells A1:A10 are saved as name range "Customers". I then use that name range...

Morning all, I have the working code supplied below. How it works is i make a selection from the combobox & that person in question has its row highlighted & the cell in column A which is customers name is then selected. What i would like to do now at this point is when i hit enter the...

Hi, i have made a simple dax calculation which presents the New Customers: New Customers = IF([LY Sales LC]>0,BLANK(),IF([Sales LC]>0,[Sales LC],BLANK())) i am making a pivot with customer in the row and get the new customers list with sales. My question is how to get the number of New...

<colgroup><col><col></colgroup><tbody> POINTS TICKETS 7,030 17 6,711 16 4,709 14 3,651 13 2,990 12 2,970 12 2,580 12 800 8 300 3 </tbody> Good Day, I would like to ask you in regards the given table above which I like to get the result when it comes to calculate promo...

I received a spreadsheet with a list of customers (around 200) that I need to find in another larger spreadsheet (column with around 2K customers) in order to obtain their ID code. What is the easiest way to do so? The column with the larger number of customers has a filter, which I could use to...

I have an excel file that contains the outstanding customer accounts for multiple locations, each location on its own sheet. Some customers have outstanding accounts at more than one location. I would like to create a single sheet that combines the customers and their outstanding amounts from...

I have a task that I can’t figure out how to achieve. I have 2 workbooks. One contains a list of "Selected" customers in Col A The other contains a "Dump" of all customers with all contact names and details. Again Col A contains names and subsequent Cols contact names and details. What I would...

Hello, I have customer price list information extracted into Excel from our sales order processing system.. It has all my customers and all the SKU's that they buy and associated price. We currently set up a single price list for each customer in the back office system. I know anecdotally...

Good day, Title maybe not describing what I mean I have many tables with different customers Customers are repeating in different tables many times I need to fullfil by hands result table where written which tables containing exact customer I tryed through vlookup, but all I got is a first...

I have a list of line items. Each one lists a type of product that was included in a customers order. In the list, column A is the order number. Several line items will share an order number. In column B I list the date the order was created. In column C I list the email of the person who...

I have a list of line items. Each one lists a type of product that was included in a customers order. In the list, column A is the order number. Several line items will share an order number. In column B I list the date the order was created. In column C I list the email of the person who...

I am creating letters to customers and each tab has a customers information on it. The information on some tabs may have more rows than other tabs. Is there a way to create a macro that sets the print area on each tab based on the last row that has characters in it?

I have an excel worksheet with 4 columns. Around 10,000ish customers. Column A (Customers took 1st survey) Column B (Score on 1st survey) Column C (Customers took 2nd survey) Column D (Score on 2nd survey) Now some customers took the 1st survey, some took the 2nd survey, some took both. I...

Hi, I have a huge data and multiple worksheets and need to consolidate into 1 "Summary" worksheet. Below are the steps I am doing.. 1. add new Column in "Summary" - "July-17"　 2. vlookup new number for the new month from ALL the worksheets　 3. If there is new customer in any worksheet, add...