More than one maximum value

[madocar]

Hi everyone,

could you help me with this issue? What if I want to copy all maximum value from one table to another. Imagine I have a large table and I want to copy all maximum values with all the rest values (columns). There is a attachment as a example.
Thanks for any help

 

[Mike H..]

Hi everyone,

could you help me with this issue? What if I want to copy all maximum value from one table to another. Imagine I have a large table and I want to copy all maximum values with all the rest values (columns). There is a attachment as a example.
Thanks for any help

Hi,

Check out your workbook. If you drag the formula down further it will return the second largest and resolve ties for 2nd and 3rd place etc.

 

[Somendra Misra]

Hi,

If formula is not a priority you can use Pivot table, see the attached file for the same. I had also given formula solution also.

Sheet1 as pivot table.

Regards,

 

[madocar]

Thanks a lot mates