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

    Congrats Shrivallabha for 1000 Post

    Hi Shrivallabha Congratulation on your 1st Mile stone keep watch guide us
  2. sgmpatnaik

    Functionality similar to =(formula)

    @Sinu Please upload a sample file with your desire request i will try to solve your problem other wise our Ninja's too Thanks
  3. sgmpatnaik

    Compare Data

    @Dede Please start a new conservation Thanks
  4. sgmpatnaik

    Functionality similar to =(formula)

    @Sinu Welcome to Chandoo.org, Glad You Are Here Please check this link http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/ and http://www.contextures.com/xlDataVal14.html Hope It solves your problem, if any problem please come back Thanks
  5. sgmpatnaik

    HI Deepak can you do the same thing for me to search the dealer from This link...

    HI Deepak can you do the same thing for me to search the dealer from This link https://odishatax.gov.in/portal/Shared/DealerSearch.aspx
  6. sgmpatnaik

    how to get data from online data base.

    It is a Rajasthan Commercial Tax Department Site and here it must need to login http://www.rajtax.gov.in:7777/vatweb/ after that we can do any thing
  7. sgmpatnaik

    View PPT slide on Excel Userform but not as Image

    @Asheesh Welcome to Chandoo.org Forum, Glad You Are here please refer the Below links may be it will give some idea http://www.pcreview.co.uk/forums/powerpoint-chart-preview-vba-userform-t3463215.html and http://www.vbaexpress.com/kb/getarticle.php?kb_id=756 Thanks
  8. sgmpatnaik

    Need help with if statement dates

    Please don't cross post here it is like a spam http://chandoo.org/forum/threads/if-statement-for-dates.18088/ Already Luke M replied and he request something from your so try to replay there and sure you will get the result for your querry Ninja's kindly lock this for thread for further...
  9. sgmpatnaik

    Excel Checkboxes Performing Word Doc Merges

    @sammyp1 i will try my level in this between may be our Ninja's can Help you on this Thanks
  10. sgmpatnaik

    How to capture the amount against last row of same date

    @bobhc The OP is asked about the date column which is some extract using with Advance Filter option for Dates
  11. sgmpatnaik

    How to capture the amount against last row of same date

    @kumar You can use the Advance Filter option to extract the data
  12. sgmpatnaik

    How to capture the amount against last row of same date

    Kumar@raja Please Try this formula with Array - Ctrl + Shift + Enter =SUMPRODUCT(MAX((Amount)*(Date="05-06-2014"))) Amount is column B and Date is Column A Hope it solve your problem Thanks
  13. sgmpatnaik

    inserting "-" where cells are blank

    @paramnayak i am not sure what you think, if the cell is blank then the "-" symbol to be appear if cell is not blank then what? the result may be like this =If(A4="","-","") Then you will get the "-" if the a4 is blank Thanks SP
  14. sgmpatnaik

    How to check duplication if duplicate data in 4 diffrent column .

    @jitesh54 Welcome to chandoo.org forum, glad you are here as per my guess is correct, you can use the Conditional format for highlight the duplicate data in particular Columns Please Follow the steps 1. Select the data 2. Select the Conditional Format in Home Tab under Style 3. Select...
  15. sgmpatnaik

    Inventory workbook macro

    Cross Posting http://chandoo.org/forum/threads/need-help-vba-move-data-from-one-sheet-to-multiple-sheets-customerwise.18016/ Ninja's please lock one Thanks SP
  16. sgmpatnaik

    Userform with selection areas.

    Please Upload a Sample File Thanks SP
  17. sgmpatnaik

    Create formula in pivot table

    @Rohit Kumar i think it is better to upload a sample file with your request and it is better to help you the forum reader and Ninja's Thanks SP
  18. sgmpatnaik

    Excel Checkboxes Performing Word Doc Merges

    @sammyp1 if possible please upload a sample file with your request Thanks SP
  19. sgmpatnaik

    Need Help,VBA Move data from one sheet to multiple sheets customerwise

    @rdmqpr why not you try the advance filter option, please download the file and check if any problem please inform i have created a new tab named with Shop Data there i have mention as per your requirement Thanks SP
  20. sgmpatnaik

    Userform with selection areas.

    @Izu Please elaborate some more details, sorry i can't understand what do you say Thanks SP
  21. sgmpatnaik

    Extract data to next columns

    @Puttaswamy Welcome to Chandoo.org Forum, Glad you are here Another method you can use the Offset Function Say your data in A1:A100 and you want to reflect the same value in another columns then just type in B1 = OFFSET(A1,0,0) now copy the formula and paste in your required columns from Ex...
  22. sgmpatnaik

    Multiple Users for one userform

    @Anamika Please have a look http://answers.microsoft.com/en-us/office/forum/office_2007-excel/allow-multiple-users-to-access-and-fill-in-the/aba97e43-f2b0-47d6-84d6-10a948c4311a ND...
  23. sgmpatnaik

    Userform with selection areas.

    @Izu Welcome to the forum, glad you are here Please download the file again and Press the Alt + F11 there you will find a UserForm1 press the F5 button then change the text from the Combo List and see what happen. if any issue please come back again with full details actually what do you...
  24. sgmpatnaik

    Excel Vba to open PDF and print

    @Subageethan Sorry for my late replay just i was out way from this Forum for long time so i didn't check any posts here, i think your problem may solve if not then please re-post with new question @KapooK Can you elaborate us what do you mean may be some body help with your problem or me...
  25. sgmpatnaik

    Alt+Down Arrow Key Shortcut

    @Somendra Misra The Drop Down list is showing only for Text in the particular Columns and not for Dates and Amount too Thanks for your feedback Regards SP
Back
Top