View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Hi, PJ-
Before you get too wrapped up in a workaround, may I offer a slightly
different solution? Your note says "Since I can only sort 3 columns"
which leads me to believe you'd prefer to be able to sort on more
columns than that. You can, if you insert a new column (which can
later be hidden from view) that concatenates the values of several
cells.

For instance: you have data laid out in columns A thru G, and you want
to be able to sort on every column. You can do this by adding a new
column I: on each row the formula in I is
=A1&B1&C1&D1&E1&F1&G1
.... which takes the entry from each cell and jams it together into one
value. You can then sort on column I, which is effectively the same as
sorting on each of the seven columns. You can then hide this column if
necessary, or leave it off your printed output.

Does this provide any increase in data precision? Or alleviate the
need to format something so it's real pretty?

Dave O