J
jackie
Hi-
I am trying to create a list of unique records based on the following data.
I want the list to give me Name if Date = 5/31/2007
A B C
Month Name Location
4/30/2007 John Doe Region 1
5/31/2007 John Doe Region 1
4/30/2007 Jane Smith Region 2
5/31/2007 Jane Smith Region 2
4/30/2007 Mike Moore Region 1
I am trying to create a list of unique records based on the following data.
I want the list to give me Name if Date = 5/31/2007
A B C
Month Name Location
4/30/2007 John Doe Region 1
5/31/2007 John Doe Region 1
4/30/2007 Jane Smith Region 2
5/31/2007 Jane Smith Region 2
4/30/2007 Mike Moore Region 1