Counting maximum number of consecutive missing values
Hello members,
May I ask you help me please?
I have more than 1000 CSV files. I need a macro that could read ALL csv files and write the results ALL in a single .XLS file.
This is my desired output and I attached a sample input file.
*Missing values are defined as "?" in my CSV files.
** All CSV files are not in a single folder. So I will run it several times for each folder.
Thank you.
OUTPUT.png
Last edited by Moriexcel; 12-18-2014 at 05:55 AM.
Here is a bit of code you can work on.
Please Login or Register to view this content.
Workbook Loop
Many thanks the code is helpful and thank you for the link as well.
By the way, do you have any idea, why I can not find the "?" in my files? either manually or using your code the result for "?" is 0. I learnt when I am filtering the C column, it shows me "~?" has filtered ! I've changed the code to "~?", but still the result is 0.
Does anybody has idea about "counting consecutive values" ?
Try this to get the maximum consecutive ? in each file
It is based on Davesexcel's excellent work above
Please Login or Register to view this content.
Last edited by Crooza; 12-17-2014 at 11:37 PM.
Happy with my advice? Click on the * reputation button below
Yes. It works well. Thank you davesexcel and Crooza.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks