Forum Discussion
To Record Latest attempt....
Hi, I am trying to build a string that can help me with tracking of employees if they have attended last course or not. If they have attended then it will return me date of course attended. But i...
That could be
=IFERROR(INDEX($E$8:$M$8,
AGGREGATE(14,6,1/($E$10:$M$10="PC")/($F$10:$N$10="Yes")*
(COLUMN($E$8:$M$8)-COLUMN($D$8)),1)),
"")
I only unmerged cells with dates and format them with Center Across Selection
Thank You Sergei,
I appreciate your work. I can get similar response with this too;
=IFERROR(LOOKUP(2,1/(E3:M3="PC")/(F3:N3="YES"),$E$1:$M$1),"")
what I am looking in return is:
If attended then return Date in column D
If not attended then NO/AA/UA/Excep(any selected response) in column D.
I appreciate your work. I can get similar response with this too;
=IFERROR(LOOKUP(2,1/(E3:M3="PC")/(F3:N3="YES"),$E$1:$M$1),"")
what I am looking in return is:
If attended then return Date in column D
If not attended then NO/AA/UA/Excep(any selected response) in column D.