Selecting valuse from a table
 

I'm consolidating a lot of data from several spreadsheet files into a single,
large spreadsheet. From all this data, I only want to select a single
instance of the occurrance of a value in a column, rather than all the
instances that may occur.

For example, I might have 15 occurrances of the value "15" in the critical
data values column, 10 of the value "rat", and so forth. How do I get just a
single value of "15", a single value of "rat", etc in my new data table?

Do I use a form of HLOOKUP or VLOOKUP, and how do I limit the occurrance of
values returned in my new set of data to a single entry?

Your answers are appreciated.

Thanks,

Dave

Have you considered using the advanced filter? Copy all of your values to
one sheet, select your criteria column and click Data/Filter/Advanced Filter,
check unique records only. You have the option to filter the list in place
or copy it to another location. You could also filter the list in place,
then copy the filtered list to another sheet later on and delete the original
(which will still contain the duplicate data - the rows are just hidden.
When you copy the list to another location, the hidden data is not copied).

"Dave" wrote:

I'm consolidating a lot of data from several spreadsheet files into a single,
large spreadsheet. From all this data, I only want to select a single
instance of the occurrance of a value in a column, rather than all the
instances that may occur.

For example, I might have 15 occurrances of the value "15" in the critical
data values column, 10 of the value "rat", and so forth. How do I get just a
single value of "15", a single value of "rat", etc in my new data table?

Do I use a form of HLOOKUP or VLOOKUP, and how do I limit the occurrance of
values returned in my new set of data to a single entry?

Your answers are appreciated.

Thanks,

Dave

Thanks, JMB. I'll try that.

Dave

"JMB" wrote:

Have you considered using the advanced filter? Copy all of your values to
one sheet, select your criteria column and click Data/Filter/Advanced Filter,
check unique records only. You have the option to filter the list in place
or copy it to another location. You could also filter the list in place,
then copy the filtered list to another sheet later on and delete the original
(which will still contain the duplicate data - the rows are just hidden.
When you copy the list to another location, the hidden data is not copied).

"Dave" wrote:

I'm consolidating a lot of data from several spreadsheet files into a single,
large spreadsheet. From all this data, I only want to select a single
instance of the occurrance of a value in a column, rather than all the
instances that may occur.

For example, I might have 15 occurrances of the value "15" in the critical
data values column, 10 of the value "rat", and so forth. How do I get just a
single value of "15", a single value of "rat", etc in my new data table?

Do I use a form of HLOOKUP or VLOOKUP, and how do I limit the occurrance of
values returned in my new set of data to a single entry?

Your answers are appreciated.

Thanks,

Dave