Hi JP, this works! Because the second formula (column K) still gives a bird if the first formula (column J) gives a zero instead of a row number (i.e., the bird was not actually observed), i added a numbered column (I). I then sorted Column J, deleted all records with 0, then sorted Column I to put everything back right. It gives exactly what i want. Thanks!!