Recent content by rkspeaks

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