Largest value to be displayed

[phil2006]

Hi,

I have 4 columns of numbers in columns A-D which are headed A,B,C,D. In column E I need the letter correspoding to the highest number in the row to be displayed and if two numbers are the equal highest I need both letters to be displayed (e.g 'A,B'). Further to this, I need the letter correspoding to the second highest number or numbers to be displayed in column F.

Any help would be appreciated,

Cheers,

Phil

[daddylonglegs]

Hello Phil,

This is a little tricky because Excel doesn't have a native formula which allows you to concatenate a range.....but if you have only 4 cells you can use a repetetive formula to do the trick.

Try this formula in E2

Please Login or Register  to view this content.

and in F2

Please Login or Register  to view this content.

although if you download morefunc add-in you can use MCONCAT function and employ these slightly shorter formulas in E2:

Please Login or Register  to view this content.

and F2

Please Login or Register  to view this content.

These last 2 would both need to be confirmed with CTRL+SHIFT+ENTER

Note: all formulas entered with "Code" tags to prevent corruption