I have a data as below. Now I need the same with Cust ID, Cust Name and 3rd Column as Fiscal Month and get the Month column to Rows and 4th Column as Amount and get those in rows respectively. Can someone help
Before Running macro
The sheeet1 contains following data. I need number of days between 1-4-2014 40 31-3-2019 which should be displayed in shet2
Can I have one formula with 2 vlookup search criterias? I have one list of IDs, list one contains CUST, second list does not. If IDs contain CUST, i want the vlookup to search one row of data to match and return values. If no CUST exists, i want the vlookup to search a different row of data to...
I have a table, which on worksheet one, I get new data every quarter and based on that I create a pivot, and add extra formulas to gather data from the pivot.
Raw data looks like this: https://imgur.com/a/sCkMsMW
I want to make it simpler, since pivots don`t auto update, and the data I have...
folks, when the number of invoices rejected each month, i generate a report that states the total number of rejections, and the count of each of the possible rejection reasons split out by week. Most reasons are pretty obvious: Cust ID not found, Cust under suspension, etc. to do this, I use a...
I am trying to pull information from sheet "data" into sheet "results" I need to know how many times a person's name was listed on the data sheet. I need it to separate out according to the date as well as the person's name. A formula is preferred, I need the number of times "ttest" shows up...
I have a customer list of 14,000 rows of data and I'm trying to match the balance for those customers to an AR Aging table that only has 3,000 rows.
Our customer list has many duplicate names due to having multiple billing addresses for the same customer.
So to get a more refined match I have to...
I am trying to create a report that will look at sales based on two dates that can be entered by the user. Get total sales for 1 time period, then total sales for second time period so a retaliative value can be created and sorted by. I am trying to create a measure that is hard coded to the...
Hello Guys !
Here's what I'm trying to do.
Column A is my customers record.
Column B indicates whether the customer is New or not.
Column D is my Unique customer extracted List.
Reason why I did not put Cust C as he's not a new customer.
What formula should I input in Column E to return a...
I have a dataset that looks a bit like this:
Attempting to lookup by product from a data table arranged like:
I need to be able to lookup the value of sales for product...
I am trying to make a counting for unique value on the same date.
I've seen several formulas here and it's too complex for me to understand :(.
Staff record ( Sheet 1 )
I'm trying to use this table to feed to a second sheet that will break down how many times customers had each unit, and how many times of what type. Everything I've done has resulted in counting every instance of a name. Sometimes a customer has a unit for a few days, sometimes just a day. I...
Assuming I have the following table.
Old Cust # | Customer Name | Email | Phone Number|New Customer Number|
Basically, i need to use this table and check for duplicate records based on Email
Some customers dont have email in the system so i also need to check records based on Customer Name...
can you help with formula? Below is a list of Customer transactions & their values within Industries. Formula should Sum Up Prices in Industries for each Cust ID and return name of Max Sum Industry into Leading Industry.
I have 2 sheets. Sheet 1 contains 5 columns and Cust No is unique id. I need to combine the Column " Amt" based on Cust No and also to copy the latest value for Type /1002 against SAP Period in separate column. Output is shown below to be appeared on Sheet 2.
I need to automate to...
I have 2 sheets. Sheet 1 contains 5 columns and Cust No is unique id. I need to combine the amount based on Cust No and also get the latest value for Type /1002 against SAP Period .
I need to automate to do this in VBA.
Input on Sheet 1
I know how to subtotal in Excel but my dilemma is:
Cust Number / Cust Name / Address / Sales
These are my column headers I subtotal Sales and it gives me a Cust Name with Total Sales. I also need the Address and Cust number for that Customer so I can copy totals over to a new spreadsheet. Does...
I am struggling to work out the logic to determine a match between 2 dates, 2 products and one customer?
What I am trying to do is run a macro or formula to determine from the list where the SAME customer name (col A), matches with a RED & BLUE product with the same delivery date.