ExcelBanter - max date based on criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - max date based on criteria (https://www.excelbanter.com/excel-worksheet-functions/203543-max-date-based-criteria.html)

ramudt

max date based on criteria

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

Mike H

max date based on criteria

Please don't start another thread. you have further responses in the original

"ramudt" wrote:

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

ramudt

max date based on criteria

sorry

"Mike H" wrote:

Please don't start another thread. you have further responses in the original

"ramudt" wrote:

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

All times are GMT +1. The time now is 11:15 PM.