Randomly selecting a certain repeating number in a matrix

yamomami

New Member
Joined
Jan 17, 2012
Messages
1
I am trying to randomly select a repeating number in a matrix. I have seen the different random number and random select codes out there, but specifically what I'm asking is how to go about selecting a number that repeats in a matrix multiple times, not numbers between a certain range or a specific number that occurs in a matrix either. In other words, say I have a matrix like the following:
<table class="cms_table"><tbody><tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right" width="75">0</td> <td class="cms_table_td" align="right" width="75">0</td> <td class="cms_table_td" align="right" width="75">0</td> <td class="cms_table_td" align="right" width="75">0</td> <td class="cms_table_td" align="right" width="75">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">5</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">5</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">4</td> <td class="cms_table_td" align="right">4</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">4</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">4</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">5</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">5</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">8</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">9</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> <tr class="cms_table_tr" valign="top"><td class="cms_table_td" align="right">5</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">5</td> <td class="cms_table_td" align="right">0</td> <td class="cms_table_td" align="right">0</td> </tr> </tbody></table>
There are multiple 5's here, but for my purposes I only want to select one of those 5's. Is there a way to do this in Excel?

Also, I can only run macros in MSExcel 2004 for Mac because 2008 doesn't allow macros. Hopefully that doesn't cause any probs.

Thanks!
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,099,011
Messages
5,466,014
Members
406,461
Latest member
Garrus

This Week's Hot Topics

Top