• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Report to be generated: Help needed

    Hi Everyone.. Need some help from experts. Sample file attached.. 1. There is input list where on daily basis there will be records will be added 2. Every time need to unique values from Input values (code+Branch Name) and paste in output colum J and k, paste formula 3. I don't want to...
  2. K

    Excel VBA - Can it be run on brower base (office 365) microsoft office outoook..

    Dear Experts, My query is if Outlook software is not installed in computer, and if user is using outlook (Office 365 outlook through brower based login), whether excel VBA will be operative. If yes, what changes would be required to carry out for email sending vba. Thanks.. Kundanlal
  3. K

    Outlook 2013 - Automailer..

    Dear Experts, I am using an Automailer which is taken from our this forum posted by one of our expert friends which I find as an excellent tool for sending mail to multipler email ids. I really appreciate for this code. I don't remember the name of creator but I really want to thank him. I...
  4. K

    Report to be generated from database for Unique Values

    Thanks Rahulji..Appreciated your help..Will try this..
  5. K

    Report to be generated from database for Unique Values

    Thanks Narayanji..Appreciated your help..
  6. K

    Report to be generated from database for Unique Values

    Thanks Narayanji. Enclosed pleaase find database.. Please see Sheet 2..
  7. K

    Report to be generated from database for Unique Values

    ------------------------------------------ Dear Sir, The formula worked fine for entire table. However, now if I add dates in column say (I) in table and if need to generate the report monthwise, how do I go for that.. i.e. for June 19, July 19, August 19, Sept 19 etc., means now unique...
  8. K

    Count the values displayed by Vlook up formula

    Thanks.. In hurry, typo error..
  9. K

    Count the values displayed by Vlook up formula

    Thanks.. attached file with both options..
  10. K

    Count the values displayed by Vlook up formula

    Please read Vlookuobin as vlookup..
  11. K

    Count the values displayed by Vlook up formula

    Dear Sir, But whether it will count while there is formula Vlookuobin those all cells.. I tried this but got error.. Using excel 2007 ver.. Thanks and Regards.. Kundanlal
  12. K

    Count the values displayed by Vlook up formula

    Thank you Sir.. I would try this..
  13. K

    Count the values displayed by Vlook up formula

    Hello Everyone, Need small help. Enclosed herewith a sample file cosist of table as under : Code Emp Name Date Emp Code CON113511 CANEE 19-Jun-19 CON122250 Dodya 20-Sep-19 CON126295 Sumeet 26-Sep-19 CON132221 Pradeep 4-Jun-19 CON132221 CON134709 Laksmikant...
  14. K

    Save Spreadsheets as Separate File with Name and Given Date

    Thank you Sir.. Kind Regards, Kundanlal
  15. K

    Save Spreadsheets as Separate File with Name and Given Date

    Hello Every One.. Need one help.. Enclosed please find a Sample file with some data. I need to Save Each Sheet as a Seperate File (with what ever data available in respective sheets) with Same Name as that of Sheet. Also need to add some Text and date alongwith file name(if vba can as Text...
  16. K

    Sum Data and list Top Three

    Thank you Sir..
  17. K

    Sum Data and list Top Three

    Appreicated.. Thanks Sir.. I will certainly use this... Actually, these report so generated is part of my other report.. Forumula based solution is very much welcome.. Regards, Kundanlal
  18. K

    Sum Data and list Top Three

    Hi.. There is a Raw data (running in 500 rows with multiple Sub-Agent No for earch Main Agent Name) which is required to sum (My Sale Rs-total and Others Sale Rs-total) on the basis of Sub-Agent No+Main Agent Name, rank it on the basis of Others Sale Rs-Total and generate report for top 3 as...
  19. K

    Report to be generated from database for Unique Values

    Appreciated .. Thans Bosco.. Regards, Kundanlal
  20. K

    Report to be generated from database for Unique Values

    Very much appreciated.. Many Thanks..
  21. K

    Report to be generated from database for Unique Values

    Appreciated.. Thanks Harshawardhan.. But, I need formula base solution as the result/outcome is so generated is small part of my other report.
  22. K

    Report to be generated from database for Unique Values

    I am using MS Excel 2007..
  23. K

    Report to be generated from database for Unique Values

    Thanks.. The Report so generated are counting of what ever items (irespective of repeatation) available in column A for given condition. However, the requirement is to Generate Report on the basis of ... Unique Values in Column A for Emp Code=12950 and Customer Type=Green Group or Blue Group...
Back
Top