Asked By
gwyneth69
200 points
N/A
Posted on - 10/28/2011
Please observe column A below.
This contains unique ID numbers starting from 1 and followed by unique numbers too.
It is already sorted in ascending form.
Column B has the values for the occurrence of the ID numbers in the first column.
I want to make a table that will get the largest value for each unique ID numbers.
How can I do it?
Current Table: Desired Table:
Column Column
A B A B
1 0.5 4 0.5
2 0.3 5 0.5
3 0.5 6 0.4
2 0.4 7 0.2
3 0.4
3 0.2
4 0.2
Create table that will get the highest value
Hello Gwyneth69,
To create a table that sorts numerical data in
Ascending or descending order in Microsoft office.
We can use Ms-Office Excel:
Microsoft Office Excel
1. Input desired data in cells, example:
|
A |
B |
|
1 |
0.5 |
|
2 |
0.3 |
|
3 |
0.5 |
|
4 |
0.4 |
|
5 |
0.1 |
2. Select or high light column, in this example column B
|
A |
B |
|
1 |
0.5 |
|
2 |
0.3 |
|
3 |
0.5 |
|
4 |
0.4 |
|
5 |
0.1 |
3. Select data from the menu tabs > click sort and filter
To sort/arrange numbers in descending order, click on this icon 
.
4. We obtain the following out put
|
A |
B |
|
1 |
0.5 |
|
2 |
0.5 |
|
3 |
0.4 |
|
4 |
0.3 |
|
5 |
0.1 |
Arranges data from biggest to the smallest 
Arranges data from smallest to the biggest 
Note: Make sure not to mix letters and numbers in an individual cell, this
may not give you the desired results.
You could also use Ms-Office Access, which has a similar sorting & filtering icon as Excel.
Apply as before in Excel.
Kind regards
