I am trying to extract data from a worksheet using an array formula but it will only retu one (the first it finds) value. The formula I am using is: =INDEX($C$2:$C$8, SMALL(IF($B12=$B$2:$B$8, ROW($B$2:$B$8)-MIN(ROW($B$2:$B$8))+1, ""), 1)) found here: Link to Example When I follow the example, I don't get the same result as the person that posted the answer. Could the formula have been "fat fingered"?
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 311
تاريخ: سه
شنبه
31 فروردين
1395 ساعت: 20:04