customers

Morning, I have a userform with a Combobox which is populated from customers names from my POSTAGE worksheet. I would like to select a customers name from the list & then be taken to that customer on my worksheet. Currently my worksheet is sorted by date example A8 01/10/2015 to current info...

I work in a company where I raise order for customers. There's this file that has all names of customers used by SalesReps to order for the customer but from where we download, it comes with all customers both those who has request and those that don't. Now some rows of some customers don't also...

I have a dashboard that I would like to add some customer detail to but I don't want to take up to much space. If i do a top 20 a lot of meaningful customers are left out. Is there any way to lock the size of a pivot table at 20 rows but include a scroll option so that all customers can be...

Hi guys, I would like to ask a little help. I have a report about sales figure. The report contains a lot of sales data of all of the customers. What I would need to do is to create a macro which will create the same report but instead of having all customer together, it would create a file for...

Hello all, This is my first on this forum although I come here quite often to seek solutions. Now I think I've stumbled upon something that has not been yet touched or maybe has been but I was unable to find it. I have a following problem. I need to got though a list of customers and make a...

Can you make a cluster column chart with one series data charted on a secondary axis? For instance, I'd like to show x,000 new customers new customers by month with revenues of $YYY,000 for new customers by month. The issue is, the revenue would need to be plotted on a different axis because...

Hi All, I was wondering if it is possible to ask excel a verbal question via microphone and have excel respond verbally. Example..... You create a data table concerning your customers, rather than use a vLookup function you would simply ask a question and excel would simply answer its...

hello could anyone help with this please i have a large customer list and I want to analyse which customers are down on spend month by month year I’ve year and show on a graph i can do all of the above but the graph is too busy and it’s hard to see the results- out of the list I only want to...

Hi all, I have a very large spreadsheet (7000+ rows). Column B contains various Customer Names that repeat (column name: CUSTNMBR) Column K contains the Unit Price of each invoice (column name: UNITPRCE) I need to know which customers show a unit price of $0.00 AND $10.00. Can anyone...

Hey guys, hopefully someone can help before I get back into work tomorrow... I have a list of ~10 customers, each of which have a target revenue. For all 10 customers I have sales data going from 2013 to date (by month), along with month-to-date sales data for each month. I need to calculate...

Hey Folks, Wondering why my pivot table, which draws from a cube (OLAP) source, isn't filtering on the true top 100 customers we have! The pivot columns are months (August 2017 through July 2018) and the rows are individual customers. My value filter is set to customers, filtering by "top 100...

Hi I’m lookingfor a bit of help with my formula please. I’m trying toVLOOKUP to a table of customers and if they are in my table with a “Y” criteriain column H then I want the word “Exempt” putting in my cell. If they don’thave a “Y” in column H then I want to do an INDEX and MATCH to a...

Good morning all, this is my first post so please be gentle. i have been asked to help build a new system to log the quotes that we provide to our customers and i could really use some help. so far i have designed it so that all of the information is entered and then there is a hyperlink...

Hi, I am using Excel 2007. I want to populate list of customers whom I have lost and are no longer buying from me. I have a huge table with more than 760 customers in listed in Column C from C7 to C2500. In Column H, I have date on which they had purchased. Most of them are repeat customers...

Hi all, Sorry I did submit this to a wrong post. Here I come. I have been trying to work out this formula to auto populate per customer's status with a few steps, by implementing multiple excel functions e.g: replace, cell, aggregate, index: B1 Formula =...

On a tab I have a list of Customers along with their ID. I also have a Template where the user will input information about some of the customers. Right now the user goes to the user Template and copies it and then in a list on that tab selects the customer and then starts entering data. I...

Hi, I have just started with power pivot for the analysis of the company data. I have written a measure to detect new customers. the measure is: =CALCULATE( COUNTROWS(Klant_Groepen), FILTER(Klant_Groepen, CALCULATE(COUNTROWS(Dossier))>0&&...

hi, i have this code ActiveSheet.ShowDataForm I have a hidden sheet name customers and i have a button in another sheet to open showdataform, what I want is that when i click the button would you like to open the form with customers information of the hidden customers sheet. Thank you,

My Combobox lists the customers that are shown in column G (see pics below). Based on the value that is selected, all the rows except those listing that customer(value) are hidden. So... it all works fine, *but* I cant figure out how when the first choice of "Show all Customers" is selected...

Hi, I have the following data: <tbody> Day State Customers 1 NY 500 2 NY 300 3 NY 1000 1 CA 800 1 WA 900 1 OR 200 2 CA 400 2 WA 3000 3 CA 2500 </tbody> I want to rank top 3 cities by customers (regardless of day). Desired result: Top 1: WA , 3900 Top...