Originally Posted by a.c.sanchez

I've searched high and low and can't get this to work.

I have a range of data from A:M.

I want to create ranges within that range for use in charts, but the data ranges will be grouped by the data in column A. For example:

A B C D
banana 10 5.0% 5.6
banana 11 5.1% 7.2
banana 9 4.8% 6.3
apple 7 6% 5
apple 8 18% etc...
orange etc etc etc
orange etc etc etc
orange etc etc etc

I need to name a range1 that would include all the rows that have "banana" in A, and name a range2 that would include all the rows with "apple" in A, and name a range3 that would include all the rows with "orange" in A.

I think there is something I can do with INDEX, but I just can't get it. One note - the number of rows in each range could change month-to-month, so the references can not be static.

Ideas please!!!!!!!