Recently I was given a list of patients and asked to add a new column to the list containing each patient’s entire set of secondary diagnoses. All secondary diagnoses needed to appear in a single column on the same row with a comma between each distinct diagnosis.
Multiple level drilldown examples in an easy-to-follow format.
I was recently working on a data mining project where I had to clean millions of street addresses. One thing that got old fast was stopping my work to search the Web for a clean list of U.S. states (plus territories) in a particular format. So I made my own set and posted it here so that you and I never have to endure that annoyance again.
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 difficult to follow or understand. This is my attempt at more intuitive explanation.
Recently I had to provide a script to convert a dataset of raw assessment scores into an Oracle table with the scores ordered by percentile rank. This is a common request so I figured a short, non-technical post on percentile ranking might be helpful to a lot of people.