T Techtrend Member Jun 11, 2017 #1 The 1st 5 scripts in F col has to be matched in A and K Col and which matches has to filtered in O Col. The f Col data and position keeps changing , Details are mentioned in the attached document Thanks in advance Satish Attachments Filter and match.xls 33 KB · Views: 7
The 1st 5 scripts in F col has to be matched in A and K Col and which matches has to filtered in O Col. The f Col data and position keeps changing , Details are mentioned in the attached document Thanks in advance Satish
V vletm Excel Ninja Jun 11, 2017 #2 Techtrend - interesting terms Compare, Matching & Filtering (manually) - okay but 1st 5 scripts ... I know term 'scripts' but ... here? Attachments Filter and match.xls 45 KB · Views: 9
Techtrend - interesting terms Compare, Matching & Filtering (manually) - okay but 1st 5 scripts ... I know term 'scripts' but ... here?
N Nebu Excel Ninja Jun 12, 2017 #3 Hi: Use the following array formula =IFERROR(INDEX($A$2:$A$20,MATCH(TRUE,COUNTIF($F$2:$F$20,$A$2:$A$20)*COUNTIF($K$2:$K$19,$A$2:$A$20) *NOT(COUNTIF($O$1:O1,$A$2:$A$20))>0,0)),"") Confirm with Control+Shift+ Enter Thanks Attachments Filter and match.xls 48 KB · Views: 9
Hi: Use the following array formula =IFERROR(INDEX($A$2:$A$20,MATCH(TRUE,COUNTIF($F$2:$F$20,$A$2:$A$20)*COUNTIF($K$2:$K$19,$A$2:$A$20) *NOT(COUNTIF($O$1:O1,$A$2:$A$20))>0,0)),"") Confirm with Control+Shift+ Enter Thanks
