Need a date if cell B = car, bus or taxi

[jimboayr]

I have in column A a list of dates from cell A1 down to cell A50.
In column B I can have either car bus or taxi.

What I want to do is have a list running along row 55 where cell B55 has car in it, cell C55 has bus and cell D55 has taxi.

Directley below this in cell B56, cell C56 and cell D55 I want to have the max date from column A.

Hope someone out there can help - I have tried If = Max but I'm going wrong somwhere and can't get it to work.

Thanks for any help that any of you can give me.

 

[T. Valko]

I have in column A a list of dates from cell A1 down to cell A50.
In column B I can have either car bus or taxi.

What I want to do is have a list running along row 55 where cell B55 has car in it, cell C55 has bus and cell D55 has taxi.

Directley below this in cell B56, cell C56 and cell D55 I want to have the max date from column A.

Hope someone out there can help - I have tried If = Max but I'm going wrong somwhere and can't get it to work.

Thanks for any help that any of you can give me.

Try thia array formula** entered in B56 and copied across to D56:

=MAX(IF($B1:$B50=B55,$A1:$A50))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Format as Date

 

[jimboayr]

Thanks for that works a treat.

 

[T. Valko]

Thanks for that works a treat.

You're welcome. Thanks for the feedback!