Spread Sheet Gurus ?

Fergienewbee · Jan 23, 2015

I am in charge of keeping track of the Hound of the Year scores. I have the dogs listed and the hunt date. Using the "fx" function, I have each dog's score from each hunt tallied and totaled. I then have to print out the results and sort from high score to the lowest. Is there a way I can have the computer do it for me? Here's what I mean.

Red Dog 25.3 points 2.
Blue Dog 32.3 points 1.
Green Dog 19.5 points 3.
Lucy Lu 12.4 points 4.
Etc.

I don't think it can, but I thought I'd ask the experts.

Larry

Hank ABAB · Jan 23, 2015

I have Microsoft Excel.
I select what I want sorted, then go to "DATA", "SORT", and follow the prompts.
It works well.
Don't know what you have for a Spreadsheet Program, but yours should do something similar.
I am by no means an expert at any of this computer stuff!

Harry Selleck · Jan 23, 2015

Are you using Microsoft Excel?

If so you can do a "data sort", sorting the ranking high to low.

JohnG IN · Jan 23, 2015

If I understand what you want, you certainly can. Send me your E-mail and I will forward a spread sheet with instructions that should work.
It is a spread sheet I created that my wife uses at horse shows to tally points by horse.
As far as I know my E-mail is open
John G

Nebraska Cowman · Jan 23, 2015

Yeah, sort by column. Either ascending or descending.

Ian Beale · Jan 23, 2015

fergienewbee

I'm presuming you have that data in three columns?

Simple way to sort is

Highlight ALL the data you want sorted (You need to do this to keep things aligned when you sort)

In Open Office select Data, Sort and specify the column you want to sort (your spreadsheet may vary). Then Descending then OK

This will sort into descending order and keep the data lines intact (if you just sort on the column it will do just that and not keep the data entries intact)

You can elaborate on this by specifying data ranges etc if you want to go that way.

Geo-TH,In · Jan 23, 2015

For the past 20 years I've used the spreadsheet on works 4.0. There isn't anything I can't do with it. I write my own equations to add vertically, horizontally, calculate percentages, sort, print just a small part of the total spreadsheet, freeze titles.

I hate using the newer spreadsheets. They just get in my way, especially when it comes to adding columns and printing off just a small part of sheet. There is the old school way, which should still work. If you want to add column A from line 2 to line 10 the equation is =sum(A2:A10). If you want them in any order, just highlight column A 2- A10, go to sort and select sort all. If you fail to tell it to sort everything, it will just sort that column, which I don't think you want.

Just play with it. Most spreadsheets have a help section. Go there.

Fergienewbee · Jan 23, 2015

John G;

Address is [email protected]

Thanks

Larry

Ian Beale · Jan 24, 2015

Geo-TH,In

Similar thoughts

On the principle that my computer should work for me and not the other way

One spreadsheet I'm proud of is for making pipe gates.

Input height and width, frame pipe size and N-stay pipe size if you're using one

Output is where to mark the bends for the outer frame and where to cut

Plus length of bottom pipe

And where to bend the N-stay to what angle and where to cut the end if you're using one

Seems to work for me

Duner Wi · Jan 24, 2015

Here is what I would do. Copy and paste what you have into a new spread sheet and "save as" give it a new name different from your existing name.
Now go crazy with your new sheet. Data sort is the start.High lite what you are sorting. You can't hurt anything as you have your original clean copy.

Spread Sheet Gurus ?

Fergienewbee

Well-known Member

Hank ABAB

Member

Harry Selleck

Member

JohnG IN

New User

Nebraska Cowman

Well-known Member

Ian Beale

Member

Geo-TH,In

Well-known Member

Fergienewbee

Well-known Member

Ian Beale

Member

Duner Wi

Well-known Member

Similar threads