Please help with Array Formula

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
 
L

Leo Heuser

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.
 
D

David

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array formulas help needed 3
Looping through permutations 7
SUMIF with date ranges 2
% formula info 1
IF or Array formula excel .. help ! 2
Countif statement using dates 15
Array Formula 2
SUMIF where the criteria is 'if contains a string'? 5

Top