Blog

Extract a List of Values Filtered by Criteria with Sub-Arrays in Excel

If you’re not careful then array functions in Excel can quite easily melt your brain and cause it to leak out through your various face-holes, so I’m finding this step-by-step guide especially useful this morning.

Extract a List of Values Filtered by Criteria with Sub-Arrays in Excel