Excel Group Min and Min for combination of Groups

[mrtechman]

Hello all ,

I need a help on getting the concept of how to get Max out of a range. Like I have an excel having 100+ multiple entries for a single date and my task is to get the Maximum value for each date , if i do it manually it will take a lot of time.

Any expert , please help for faster solution. Uploading the sample file.

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[mrtechman]

Hi ,

See if this is what you wanted.

Narayan

Thanks a Lot Narayan , just small thing instead of maximum time i need the first occurrence where the maximum value occurred, can you please help on this.

 

[NARAYANK991]

Thanks a Lot Narayan , just small thing instead of maximum time i need the first occurrence where the maximum value occurred, can you please help on this.

Hi ,

Can you specify what is meant by the first occurrence ?

Do you want the time where the first occurrence of the maximum difference appears ? Or do you want the row number where the maximum time occurs ?

Narayan

 

[mrtechman]

Hi ,

Can you specify what is meant by the first occurrence ?

Do you want the time where the first occurrence of the maximum difference appears ? Or do you want the row number where the maximum time occurs ?

Narayan

Yes, The time of the first occurrence of maximum difference.

MR.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[mrtechman]

Hi ,

See if this is OK.

Narayan

I think with little modification i might get what is required but , problem coming in Maximun Column , I am getting the value of first row for each date , but in your excel it is working fine , probable reason i found in your formulae you have used
{=IF(COUNTIF(A$2:A2,A2) = 1, MAX(($A$2:$A$176 = A2) * ($C$2:$C$176)), "")}

however mine is

=IF(COUNTIF(A$2:A2,A2) = 1, MAX(($A$2:$A$176 = A2) * ($C$2:$C$176)), "")

Does starting brackets cause issue and if yes then how to put them as when i am placing manually by typing brackets its not working getting converted to text..

Any thoughts where i am doing wrong..

 

[mrtechman]

I think with little modification i might get what is required but , problem coming in Maximun Column , I am getting the value of first row for each date , but in your excel it is working fine , probable reason i found in your formulae you have used
{=IF(COUNTIF(A$2:A2,A2) = 1, MAX(($A$2:$A$176 = A2) * ($C$2:$C$176)), "")}

however mine is

=IF(COUNTIF(A$2:A2,A2) = 1, MAX(($A$2:$A$176 = A2) * ($C$2:$C$176)), "")

Does starting brackets cause issue and if yes then how to put them as when i am placing manually by typing brackets its not working getting converted to text..

Any thoughts where i am doing wrong..

Hi ,

See if this is OK.

Narayan

Got the braces thing buddy..