You could use data|filter|advanced filter to get a list of unique values.

Then depending on the layout of your data (is it sorted?), you could find the
first and last cell with each value and name that range.

Or loop through all the cells like Vergel suggested.

gwhenning wrote:

I am actually doing a little more than using a filter. Each part number will
have a set of attributes that will need to be graphed on a daily, weekly, or
monthly basis. There are additional columns which I will add to the range, I
just need to know how to select all cells where the value is equal to an
argument I supply, and create a range using those rows, and the columns that
I need.

"Dave Peterson" wrote:

How about an alternative:

Apply data|filter|autofilter to your range
Create a single chart

But change the chart's properties to show just the data on the visible rows.
Select the chart and do:
Tools|Options|Chart Tab|check Plot visible cells only



gwhenning wrote:

I have a spreadsheet that is created from external data. I need to be able to
create a range for all cells matching certain criteria. Not all criteria will
occur every day, and there may be one or many cells containing the same
criteria. For example, Column A contains the Date, and column B contains the
part number. There may be one part number for a given day, or none. I need to
select all cells with part number 111, irregardless of date and create a
named range called 111. I will then create a graph for each named range in my
spreadsheet.

--

Dave Peterson


--

Dave Peterson