It does check row by row, so won't flag all mistakes (and it doesn't know
which is good or bad, just shows differences), but you will flag member
numbers where there are differences within a member's data. Use the
Autofilter to show just the member, then show the data in column D for that
member.

HTH,
Bernie
MS Excel MVP

"ieagune " wrote in message
...
Thanks so much for answer............since this formula seems to be
refering to only 2 rows at once (i.e. IF A2=A3), what will happen if i
have about 3 or 4 rows with the same member no (i.e. A2=A3, A4 & A5)
will this code still work and check the dates on all 4 rows?


---
Message posted from http://www.ExcelForum.com/