Blog

Using COUNTIF In Excel

Why would you use the COUNTIF function? This is a question that you may wonder at times. First of all, you could use it to figure out how many cells in a range match the specified criteria. You could also use it to determine whether or not a value in Read more…

By Chris West, ago
Blog

Excel – Batch Convert XLS To CSV

Update!!! A newer HTML application (HTA) has just been created which accomplishes the same thing but in a more customizable manner. Click here to read the post. Original Post A few days ago, someone asked me to help them convert a large number of XLS files to CSV. Since, while Read more…

By Chris West, ago