Search results

Hi all, This is a cross post from MrExcel.Com where I have no luck in getting a reply for this. I have a problem with calculating discount in PowerPivot analysis. I have dCalendar , dDiscount, fSaleBook . dDiscount columns: DiscKey, StartDate, EndDate, Product, DiscountName, DiscountPercent...

Hello all, Here is a PowerPivot question. I have Fact table and couple of dim tables. In my Fact table I have my sales DATE range from 01-Jan-2008 TO 31-Dec-2014 in the OrderDate column. Where as in my ShipDate column this range starts from 01-Jan-2008 TO anywhere 80+/- days +31-Dec-2014...

Hi All, This is a cross post which had posted on MrExcel.Com. Waited for couple of hours with no luck. Any help on this will be greatly appreciated. Link below leads you to the problem back ground: http://www.mrexcel.com/forum/excel-questions/856266-how-make-formula-range-expandable.html...

Hi Excel Ninjas, I have a chart data which runs from left to right as dynamic categories. I have a drop down to select these items in A2. Categories as Horizontal... Fruits, Clothing, Auto, Gadgets etc and can increase in future. Criteria as Vertical...Sales, Profit, Advance which are 3 rows...

Hello all, Good afternoon. I have a set of cell values from B2:H10 i.e. say like bullion market data which imported from internet. If some cell value changes up or down from the previous value, how can I conditional-format them without using VBA. If it is possible by using a formula in...

Hello all, I have a file with 3 sheets with Sales data. First sheet is for capturing Sales data, second sheet, with some Weekly Analysis and Monthly Analysis using COUNTIFS, third is charts based on second sheet's formulas. When I use COUNTIFS function to capture the monthly sales nos, the...

Hi All, I have my data like the below mentioned in our Sales Report. We make at least 100 sales entries per salesman daily and we have 50 salesmen. So we are facing difficulty searching for the current date's sales going hundreds of rows deep down. Sno, Date, Salesman, Client, Location etc...

Hello all, Good morning, I have Sheet1 where I have all expenses/payments, say Fuel, Food,Stores etc. I have other sheets named i.e. Labor, Food, Stores, Domestic, Health etc. The moment I enter some payment to hospital and select option1 (drop-down data validation), it should go to...

Hello, I have my data in 12 sheets named by the month names and a Summary sheet. I have to summarize the data. The columns in all the sheets are Product, Qty for 4 regions, Sales for 4 regions, Commission for 4 regions. Each month Sales varies. That's the problem for me to use...

Hey, I have Date field in A column and Temperature in B column. A column goes on till today's date. I have to calculate last seven days' average temperature whenever I open the Excel workbook. If I enter Today's date in C7 (in C7 TODAY function is there), I want the last seven day's average...

Hi Chandoo and all Ninjas, Good evening all of you.. meeting you all after a longtime. Today my questions are : 1. How can I add a Tool-tip for a User Defined Function created by me. Is that possible in VBA for Excel?? If Yes, Just give me some example code in terms of where to place it...

Good Afternoon All, I have a problem in using the index/match formula. Normally it shoots like a Gun. But here I have four criteria in my problem. I got a #N/A error. I have gone thru some of Chandoo's index/match posts. Still I am not clear on one thing i.e. Is there any limit for the no of...

Chandoo and all Ninjas, Dasara wishes for everybody, It's a very Good evening for meeting you all again! Apropos to the post with the title "Extract file name from full path using formulas", I came up with a problem (not to mention, I always come up with problems), which has a difficulty...

Chandoo & Hui and all Ninjas, As things are getting more and more interesting, I came up with an plan for Chandoo to conduct a survey/voting event on the taste of Formulas on the following lines just to add up something to the spice. 1. Most interesting formula. 2. Most intimidating formula...

Hi Faseeh, I am stuck with a complex pivot table data. How can I analyze this in a meaningful format. It contains Indian crop data for 9 crops, for a decade period, across all the states in India. It was requested by my neighbor uncle who is a scientist. Here is the link for the database. You...

Chandoo & All Ninjas, A very Good morning, I have been searching for a writeup on mirror charts. In fact Chandoo has written an article on that. But he did not talk much about the recipe of that cooking. I thought it may be a secret recipe formula like our KFC items, That's why he kept it...

I have a query regarding the Slicers in Excel 2010. Normally we can see slicers and their category items once you insert the Slicers from the Pivot table data. But I want to see the totals of the category items instead of category items. Is it possible? It's pretty straight question, but If...

Hello Hui and Chandoo, Though my question is not directly related to Excel, the answer may be useful for many of the excel users like me. I am an Excel power user. I use lot many excel features, functions, formulae everyday. What is the best configuration for these needs. I have USD 750@ INR...

Hi Hui, Good morning, I have a sheet with all rows as countries, columns named as months. I need to copy conditional format formula rule to other columns. The rule in the CF is if the particular months data is above its average, it will be Green. i.e. (B2>average($B$2:$B$30), then format...

Hi All, I have a problem in building a Sales report. According to the date in "Sales" sheet I should get the cost of the selected product. The cost is in "Itemlist" sheet. Every month the cost may change or may not change which is captured in Price change table in "Itemlist" sheet. But for all...

Good Afternoon everybody, One of my customer asked whether he can maintain his Sales cum Inventory report in Excel 2010. I assured him that he can. He asked me to design one in that case. But I can foresee a problem with his kind of business i.e. his is an Wholesale Automobile Spares shop...