NoOp wrote:
On 09/12/2009 01:51 AM, Bob Estes wrote:
NoOp wrote:
On 09/09/2009 08:35 PM, NoOp wrote:
I've tried every combination that I can think of (even formating cells
to text) and still cannot figure out how to sort via a column with data
like this:
Sail Number
USA 84
USA 604
USA 275
USA 35024
USA 103
USA 116
USA 38747
USA 72
USA 40
USA 87549
USA 41001
USA 52
USA 28719
Any suggestions?
Thanks to all that offered suggestions... I'll have to give them a try
when I'm back from sailing on Monday.
Gary (NoOp)
I found a way that works reasonably well. First, I copied the list into
column B of a Calc spreadsheet with each entry on its own line. I then
deleted the USA from each row and reinserted it in column A. As part of
the test, I added a couple of entries each for UK and AUS numbers. I
then selected the data to be sorted. I then selected "DATA/SORT, Sort
by column A then by column B". On the options tab, I then selected
"Enable natural sort". Clicking on OK sorted the data first by country
and then by number. This was an alphabetical sort instead of an ASCII
sort which is what I think you wanted. This sounds like a long
procedure, but it took me longer to write up the explanation than it did
to do the sort.
I hope this helps.
Bob
Thanks all. The regatta is over so now I'll have time to experiment.
What I did (the night before the regatta) was copy the data from a web
page (http://www.big-boat-series.com/Event/CurrentEntries.aspx) and
pasted into Calc. I had hoped to sort by sail numbers so that I'd have
an easy reference list as the boats come around my marks (I work
on-water Race Committee).
Turns out I survived without it, but I still want to figure out the sort
puzzle for future situations. A 96 boat list isn't that hard to
manipulate, but anything larger might require a macro if I can't figure
out a simple way to do it with the sort feature.
If all the sail numbers are from the same country (USA) it's very
simple. Copy the sail numbers into column two with each sail number in
its own row. Using the find/replace/all find "USA" and replace it with
nothing. This will delete all instances of "USA". Next, insert "USA"
in column one next to the first number. Select all of the cells in
column one from the first number to the last number including both the
first and the last cell. Select Fill/Down and "USA" will be inserted
into all of the cells. It gets a little more complicated if you have
entries from more than one country. You'll have to repeat the procedure
for each country code. Now you can do the sort. The most time
consuming part of this procedure is copying each sail number into its
own row. Maybe someone else has a fast way of doing that.
I hope this helps.
Bob
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
