Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Distinct list of values, and MS Graph sux.

    I've got data in this format:
    Code:
    Col1	Col2
    A	1
    A	2
    A	3
    B	1
    B	2
    B	3
    B	4
    C	1
    C	2
    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?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    I am finding some help on the first part.

    Regarding Excel's "graphing utility", what exactly do you mean?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    For the first part, try this:

    Unique Items in List.

    EDIT: Updated link to proper one.
    Last edited by shades; 02-14-06 at 12:28.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    Quote Originally Posted by blindman
    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.
    Last edited by shades; 02-16-06 at 11:46.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •