I am a member of a fishing club. Each month I need to input the points a member gets based upon fishing tournament. And this changes his and others YTD score. I would like to have a sort function that based upon the YTD score his and others rows would go to the top bases upon the person's score > highest first then the next and so on.

Is this possible? Knowing each month the rankings will change based upon the YTD number.

I have attached spreadsheet showing some results.



I use Mac 2011 ver 14.7.6

Thanks

Attached Files

EXample.xlsx (59.8 KB, 8 views)

Is it something like shown in columns AC:AD?

Attached Files

EXample_2.xlsx (14.3 KB, 9 views)

Yes, but I would like to sort the entire row. For instance move Mike Nemic from row 8 to row 5 colm A thru AA and so on.

Does this make sense? This would change each month.

I think you will need VBA for this and I am not the one to help with that.

Thanks you. I like what you did. Is there a way to do what you did in AC and AD with out using AA (this was manually done and I don't want to do this every month). I can delete this colm if I can get what you show in AC and AD. It shows who is 1st YTD and points and how each ranks YTD.

Thanks for helping me out.

You can delete columns Z and AA, but you must keep present columns AC and AD which contains formulas. You can, if you want, move (not copy) these columns to somewhere out of sight.

Please note that there might be problems if you have duplicate values in column AC. Please write back if that can appear and tell what you want to do in such cases.

Attached Files

EXample_3.xlsx (15.3 KB, 7 views)

OK, I have attached ex 4.
1. If I delete colm Z and AA then colm AE and AF get #REF! in the cells.
2. I do not need colmn Z and AA, which can be deleted.
3. In colmn AE I have 2 Logan Wakefield (greyed out) which I do not understand how or why
4. If I add a name (person joining) what must I do? 2nd grey cell

I know this is taking your time and I am thankful. I can hide colmn if necessary.

Attached Files

EXample_4.xlsx (16.2 KB, 7 views)

At present the formulas span the rows 5:26. If you extend that range in your table you must adjust the formulas accordingly.

Please note that the formulas in column AF are array formulas. They are special in that they must be entered a certain way. Where you normally just press Enter when finishing a formula, an array formula must be entered by holding down Ctrl and Shift before pressing Enter. If you do it correctly Excel will automatically put braces {} around the formula. Don't try to enter these braces manually. This will just lead Excel to think it is a text string and not a formula. When you have entered one array formula correctly you can copy to other cells as you normally do.

You can hide column AB:AC if you want or you can move the formulas in those columns to another place.

Attached Files

EXample_5.xlsx (15.0 KB, 7 views)