Sort and print?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a work book that completes calcs to give me an output of names score and group, I would like to be able to sort it so that it orders the columns for printing as follows no matter how many names included and group size can also vary:
data Output Resul
Name score group
a 5 Gold b 10 Gol
b 10 Gold a 5 Gold
c 12 Silver c 12 Silver
d 5 Bronze d 5 Bronz

So I would like it ordered by group;score,name,
Thanks in anticipation
 
Hi John
try the following
- goto 'Tools - Options - custom lists' (not sure about the tab name as
I use a non-english version)
- enter a new custom list for your group: Gold, Silver, Bronze
- select your range to be sorted
- goto 'Data - sort'
- Choose your group column as first sort criteria and goto 'Options' in
this sort dialog. Choose your new custom list in this sub-dialog
- choose your other sorting criteria
 
Thanks Frank....To put the icing on the cake, I would now like the print output to show something like

Name score grou

b 11 Gol
a 10
e

c 12 Silve
f
h

d 5 Bronz
g
n

I only need to show 1 instance of Gold,Silver or Bronze. And if possible a couple of spaces between each category would be perfect (also it does not matter where the group would appear in the print). Is any of this this possible

----- Frank Kabel wrote: ----

Hi Joh
try the followin
- goto 'Tools - Options - custom lists' (not sure about the tab name a
I use a non-english version
- enter a new custom list for your group: Gold, Silver, Bronz
- select your range to be sorte
- goto 'Data - sort
- Choose your group column as first sort criteria and goto 'Options' i
this sort dialog. Choose your new custom list in this sub-dialo
- choose your other sorting criteri



-
Regard
Frank Kabe
Frankfurt, German

John wrote
 
Hi
though not tried you may use a pivot table for this report creation.
Use the Name and group column as row item in the pivot table and the
score as data field

See
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
for more infor about pivot tables

--
Regards
Frank Kabel
Frankfurt, Germany
John said:
Thanks Frank....To put the icing on the cake, I would now like the
Click to expand...
print output to show something like:
Name score group

b 11 Gold
a 10
e 5

c 12 Silver
f 9
h 8

d 5 Bronze
g 4
n 1

I only need to show 1 instance of Gold,Silver or Bronze. And if
Click to expand...
possible a couple of spaces between each category would be perfect
(also it does not matter where the group would appear in the print). Is
any of this this possible?
 
Back
Top