Need to Randomly select entries that match a specific criteria

[Latisha10]

Hi,

Tried this formula initially but its pulling random entries without considering the criteria set.

INDEX(Data!$B$2:$B$32901,LARGE(IF(Data!$D$2:$D$32901=B1,ROW(Data!$D$2:$D$32901)-ROW(Data!$D$3)+1),INT(RAND()*COUNTIF(Data!$D$2:$D$32901,B1)+1)))

Have uploaded the file, really hope someone can tell me what i messed up.

An extract of the dataset is as per below. Basically i want to pull random entries of PINNO from specific locations.

Tranno PINNO AgentName Location
1142 *21234 V SDN BHD CAM
1145 *21345 V SDN BHD BM
1141 *12345 V SDN BHD CAM
1140 *PMM145 V SDN BHD CAM
1144 *PMM155 V SDN BHD PGI
1147 *PMM175 V SDN BHD PGI
1146 *PMM195 V SDN BHD PGI
1148 *21237 V SDN BHD PGI
1156 *21347 V SDN BHD BM
1159 *12344 V SDN BHD BM

[tim201110]

=iferror(index($a:$a,aggregate(14,6,row($a$5:$a$24)/($b$5:$b$24=$d$1),randbetween(1,countif($b$5:$b$24,$d$1)))),"")