Forum Discussion
Igor Corail
Jul 18, 2018Copper Contributor
matrice regarding another cell
Hello,
I was looking about "matrice" or any formula, but too much complicate for me.
I've 4 words possible in A column
I'm looking for:
For each column A if value is PDR , the name at his right must
be display in C10 and for another PDR display in C11 and so on.
And if C10 to C20 can be sorted, it will be so good.
Thanks for your help.
1 Reply
- Any chance you could use a Pivot Table instead of a formula. A lot simpler?