linspiredgal
New Member
- Joined
- Apr 13, 2012
- Messages
- 25
Hi
I need random record to be selected from a group of categories in column.
Eg- from the table below- I need two names randomly highlighted, from each city type.
i.e two randomly selected names from NYC, seattle, toronto and california each.
[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Class[/TD]
[TD="class: xl65, width: 64"]city[/TD]
[/TR]
[TR]
[TD="class: xl63"]ABC[/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]DEF[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]GHI[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]Seattle[/TD]
[/TR]
[TR]
[TD="class: xl63"]JKL[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]Seattle[/TD]
[/TR]
[TR]
[TD="class: xl63"]MNO[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]PQR[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]STU[/TD]
[TD="class: xl64"]4[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]VWX[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]YZ[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl63"]California[/TD]
[/TR]
[TR]
[TD="class: xl63"]BVB[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]GHG[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]GDCK[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]HGHG[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]DFDF[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl63"]California[/TD]
[/TR]
[TR]
[TD="class: xl63"]DCBJ[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl63"]California[/TD]
[/TR]
</tbody>[/TABLE]
I need random record to be selected from a group of categories in column.
Eg- from the table below- I need two names randomly highlighted, from each city type.
i.e two randomly selected names from NYC, seattle, toronto and california each.
[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[TD="class: xl65, width: 64"]Class[/TD]
[TD="class: xl65, width: 64"]city[/TD]
[/TR]
[TR]
[TD="class: xl63"]ABC[/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]DEF[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]GHI[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]Seattle[/TD]
[/TR]
[TR]
[TD="class: xl63"]JKL[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]Seattle[/TD]
[/TR]
[TR]
[TD="class: xl63"]MNO[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]PQR[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]STU[/TD]
[TD="class: xl64"]4[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]VWX[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]YZ[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl63"]California[/TD]
[/TR]
[TR]
[TD="class: xl63"]BVB[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]GHG[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl63"]Toronto[/TD]
[/TR]
[TR]
[TD="class: xl63"]GDCK[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]HGHG[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl63"]NYC[/TD]
[/TR]
[TR]
[TD="class: xl63"]DFDF[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl63"]California[/TD]
[/TR]
[TR]
[TD="class: xl63"]DCBJ[/TD]
[TD="class: xl64"]5[/TD]
[TD="class: xl63"]California[/TD]
[/TR]
</tbody>[/TABLE]