Search results

Hi Ninja's, Please help me to get the desire output. 6% 7.0% 9% Jan-14 Feb-14 Mar-14 Q1 I want to divide 100 in 3 month as per % in row1. Thanks for your help. Regards, pAvi

Thanks Hui sir it's working fine. @Debraj : image I uploaded is for representation only. Regards, pAvi

Hi All, Please help. I want to create worksheet with name list. I have 50 name and I want to create sheet with each name. Regards, pAvi

:awesome:

SM, V_Agarwal & Faseeh Thanks a lot all 3 formula working. Thanks again. Regards, pAvi

Yes Sir I checked it's correct. Thanks. Regards, pAvi

Narayan Sir, Highest number in every row should be fill complete but when I trying to use format painter it take highest in range and fill complete. Regards, pAvi

Ok lets say Model 17 in data range AM2:AO78 have customer Cust10 & Cust101 to result should be 4 because Cust101 is not there in range F2:AF2. Please check uploaded file. Regards, pAvi

Thanks SM, I have to sum only for customer which is in row 2 because AM2:AO78 have customer other than F2:AF2. Regards, pAvi

Narayan Sir, Zero value also showing bar which is I think should not show. Regards, pAvi

Dear Ninja's I have data AM2:AO78 and I want formula in AG3 sum of all customer for model1. Please check uploaded file. Regards, pAvi

Thanks Narayan Sir, I want to apply for each row not entire area, I want to show row wise data bar when I select entire area it wil take highest amount from entire area and still facing different format for row 14 to 35. When I am changing the range aur use format painter then also its...

Dear All, I have a data D2:AF42 with conditional formatting (Data bar, Gradient fill) but in row 14 to 35 showing different type of formatting. Please help. Regards, pAvi

Great SM, Thanks alot I will incorporate your solution in my actual file and get back to you if require any help. Thanks again SM :) Regards, pAvi

Thanks SM, Table AL2:AS111 for calculation. Regards, pAvi

Hi, Can you help me for one formula. Please check uploaded file which I try to make interactive. Regards, pAvi

Dear SM, Thanks for your help now I will going to make this report interactive. I will ask if I need any help. Regards, pAvi

Dear SM, I uploaded the file which I think is not telling the performance story. Suggest me how you will present the report in same data. Regards, pAvi

Yes SM your are correct. Regards, pAvi

Dear SM, Thanks for your reply, I am asking for idea how to present this data to GM-Sales for analysis. I already uploaded the file with data. It will be helpful if you put your thought on this. Regards, pAvi

Hi, can any1 help me. Regards, pAvi

Thanks Narayan for your reply. I want to present interactive report for all area with comparison growth or degrowth. data showing YTD figure. Regards, pAvi

Dear All, Please suggest how to present attached report to Sales GM for Analysis. Regards, pAvi

Thanks Luke, very helpful link. Regards, pAvi

Dear Sudipto3003, Thanks for your reply. I am not looking for pdf to excel converter. You can see the file SABB Form Print.xlsm I want the way this file created. Regards, pAvi