If And Help?
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$10000 =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!
|