Media Summary: Try this instead: IFERROR(INDEX($A$2:$A$23, SMALL(IFERROR(1/(MATCH(A$2:A$23, A$2:A$23, ... In this video, we will create 3 different ways to get This video is a step-by-step tutorial on how to get
Array Select Only Unique Array - Detailed Analysis & Overview
Try this instead: IFERROR(INDEX($A$2:$A$23, SMALL(IFERROR(1/(MATCH(A$2:A$23, A$2:A$23, ... In this video, we will create 3 different ways to get This video is a step-by-step tutorial on how to get