I've got data in this format:I'm trying to create a combo-box of distinct values in Col1, but when I entere the range in the combo-box it repeats the values for each row.
How can I get a distinct array of values? Seems so simple, but appears to be impossible.

Also, why does Excel's graphing utility suck wind so bad?

I am finding some help on the first part.

Regarding Excel's "graphing utility", what exactly do you mean?

For the first part, try this:

Unique Items in List.

EDIT: Updated link to proper one.

Thanks shades, I will try that out.

And by "graphing utility" I mean MS Chart, which inexplicable has no support for simple features that existing in Lotus 123 ten years ago. Near the top on the aggravation list? Inability to define a series of data to use as datapoint labels. Lotus 123 could do that with three clicks. So could Quattro pro. Excel can't do it at all, period.

Not sure I follow. MS Graph is not part of MS Excel; Excel has its own charting ability. MS Graph is not anywhere near as capable as Excel. Seems that this can be done in MS Excel charts. I use a series of data for labels. But maybe we are talking/writing past each other.