Hi all
In Row 1 I have the heading names i.e AAA BBB CCC DDD etc
What I would like in column P, it looks at that the cell value, and if there is a yes. it lists it in column P
So :-
-----L---- | -----M---- | -----N---- | -----O---- | -----P---- |
----AAA--- | ---BBB--- | ---CCC--- |...