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...

Deepak, The formula is working super fine. I am delivering to my manager today. Thanks.

Deepak, I will test this tonight spending some hours on this. I am 99.99% confident that the small change in the formula will makes the entire billing process fine. I will meet you tomorrow on this to congratulate you. So far so good. Thank you so much, Deepak, you made my project finished.

Deepak, See what it is showing for the Invoice No- ER-260. I think you have done what you can do, but for some reason it is not getting refreshed-up and throwing up the correct result. I am worrying again about this. https://drive.google.com/file/d/0B6GD5M1_zN7bbmk2WDRqaVFwLWs/view?usp=sharing

Deepak, How long this formula works?, I mean how many rows it can handle as the data keep on growing an growing. Can I use it for 1,048,576 rows? Can the formula you mentioned handle/capture and reflect so many rows?? I added some fifty rows, some times it is not reflecting the last record...

Deepak, You are the Hero man, Really you have put a full-stop to my problems I have been facing for the last few days man. I thought it can't be done by Excel and thinking for other options. Everybody is giving me perfect formulas worldwide but I could not get what I want to. Finally it ended...

Deepak, Actually If Col-A is having some data i.e Invoice no, then this formula should extend its range to the same row in Col-H and reflect the same record in the drop-down which was missing. When I try to pin-point the problem I found out that it is NOT properly refreshing after the formula...

Hi Deepak, Thank you so much for the reply, Did you try adding new records and pulling the same by selecting the choice there in the Drop-down. It is not picking up the newly added records for some reason. This is what I have been on for couple of days. Please help me. rkspeaks

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...

Thank you so much, Hui !

Hui, thanks for the reply..But how to link them to the chart's source data. I named them as ranges. Even I accessed the name going to the "Select data" option in the chart. It says the formula you typed contains an error. But the formula works good outside the chart arena. RK

Sorry, a small typo error. The formula I tried is the below one. =OFFSET(Sheet1!A1,0,MATCH(Sheet1!A3,Sheet1!$B$1:$E$1,0),3,1).

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...

Hi kchiba, No, the data keeps on changing and old data will be replaced by the new data in that particular cell. No question of keeping the any data anywhere. I want it get highlighted just for my eye-catch. I tried "Track changes" but that's not what I wanted. And even I am not sure of using...

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...

Sorry Hui, I have given an incorrect explanation of my problem. This is the actual file uploaded. I have sales data relating to all the days including Sat days, Sun days. But I have to take the count of only the Weekdays' sales out of them. I have done something at my end, but it is not...

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...

Smallman, it's just working fine. Thanks a lot.

Smallman, Thank you. Can you instruct me on How to use the code carefully? Because the data range is dynamic as it is a Sales data. And I have 19 columns till column "S" with data validations and formulas in some columns. It should sort only the data with out missing the functionality. Thank you...

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...

Hey , Thanks everybody who got their hands dirty for me. I will try these options and come back to you. Sorry for the late reply. regards RK

Kaushik, I got it man. "=AVERAGE(OFFSET(A1,MATCH(D2,A:A,0)-1,1,-7,))" . Thanks for your effort man. RK

Kaushik, Here is it. http://speedy.sh/jAxaM/WeeklyTemperature.xlsx RK