Search results

Hi.. Enclosed file with Database and Report to be generated. Here The database may run in 5000 to 1000 rows. I need to generate Report as under Out Put Report to be Generated Emp Code Green Group Blue Group Others Total 13637 11 9 6 26 12950 9 10 18 37 10670 12 6 0 18 I...

Hello Friends, Enclosed here zip file with two files. 1. Sample File - Sample Data.xls a. First Sheet - Database b. Secord to Forth Sheets - Output for Slide 1, Output for Slide 2 and Output for Slide 3 2. Output file Required - Output Sales...

Got the answer..Thanks..

Hi.. I have an Excel file where I wanted to run my own macro. But when I go to Developer-->Macro menu, I find that there is already one macro available, and only Run and Cancel buttons are enabled. All other buttons are disabled. Require help ## 1. How to activate other buttons. 2. If present...

Many Thanks Nikunji..

Thank you very much.. I appreciate..

Dear Experts, I use simple formulas... Attached herewith sale report where Branch Name, Opening balance, Day Sales and closing balance available in the file. Now, there may be some occassions where some of branch(s) do not send any report and I need to mention this at the bottom of report...

Brilliant Bosco Sir.. Thank you very much for the help extended by AliGW and you.. Very much appreciated..:)

Thank you very much for your support, I appreciate..

No Maam.. I tried in same manner as well as with Ctrl+Shift+Enter... I don't know but value changes.. In fact in case of Ind tot., the dervied figures matched only when I enter the forumula with Ctrl+Shift+Enter.. I am using MS Office 2007.... Is it possible to forward your file..

It is retunring first value of Range C.. Top 1-50 Next 50-100 Next 100-150 Rest Branch Int Tot IND Tot Int Tot IND Tot Int Tot IND Tot Int Tot IND Tot Derived by Formula PUNE 5672.2 1140427.70 148.2 161149.70 79.8 90939.00 17396 197127.2 Expected PUNE...

As shown in file, the file is sorted on the basis of Large to Small for Ind Tot.. (Column D) ..I filtered on the basis of Branch=Pune. The sum of Ind Tot for 1-50..etc matches with the output generated by using the formula you have suggested. Now, using this filtered file only, for these Top...

Thanks.. Workbook attached.. with expected result..as shown in colour range.. i.e. for say yellow colour, Top 1-50 Range of Ind Total is shown, I need to have corresponding cell total of values appearing in Int Tot Range.. The formula you have suggested works Good.

Thanks for immediate response.. This solves half solution. 1. To "Sum Top" means out of Top 1-50, 51-100 etc. from largest to lowest 2. The important column is D in this file.. I wanted to have a total of First ToP say 1-50, Next Top 51-100 etc. .on the basis of Top Numbers appearing in...

Hellow Friends.. Attached herewith file with requirement.. Can any one help here.. Thanks.. Kundanlal

Actually, this works for only if range is >= achievement of G5. But I would like to count all achievements which are less than 100%, between 100% and 110%, 110% and 125% and more than 125%.. i.e. as per tabel..

Dear Sir, Using something like at K5, =COUNTIFS($D$5:$D$35,$J5,$I$5:$I$35,">=&($G$5/ROUND((($E$5/12)*$E$2),2))100%",$C$5:$C$35,"BM").. Please help me in this.. Attaching sample file with required output. (Basically, wanted to count all such records in range with another condition of role='BM'...

I have checked with different machine having win7+xl2007 (xl installed with similar copy in both the machines). Getting similar output as mentioned earlier conversation point 1 and 2. Can it be due to some settings in Ms Excel or due to some other prob. Code runs properly, of course at my end...

Dear Sir, Thanks.. May be system issue. Getting similar output as mentioned in earlier conversation point 1 and 2. I will checkup with another system. Presently using MS office 2007 with windows xp. Regards, Kundanlal

Dear Sir, Thanks for your help. 1. As directed by you, when I executed the code with filter on row no. 3, output files namely, Pune, Aurangabad and Chichwad got created. Out of these 3, Pune is getting full data in AUM sheet instead of one Pune data. Enclosed file (renamed as) Pune1.xls. 2...

Dear Sir, I really admire you for you help extended to me. Only one thing I would like to mention that the filter has to be applied above actual heading.i.e. row where Total heading is in the column F-G. I tried deleting this row and executed the code, same error occured. But when I added...

Dear Sir, Many Thanks.. Sorry to trouble you once again. Attached new file generated where the first filter value is Pune. The sheet viz AUM getting all data instead of filtered value=Pune. While other sheets are OK and rest of files are also OK. Regards, Kundanlal

Sorry Once again.. I have filtered all sheets with heading. However, the first output file only consist of headers while rest starts with subject and data without heading.. Please suggest solution. Regards, Kundanlal

Dear Sir, Problem resolved.. Thanks for your help.. Regards, Kundanlal