Blog

Excel – Coalesce Function?

Unfortunately, after googling for a while, I was unable to find a COALESCE function or something similar that natively exists within Excel. Therefore, I decided to write a quick-and-dirty formula that would approximate it. I used the following array formula to pull the first non-blank value from cells C2 to Read more…

By Chris West, ago
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