Get the Max Value for Each Row over 3 Fields

[#1]

Hello,

I have the following table:

ak	atd	bk	btd	ck	ctd
15	17/05/2013	10	19/02/2013	3,68	09/02/2013
3	01/07/2013	7	10/04/2013	4,02	23/03/2013
25	24/07/2013	38	22/06/2013	3,89	15/08/2013

• ak (value) & atd (date: DD/MM/YYYY)
• bk (value) & btd (date: DD/MM/YYYY)
• ck (value) & ctd (date: DD/MM/YYYY)

What I need is to get the max value for each row and the corresponding date.

That means I should get something like the following:

value	date
15	17/05/2013
7	10/04/2013
38	22/06/2013

Is there any way to do that?

Thank you!!!

[ychaitanya]

Not Clear with the question.. can you be clear and if possible can you attach app?

[#3]

Hi there,

You can use RangeMax(max(ak),max(bk),max(ck)) for the max of each of the 3 columns.

[#4]

I have this table and I need to get only the values in bold:

ak	atd	bk	btd	ck	ctd
15	17/05/2013	10	19/02/2013	3,68	09/02/2013
3	01/07/2013	7	10/04/2013	4,02	23/03/2013
25	24/07/2013	38	22/06/2013	3,89	15/08/2013

[#5]

your asking max value but in first row 25 is the max  but u highlighted 15?

[#6]

Yes but the max is per row, not per column, that's why.

Max1:

ak	atd	bk	btd	ck	ctd
15	17/05/2013	10	19/02/2013	3,68	09/02/2013