Create table that will get the highest value

Asked By 200 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #106951

Create table that will get the highest value

qa-featured

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

Login/Register to Answer

Related Questions