Hi,

I have a list of over 6,000 staff records in column A, with a date of birth in the format dd.mm.yyyy against each record (in column B). I have been asked to report on which horoscope is the most common out of the staff list. Does anyone know of a set formula I could use to calculate this, or of a cunning way of working this out? :)

Thanks in advance!

Gra-