arrange data in date order, and mark the horoscope dates on it, and note
the row numbers where there is a change, ie it might be 235 then 402

402 - 235 is number with first star sign or


make a lookup table, all 366 dates of year and name of starsign, call
the table starsign

if birth date is in A1, put in B1

=vlookup(A1,starsign,2)

and copy down all 4000 records


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=574151