customers

I'm attempting to create a measure to show historical numbers for current customers. Current customers is defined as a customer who has had an order in the 3 months prior or 3 months after selected month. I have a fact table (F_Orders) with the order date, customer ID, and Order number. I...

Hi I've built a spreadsheet where I've got a list of say 200,000 Customer Reference Numbers and I setup a loop like For i = 1 to 200000 Range("CustomerID") = Range("ListofCustomers").cells(i) Call ProcessCustomer Next i ProcessCustomer is the macro that does all the hardwork for the...

Hi, How to extract only the list of customers with balance to pay? I have attached a screenshot link and i need to get the details of customers with balance to pay in a separate table. https://ibb.co/WHZkwZF Also need to get only the total balance amount of the customer as shown in the...

Hi, I tried enough but stuck with this problem. request someone to help:( I have list of 10000 Order Ids in column A, & Customer Name in column B. Order Ids are duplicated, some orders will be 20, some order ids will be 50 etc. In Column C i want to give this data. 5% of order Ids Vs total...

Hello - column A is a list of customers. Each customer row has a grand total at the end. The title of that column is "Grand Total". On the next tab I am trying to do a lookup formula that will give me each customers grand total. The Grand Total column number will change each month. I'm...

I have about 40 customers some providing 1-10 ingredients each. Rather than having a worksheet where I have to enter Supplier 1 10 times once per each of 10 products is there a way I can enter the data like its a card. entry : Customer ABC Date Approved : June 2010 #Products Approved: 4...

Hi guys, I have such a difficult time explaining theissue but will try my best and attach file for an example. So in my example: each month a number of new customers come each month (Input),each monthly set of customers has an input on how many times they will return(Input). This will change...

Hi, On my worksheet i have in column A customers names & in column P of that row is the receipt number for that customer. What i would like to happen is when a certain customers name in cell A is selected when i press the enter key have it open my userform called Database & if possible to then...

Hi all, I was trying to summarize just a few hundred rows of annual data today in a simple 3 bar column pivot chart. The main things happening were i) date and ii) # of customers seen by business on those dates. My requestor was looking for 3 specific things in the same pivot chart: a) total...

Hi, I am using an Active X List Box.... Its not holding its selection & every time i have to make a selection when the list drops down. For example i select item 1 & 2 from the drop down list. then when i again go to the drop down list - the selection is not there. its not holding its...

Dear all, I have a sheet with 2 columns: 1. column with a customer name 2. column of contracts, the cells in the Contracts column are hyperlinks. I would like to create a different sheet using data validation list with the names of customers - so if I choose a particular customer name the...

Hi, I have a data set that has a number of customers. Some of those customers have partners/spouses, and I need to focus on "households" where the person to be focused on is the one who has, in order: 1) spent the most or 2) if the same was spent, then the one who purchased the most. The way...

I found some "cascading" combo boxes, but nothing that I could modify to meet my needs. Also there is lots of discussions on "INDEX/MATCH vs VLOOKUP". Its sounds like INDEX/MATCH is what I should be using. I have two worksheets (pretty simply stuff) worksheet1 is a "customers" list (cust...

Hello, We created a macro to send out personalized emails to our customers with each individual email having an attachment of that certain customers invoice. When running the macro I seem to keep getting stuck where it says : MyAttachments.Add(attachment). Not sure if there is some way to...

I have 4 reports that I get The data in these reports is simple, It contains one column with the customer code and a second column with an order entry date The 4 reports are Orders for the last two years Orders for the last Month Orders for the last 3 weeks Orders for the last two weeks I...

I have out grown my current excel method and I have started to think a little more long term in the next phase. I now manage a number of customer's car collections, each with at least 6 or more cars. I currently keep a separate spreadsheet for each customer. When I make an improvement to a...

Hi, I'm having trouble with this problem Construct a forecasting worksheet to calculate: 1. the number of new clients each month, and 2. the total client base (cumulative number of clients signed up) each month. In your model, make projections for 60 months (Periods) for the two scenarios...

<tbody> Jan Jan Jan Feb Feb Feb Mar Mar Mar Subscribers Leads Customers Subscribers Leads Customers Subscribers Leads Customers Homer 5 6 7 6 7 8 7 8 9 Lenny 6 7 8 7 8 9 8 9 10 Carl 7 8 9 8 9 10 9 10 11 Barney 3 2 1 4 3 2 2 1 0...

I have a pivot table (Excel for Mac), where I have buyers in the rows, then products in the columns. The field values are $ paid. I have added a filter for a certain set of products. What I would like to do is to keep the list of individuals that bought one of those products in that pivot table...

I have a sheet with the following: A: State B: Leads (every row has an create date) C: Product (A, B, or C) D: Purchased (0=No, 1=Yes) On another sheet I'm trying to create a chart with <tbody> Product Region Leads Customers 1 New England X Y 1 West 2 East 2 West </tbody>...