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

    Copy the Variable Data from GST site and insert to excel sheet

    I can work on VB Code. If any of the experts work on this query and provide a solution, will be most welcome. VDS..
  2. V

    Copy the Variable Data from GST site and insert to excel sheet

    I am using excel office professional 2010. see pdf version.
  3. V

    Copy the Variable Data from GST site and insert to excel sheet

    Thank you for your reply. But I am not expert in Powerquery/data. When I try to get the pdf copied, the data gets truncated. Can you please correct this ?
  4. V

    Copy the Variable Data from GST site and insert to excel sheet

    Dear All experts, I am trying to create a customer database as per the excel file called "Dummy Data."-Attached. The variable data of excel file is taken from a pdf file after copy and paste. (attached). The attached pdf file is downloaded from the google Site, contains the GST details of a...
  5. V

    Calculate the difference of total number of years, months and days together between starting date and ending date.

    Dear All experts, Kindly provide me a function to calculate the difference of total number of years, months and days together in Excel. I have attached the sample files for your study. I know that the date function and datedif function. Here starting date is 18.01.2018 and ending date is...
  6. V

    Creating a Court diary as per Excel data

    @ Received the message and sample file. Let me work on this and will revert soon
  7. V

    Creating a Court diary as per Excel data

    This seems to be okay. But how to apply the function on the original data ? Shall I copy paste the entire data on this file? Have you applied any macro on this attached excel file ?
  8. V

    Creating a Court diary as per Excel data

    Sir, This is showing error. How I can correct this. Refresh query option is not updating. I am not expert in VB or macro Can you suggest any formula with array commands ? something like =iferror(small(match), etc VDS
  9. V

    Creating a Court diary as per Excel data

    Dear All experts, Thank you very much for the support provided to me earlier by this forum which helped a lot in learning excel. I attach herewith an excel file containing two worksheets. It is the format of cases handled by a law firm. Here, cases are listed before the court date wise...
  10. V

    Arranging of data in separate worksheets

    Sir, Received your file. seems to be okay. Let me work on the file and try with live data. Will revert for any doubt/ query. VDS
  11. V

    Arranging of data in separate worksheets

    Sir, Pls see attached screenshot and reply soon. VDS
  12. V

    Arranging of data in separate worksheets

    Sir Will reply by tomorrow about correct version . Anyway, macro can be applied as a secondary option
  13. V

    Arranging of data in separate worksheets

    Sir, Kindly apply the formula in excel file and share copy as there is no FILTER COMMAND available. Pls see the screenshot also VDS
  14. V

    Arranging of data in separate worksheets

    Dear All expert members, It is has been a long time to put my thread on chandoo.org. I am attaching herewith two files contains the following :- File 1 : in which solution is required. (named SAR lEG CAS DUMMY) File 2 : in which formula has already there. (named VDS--DATA OF CHANDOO)...
  15. V

    How to extract the data from the row text

    This is okay for me sir. thank you very much VDS
  16. V

    How to extract the data from the row text

    In fact, this data has been converted by using OCR from scanned PDF I have used the website avera. pdf. In some cases it works perfect. I have been Anyway, the employee name and code number will also serve the purpose. I have so many documents to type.
  17. V

    How to extract the data from the row text

    Dear respected team members, I am attaching herewith a sample data in which the data has been truncated. Kindly suggest a formula to fit the data into respective places. Solution is required as per sample file. kind Regards VDS
  18. V

    Creating a Court Diary

    Dear excel experts, I attach herewith a sample excel file which shows the total number of cases in a law firm coming in various courts. The attached excel file shows sample of various cases appearing in different courts with different worksheets. I am updating dates (Last date of hearing and...
  19. V

    Filtering of data and separate into two worksheets.

    Dear Experts, I am attaching herewith two excel files. Testing File & Dummy Testing File contains thee worksheets namely "Data", "Active" and "Closed" in which I have separated the data of "Active" and "Closed" by using array formula /command I have to use the same formula in the Dummy...
  20. V

    display correct numeric value for more than 15 digits

    Dear All, If we add any numeric value in a particular cell with more than 15 digits, the last digit will automatically converted to zero. In such a case,any addition, substraction will also result in Zero. I want to do the calculations. After checking, it is found that it is shown in...
  21. V

    Capitalizing

    Dear friend, A small suggestion. Select the area you want. Press ALT + F11 Go to command window. TYPE : selection.value=evaluate("if(row(),upper(" & selection.address & "))") & ENTER. The desired data will be capitalized. PLEASE REMEMBER ONE THING CAREFULLY. IT CAN NOT BE CONVERTED...
  22. V

    Excel file with maximum number of commands

    Dear Respected members, Is anybody else can provide the excel file which uses maximum number of commands. Only functions and not macros. I do understand maximum of 64 commands can be used together. Right now I am using Excel 2010 version. It is only for reference purpose. Take little bit of...
  23. V

    How to calulate total number of Upper case and Lower Case Characters

    Dear All, Great Work. Brilliant aswers................it is too wonderful. Is it can be clubbed into conditional formatting and highlight cell as per user requirement VDS
Back
Top