View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kate Bissell Kate Bissell is offline
external usenet poster
 
Posts: 1
Default Can I change a column of calculated numbers to absolute numbers?

I want to create a summary report from a one year detail report. I have 12
months of data, but I want to total it, sort by the totaled number and get
rid of the detail data. How can I make my sums, or move my column of sums
into a column of absolute number so I can delete the detail, sort by the
remaining totals, to clean up the report?