The Personal Site of Jamel Cato



   Jamel Cato in 2008  

Entries Tagged as 'Excel'

An Easy Way to Master INDEX/MATCH Formulas

September 1st, 2008 ·

At least once a month I use an INDEX/MATCH formula to match and merge patient data from multiple Excel files. I wrote this post because when I first sought to learn the technique I found the other tutorials on the web either lacking or hard-to-follow.

[Read more →]

Tags: Data Analysis · Excel · Jamel Cato