Find the largest amount

[RichardAlt]

Hi all,

How can I find the largest amount and copy the data to a blank cell?

I have this sample data.

Column1	Column2	Amount
Debit	2514	652999
Debit	4324	65450
Credit		635450

First I need to find the largest amount which is Row 1,

After I found the largest amount.

I need to copy the column 2 value which has the largest amount to the blank cell.

The output must be something like this.

Column1	Column2	Amount
Debit	2514	652999
Debit	4324	65450
Credit	2514	635450

Thanks all!

[Qiu · Accepted solution]

@RichardAlt 

Something like this?

[marcusblackhill]

Hey @RichardAlt !

Another way you can try similar to @Qiu but one less tool is the attached.

Hope that helps!

[Emil_Kos]

Hi @RichardAlt,

Alternative solution: