Forum Discussion
How to copy row data matching specific column criteria
I'm a beginning Excel user. Still learning terms. I want to copy row data that matches specific column data. The column data I want to match on is composed of Sales Contact names. The Sales contact...
Thank you for your help! I realized I was not clear with my need. I've added more information to my question. The Function needs to be aware of the 10 names that may or may not appear in the AK column.
You need Method 1, with little modifications.
Use this array (CSE) formula where you need, finish with Ctrl+Shift+Enter, and fill across.
{=IFERROR(INDEX($D$4:$AK$13,SMALL(IF(COUNTIF($AK$1,$AK$4:$AK$13)+COUNTIF($AK$2,$AK$4:$AK$13),ROW($D$4:$AK$13)-MIN(ROW($D$4:$AK$13))+1),ROW(A1)),COLUMN(A1)),"")}
N.B.
- Before you use this formula enter those TWO NAMEs in cell AK1 and AK2, you want extract records for them.
- Adjust cell references and NAMEs in AK1 & AK2 as needed.