Yes, you are correct! In a much earlier version of the formula, that term
was needed to prevent a value printing out if you copied the formula down
past the end of the data. Somewhere along the line in my development, that
test became unnecessary and I simply never looked back at it to question
whether it was needed anymore or not. Thanks for spotting that.

For the archives, the final array-entered** formula I am proposing is
this...

=IF(MAX(IF((G$2:G$10000=G2)*(L$2:L$10000=L2)*(M$2: M$10000=M2)=1,S$2:S$10000,""))S2,"D","")

Rick


"Lars-Åke Aspelin" wrote in message
...
Even shorter if you remove the
(G$2<"")*
in the beginning of the IF formula.

Lars-Åke

On Mon, 11 Aug 2008 15:07:01 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

I am pretty sure that this slight shorter (less calculations, one less
function call) array-entered** formula also does what you want...

=IF(MAX(IF((G$2<"")*(G$2:G$10000=G2)*(L$2:L$100 00=L2)*(M$2:M$10000=M2)=1,S$2:S$10000,""))S2,"D", "")

** commit the formula using Ctrl+Shift+Enter, not just Enter by itself

Rick


wrote in message
...
Works like a charm, thank you Lars!

Rick, Lars, I REALLLY appreciate you guys taking the time to help me.
I am just learning arrays and am self teaching myself alot based off
researching/reading other posts that people have helped others
through. I really do appreciate both you taking the time and effort
to help me. Thank you SOOO much!