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 ?
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...
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...
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 ?
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
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...
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)...
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.
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
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...
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...
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...
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...
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...
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