How to Get Data of a row based on the maximum value of a cell in that row?

[harikrishna]

Hello All,
I have spread sheet with the data till 2000 rows, with 4 columns of data. The headers are like "App Name", "Ram Usage", "Category" & "Total Space allotted"
Column "App Name" will contain names of Different apps might be repeating.
Column "Ram Usage" contains the values of how much currently it using E.g (5%,6%,10% etc...)
Columns "Category contains" names of different Categories like "Food", "Auto", General" etc..
Column "Total Space allotted" will contain values like (10,20,30,etc...)

Please refer to the below table with the data.. From the below data even though "Application Name" is repeating multiple times--
I should have formula in Cell "G3" which shows me only the "Apple" application which is using the maximum RAM usage.
Similarly in cell "G6" should give only the "Car" application which is using the maximum RAM usage.
And in cell "G7" should give only the "Service" application which is using the maximum RAM usage.

Please provide me solution by excel formula or by a macro also is great.

If it is a Macro pls provide me code for copying the whole data in that row which meets the above criteria.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl63, width: 78"]Application
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 74"]
<colgroup><col width="74"></colgroup><tbody>[TR]
[TD="class: xl65, width: 74"]Ram Usage
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 62"]
<colgroup><col width="62"></colgroup><tbody>[TR]
[TD="class: xl65, width: 62"]Category
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 132"]
<colgroup><col width="132"></colgroup><tbody>[TR]
[TD="class: xl65, width: 132"]Total Ram Allocated
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Apple[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]6%
[/TD]
[TD]Food
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Car[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]3%
[/TD]
[TD]Auto
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Apple[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]5%
[/TD]
[TD]Food
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="78"></colgroup><tbody>
[TD="class: xl65, width: 78"]Car[/TD]

</tbody>

[/TD]
[TD]6%
[/TD]
[TD]Auto
[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Apple
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]10%
[/TD]
[TD]Food
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Car[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]4%
[/TD]
[TD]Auto
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="78"></colgroup><tbody>
[TD="class: xl65, width: 78"]Apple[/TD]

</tbody>

[/TD]
[TD]3%
[/TD]
[TD]Food
[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Car[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]5%
[/TD]
[TD]Auto
[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Service
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]7%
[/TD]
[TD]General
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Car
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]8%
[/TD]
[TD]Auto
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 78"]
<colgroup><col width="78"></colgroup><tbody>[TR]
[TD="class: xl65, width: 78"]Service[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]3%
[/TD]
[TD]General
[/TD]
[TD]10%
[/TD]
[/TR]
</tbody>[/TABLE]

 

[alansidman]

Look at this link on Max If https://exceljet.net/formula/max-if-criteria-match

 

[harikrishna]

Hello Sir, Thank you for looking in to my problem.

And the link you have provided is giving Max temp of all the dates, but I need the Max temp on each day. Even if it is possible with macro , i love to use that.

Regards
Hary

 

[alansidman]

You have no dates in your example. How can we help if you don't provide full information in your request and example. Suggest you amend your request and show us an example that is representative of your actual file.