Randomly selecting a certain repeating number in a matrix

[yamomami]

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!