Random telephone numbers

**Voodoodan** · 05-04-2005, 09:48 AM

Hi,

I have a telephone list at work that I work on. In some cells there's more than one extension number shown so, for example, in cell B10 there is:

23109, 23146, 23148

This is great, except people mainly call the first number in the list, which can be a bit annoying!

Is there any way to randomise these 3 numbers in that cell so that it shows a different number every time the worksheet is opened?

Thanks,
Dan.

**swatsp0p** · 05-04-2005, 10:06 AM

Here is a way to change it every day:

=IF(MOD(DAY(TODAY()),3)=0,23109,IF(MOD(DAY(TODAY()),3)=1,23146,23148))

This changes on every recalculation of the sheet:

=IF(ROUNDDOWN(RAND()*3,0)=0,23109,IF(ROUNDDOWN(RAND()*3,0)=1,23146,23148))

To change it every time the workbook opens will take VBA and can be disabled if the sheet is opened with Macros turned off.

HTH

Bruce