Ask Your Question
0

i have golf scores 1 to 17, some doubled and want to display them in another column as positions

asked 2018-06-06 21:06:17 +0200

josand gravatar image

column A 1 3 5 4 2 6 7 8 9 4 3 1 2 and want to display them in column B......ie 1 1 2 2 3 3 4 4 5 6 7 8 9

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2018-06-08 21:13:37 +0200

Ratslinger gravatar image

updated 2018-06-08 21:19:07 +0200

Hello @josand,

It appears you are looking for something like:

image description

Column U is nothing more than the sum of B through S. Column V uses the RANK function. From Help:

Syntax RANK(Value; Data; Type)
Value is the value, whose rank is to be  determined.
Data is the array or range  of data in the sample.
Type (optional)  is the sequence order.
     Type = 0 means descending from the last item of the
          array to the first (this is the default)
     Type = 1 means ascending from the first item of the range to the last.

The Total and Position will vary automatically as scores are entered.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more

Comments

thanks for the swift reply...great, understandable answer.

josand gravatar imagejosand ( 2018-06-08 22:14:33 +0200 )edit

Makes sense. I didn't get the question. Thought it was just about sorting a column of numbers.

hjek gravatar imagehjek ( 2018-06-09 00:57:16 +0200 )edit
0

answered 2018-06-06 22:03:55 +0200

hjek gravatar image

updated 2018-06-08 18:08:00 +0200

Copy column A to column B, then Data -> Sort Ascending.

Edit: If the numbers need to be sorted using only a formula ("automatically"), then if we assume the numbers are in column A starting from A1, fill column B with =SMALL(A:A,ROW(A1))

edit flag offensive delete link more

Comments

that bit i understand however i would like it to be automatic please. i cannot work out the formula.

josand gravatar imagejosand ( 2018-06-08 17:25:20 +0200 )edit

perhaps im not explaining correctly...

13 rows each with a score in columns A and B etc. These scores are added together and shown in another column say column X.

then these scores are to be transposed into positions in column say Z....

             col A.......col B        col C................col.X........col Z

row 1...........6..............6..............5.....................17..........2nd row 2...........5..............7..............4.....................16..........1st

josand gravatar imagejosand ( 2018-06-08 17:44:22 +0200 )edit

I added an answer for sorting using formulas. If this is not what you intended, perhaps you could be more clear?

hjek gravatar imagehjek ( 2018-06-08 18:06:28 +0200 )edit

thanks for the swift reply...great, understandable answer.

josand gravatar imagejosand ( 2018-06-08 22:13:57 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-06 21:06:17 +0200

Seen: 38 times

Last updated: Jun 08 '18