J Joe Shaer New Member Sep 22, 2022 #1 Hello - I am attempting to extract 'number of lanes' based on four criteria using the FILTER function. For some reason I keep getting a 'value' error and I don't know why. I am attaching a sample of the work. Hope someone can help. Thanks Joe Attachments Lanes Extraction.xlsx 94.9 KB · Views: 5
Hello - I am attempting to extract 'number of lanes' based on four criteria using the FILTER function. For some reason I keep getting a 'value' error and I don't know why. I am attaching a sample of the work. Hope someone can help. Thanks Joe
B bosco_yip Excel Ninja Sep 22, 2022 #2 Try, this formula instead with highlight red revised In E3, formula copied down: =FILTER($S$3:$S$223,IFERROR((B3=0+($K$3:$K$223))*(C3=$M$3:$M$223)*(D3>=$O$3:$O$223)*(D3<=$Q$3:$Q$223),0),0) Regards
Try, this formula instead with highlight red revised In E3, formula copied down: =FILTER($S$3:$S$223,IFERROR((B3=0+($K$3:$K$223))*(C3=$M$3:$M$223)*(D3>=$O$3:$O$223)*(D3<=$Q$3:$Q$223),0),0) Regards