Forum Discussion
Highlight First Occurrence across mutliple colmuns and rows.
Hello Karen,
I believe, I got a solution for you.
please see attached workbook and kindly confirm.
Hi Jamil, your answer is as same as Haytham Amairah's answer.
In your file, try to change F22 and G21 to Tony.
Hello Willy Lau
Can you elaborate how you concluded that my answer is the same as Haytham's?
You are wrong about that "Hi Jamil Mohammad, your answer is as same as Haytham Amairah's answer. "
the formulas I used in the conditional formatting are two formulas.
First one =COUNTIF($D$19:D19,D19)=1 Applied to Range =$D$19:$D$37
Second one =AND(COUNTIF($D$19:$D$37,E19)=0,COUNTIF($E$19:E19,E19)=1) Applied to Range =$E$19:$I$37
Haytham's Formula is this below which has nothing to do with either of the above two formulas I used.
=COUNTIF($D$19:D137,D19)=1
Re : "In your file, try to change F22 and G21 to Tony"
it was just a reference error. that is also fixed in the attached file.
Yes, I know. I mean your second formula does not handle a case that the first occurance is former to the current column but with a latter row ( sorry for my poor English).
it is ok. I am not native English either :)
Thanks for clarifying.
Re: "In your file, try to change F22 and G21 to Tony"
that was just a reference error. I fixed it in the attached file.