Please help with Array Formula

  • Thread starter Thread starter David
  • Start date Start date
D

David

Greetings,
I believe that I need an array formula for the folowing:
In range A1:A100 each cell contains 1 character,
either "x" or "y" or "z". In range B1:B100 each cell
contains a date.
In range C1:C100 I would like to return the most recent
date against "X" and the same for "y" & "z" (ie: only 3
dates will appear in C1:C100, each will be duplicated many
times)
Thanks in anticipation,
David
 
Hello David

One way:

In C1 enter:

=MAX(($A$1:$A$100=A1)*$B$1:$B$100)

To be entered with <Shift><Ctrl><Enter>

Format C-cells as date.


--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Leo,
Excellent!
Thanks very much indeed
David
-----Original Message-----
Hello David

One way:

In C1 enter:

=MAX(($A$1:$A$100=A1)*$B$1:$B$100)

To be entered with <Shift><Ctrl><Enter>

Format C-cells as date.


--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.




.
Click to expand...
 
Back
Top