Recent content by max4asd

Hi Luke, Have you read my last message is it clear for you or you need some explanation. Regards

Thanks a lot luke it works perfectly but i think i didn't communicate one more thing all the KPIs are independently checked only in case of 100% achievement but in case if sales achievement is more than or equal to 110% than discount should also be less by 10% means 5.85% meaning both should be...

Dear All, I would like to have a solution on the below complex calculations. Please help if anybody has a solution for this calculations. Below is the conditions table Targets Incentive Split Sales Discounts Supply Safety Sales Discounts Supply Safety 100% 6.5% 95% 3...

Hi Everybody, I would like to share a bit of challenge i am facing with excel sheet these days i have a file that has a huge data records upto 800k rows of data and coulums upto"Z" i have only one sheet in this workbook and i saved it as .xlsb in order to reduce the file size i am using excel...

Hi Narayan, Thanks you very much for your help and solution it works perfect but could you please explain how you did it. Its very important for me know how it works because it will help me big time in future. I tried to sum up returned value its giving me a #NAME? and when i press F2 i see...

Hi Narayan, Thanks for taking your valuable time and checking it. I amstill trying for it and will wait for your suggestion anyway i need it by comming Monday. Thanks Max

Hi Narayan, Thanks for your advice but when i try the formula its not working with the other two drop downs in the dash board. Could you please please check the attached sample sheet and propose the full solution. PLease anybody know the solution could you please propose the full formula...

Thanks Hui, I didn't the idea I would appriciate if you could do this in the sample sheet i have attached. Thanks in advance. Thanks Max

Hi Experts, Anyone can help on this? Thanks Max

Thanks Luke, Thanks for your suggestion but if i want to use the formula that i am currently using what will be the formula for this to achive the desired result. Thanks Max

Thanks Guys, PLease see the sample file link below. http://dl.dropbox.com/u/79363919/Test%20Dash%20Board%202012.xlsx Point1. Now i want to select region # 3 and the branch selection is "All" i want to display total value for all the branches in this region based on the class selected or...

Thanks Luke, Yes, your right thanks for highlighting it i removed it from the formula but i wnat to attache the sample sheet in order to give you the idea what i nactually needed how can i attach the sheet. Thanks Max

Hi Everyone, I am working on a Dash board and have created 4 different list values and i want to display the data in the table below to show the numbers based on my selection criteria in each list. Right now i am using IF condition with SUMIF function but its working fine with me for only 2...

Thansk Mr. Faseeh, How to add this add in excel could you please eloborate. How to use it once the addon is available. Thanks

Hi, its a great forum and i thanks everybody who shares and provide solutions for the people in excel. The goal seeking feature of Excel is great - if you just do a few cells. But if you have to do goal seeking on many cells, the work gets painful fast. Can we do Multi-Cell Goal Seeker for...