ieagune,

Instead of VBA, try a column of formulas. Let's say that Member No is in
column A, Start is in column B, and End is in column C, with actual data
starting in row 2. Sort your data based on column A first, then column B,
and then column C.

In cell D2, enter the formula

=IF(A2=A3,IF(AND(B2=B3,C2=C3),"Good","Bad"),"")

Then copy D2 down column D to match your data, then filter to show the "Bad"
only, and you can see where your data is bad.

HTH,
Bernie
MS Excel MVP

"ieagune " wrote in message
...
I have a very large spreadsheet which contains the "MEMBER NO" column,
the services they received at different times and their assigned
"START" & "END DATES" with the company. There could be multiple
entries/rows for each member in the spreadsheet, but the assigned START
& END DATE should be the same for every single row relating to that
member.

This is where I need your help. I need to check that the above is true
i.e. dates same for all member entries.

I could do a "filter" and manually check them, but this would take a
very long time.
Is there any way I can automate this?
Maybe using VBA to write a query that if Member ID is the same, then
Start/End Dates on all corresponding rows should be the same
too.......else highlight the error or do something?
And how do I write this program.......what would it look like.

Thank you very much for your help.


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