sorting,linking and clustering

[cjthorley]

Hi Guys,

Its my fist time on this forum so just wanna say thanks for having me.

Anyway I have two columns like the following

Label Number
A 1
B 2
C 1
D 3
E 3
F 3
G 2
H 2
I 1

I want to group them together by Number, so all the 1s together and all the 2s together…etc. That’s easy but I also want the appropriate label to reorder them selves by linking them to their Number respective number. In sum; when Number is reordered I want Label to move with it. Any ideas??

Im also want to display the results of CLUSTERED items graphically……any recommendations??

Thanks for your time. I hope I get the chance to return the favour.

Cheers

Chris

[cycling-rod]

If Label in A1, Number in B1, and the letters and number beneath their respective headings, as in your post, then use sort. First highlight the range A1:B10 (which covers the entire data). Then click on Data / Sort, and on the Sort panel make sure Number is in the Sort by slot. Select Ascending and select Header row in the My list has. Click OK and the range will be sorted. The result being Label: A C I B G H D E F and Number: 1 1 1 2 2 2 3 3 3 (going down the columns). When sorting always make sure that all the range is highlighted to keep the label with it's number together.

[cycling-rod]

Sorry, Chris, but: "CLUSTERED items graphically", has me beat. Please explain in more detail.

[olasa]

I would use a PivotTable:

1. Mark you list (incl. headlines)
2. Goto menu: Data>PivotTables and PivotChart...
3. Click Next, and Next if your Area is correct
4. Select Layout... and Place first Number then Item in the Row and place Item in Data.
see: http://www.contextures.com/xlPivot02.html
to adjust: http://www.contextures.com/xlPivot05.html
5. Finish...

Graphically? ... try using a Chart based on the PivotTable data


Ola Sandström