R
ramudt
it is not working
the data values are as follows
A B C D
= = = =
AAA 01-Sep-08 AAA 5-Sep-08
BBB 02-Sep-08 BBB 5-Sep-08
CCC 03-Sep-08
AAA 04-Sep-08
AAA 05-Sep-08
BBB 03-Sep-08
here d column has the formula as follows
=MAX(IF(A$1:A$10=C3,B$1:B$10,FALSE))
but all the values are showing max of column D.
i need max of AAA or max of BBB
how to do this
output should be as follows
A B C D
= = = =
AAA 01-Sep-08 AAA 5-Sep-08
BBB 02-Sep-08 BBB 3-Sep-08
CCC 03-Sep-08
AAA 04-Sep-08
AAA 05-Sep-08
BBB 03-Sep-08
here BBB is 3 sep
what is the formula i have to use , help me
Regards
Ramkumar
the data values are as follows
A B C D
= = = =
AAA 01-Sep-08 AAA 5-Sep-08
BBB 02-Sep-08 BBB 5-Sep-08
CCC 03-Sep-08
AAA 04-Sep-08
AAA 05-Sep-08
BBB 03-Sep-08
here d column has the formula as follows
=MAX(IF(A$1:A$10=C3,B$1:B$10,FALSE))
but all the values are showing max of column D.
i need max of AAA or max of BBB
how to do this
output should be as follows
A B C D
= = = =
AAA 01-Sep-08 AAA 5-Sep-08
BBB 02-Sep-08 BBB 3-Sep-08
CCC 03-Sep-08
AAA 04-Sep-08
AAA 05-Sep-08
BBB 03-Sep-08
here BBB is 3 sep
what is the formula i have to use , help me
Regards
Ramkumar