Formula to copy cells with highest values in a new Column by comparing 41 Columns

[lagiosman]

Hi

I am looking for a Formula to copy cells with highest values in a new Column by comparing 41 Columns.


This is my example:

	A	B	C	D	E
1	Old Column 1	Old Column 2	Old Column 3	Old Column 4	New Column
2	23.75	34.41	23.75	8.33	34.41
3	28.59	47.33	28.59	11.79	47.33
4	23.75	34.41	23.75	10.65	34.41
5	23.75	34.41	23.75	9.49	34.41

Please help me with this.

UPDATE!!!
This is the solution, thanks to sktneer and excelliot

Please Login or Register  to view this content.

[sktneer]

As per your example, try this in E2

Please Login or Register  to view this content.

and then drag down.

Is this what you are looking for?

[excelliot]

hi put formula

Please Login or Register  to view this content.

where range is like

Please Login or Register  to view this content.

Cheers!!

[lagiosman]

As per your example, try this in E2

Please Login or Register  to view this content.

and then drag down.

Is this what you are looking for?

Yes this is it. Thank you very much!!

[lagiosman]

As per your example, try this in E2

Please Login or Register  to view this content.

and then drag down.

Is this what you are looking for?

thank you it works

[sktneer]

You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.