Hello all! Hope everyone is safe and well. I am trying to pull data from a part of a worksheet based on criteria from a list that has varying numbers of results for each criteria. Sample data is posted below and what I want to get is everything for criteria 1 and then when formula runs out of data for that criteria moves on to next criteria in the list and continues.
24619 this value has two rows in the data | ||||||
| ||||||
24313 this value has three rows in the data | ||||||
| ||||||
What I want to return is 24619 4723084 24619 4723085 24313 4722886 24313 4722887 24313 4723143 | ||||||
There is a lot of data for this. Just trying to make a formula work on vary amounts of each criteria. Hope this makes sense. Formula I am currently trying to tweak is {=IF(ISERROR(INDEX($N$1:$O$273,SMALL(IF($N$1:$N$273=$B4,ROW($N$1:$N$273)),ROW(1:1)),2)),"",INDEX($N$1:$O$273,SMALL(IF($N$1:$N$273=$B4,ROW($N$1:$N$273)),ROW(1:1)),2))} This will pull everything for 24619 if I copy formula down but I want to copy down until 24619 doesn't return anything and then have the formula go to next criteria in the column 24313 and pull all of that data. Thank for any feedback. goletagwt |