Search results

Excel Purchase Price Variance analysis setup. Hello! I’m in desperate need of understanding/direction and would be extremely appreciative if someone could help me to understand how to set this up. I am using MS Excel 365 I am working on an Excel project for a perspective employer. I fine with...

Narayan, The data is from one table only. It is shown on the left of the screen shot. As I shared the working example was focused on Grouping. Where the Location2 field is to generate the Regions groups shown in my first example. I re-created the pivot without altering the names. Please see...

Narayan, Thank you for your response. I wondered that as well and should have mentioned that I looked for the possibility by viewing the List Formulas. I found none. Please see the attached. Trianna

Hello everyone. I am working to extend my Excel Pivot skills and have recently purchased the Excel 2016 Bible. An example within the book focused on grouping provides the screenshot attached example. As the example data file comes with the book I'm not sure if I can legally post the workbook...

John, Your example worked like a charm!!! I will need to consider COUNT and COUNTIF going forward. Thank you very much for your assistance. Trianna

Hello everyone, I’m hoping for assistance in creating a calculation within Excel 2016 to count the number of days between dates. Requirements: Count the number of days between Event Start Date and Event End Date If both the Event Start Date and Event End Date cells are empty, cell should...

Hello everyone, I need assistance with VBA code that will extract a text file with both Pipe and Comma delimiters without leaving bland columns. This is what I have so far. Unfortunately, I can get it to do either the Pipe or the Comma but not both without leaving empty columns for the Comma...

Luke M, Thank you for the understanding on the EASY... I think the curse part comes to each of us when we realize that once we have learned a little, we need/crave to learn more. :-) I will deeper in to the COUNT and OR function. I like to keep the formulas as trim as possible. The...

Hello everyone, I have learned so much helpful information from this site, blog and question boards that I feel embarrassed to have to ask for help again. Here is the issue. I have two columns that contain the Start Date and End Date of an event. These columns are the basis of a number of...

ruve1k, Thank you very much!!! It worked perfectly. So well infact I was then able to use that knowledge in other areas of the spread sheet. Thank you again. Trianna

Hello all, I hope that someone will be able to help me resolve a conditional formatting issue. I have a spreadsheet template that is used by a number of users for scheduling and tracking classes. The sheet can contain over 800 row entries with over a 200 different classes available each with...

Hello Everyone, I'm hoping that someone can help me solve my date function issues. I'm working on a spread sheet that will ultimately feed a pivot table report. The issue is I have two columns of dates the first column would be known as the Delivery Start Date and the second the Delivery end...

oldchippy & Hui, I was working in 2003, so used oldchippys suggestion. Brilliant!!! I was able to use the input on other data points throughout the spreadsheet. iferror is definitely in my arsenal. Thank you both so much for your help. Trianna

Hello all, I hope that someone with a brain strong than mine can provide some assistance with VLOOKUP NA errors. I have Excel tables that I am using the following VLOOKUP formulas on. As expected they return the #N/A error when no data is found. =VLOOKUP('Outbound Agent Count'!B4...