I am trying to find a formula that would count an item once, even though, it possibly could appear in the data multiple times. These are babies who stayed in our NICU overnight. We populate this spreadsheet daily, with who was in there at midnight. So, if a baby stays in there for 10 days, they will be on this spreadsheet 10 times. The data element that I'm trying to get at is the # of admits (column Q). I did a simple formula that said if the Date of service (column J) was the same as the babies admit date (column C), to put a 1. There are times though that the baby will not go straight to the NICU. In that case, I am not ever counting that baby as an admit. I need a way to identify those patients that have not been counted yet in column Q, but only count them on their first day in the NICU.

Attached Files

SCN Log 2013.xlsx (360.7 KB, 19 views)