How to start from a specified number in Randam formula

**roofi** · 01-06-2014, 12:58 AM

Hi Freinds,
I have the following formulae to pick up a random number from 0 to 9999.
=TEXT(RANDBETWEEN(0,9999),"0000")
I want to start this random search from a specified number. for example if i press F9 it should show 3456 at first press and then onward.
please be appreciated.

thanks n regards,
Roofi

**rishikrsaw** · 01-06-2014, 03:38 AM

hi I just prepared a sheet for you pls check and let me know if is this helpful

many thanks
Rishi Saw

How to start from a specified number in Randam formula

LinkBack

Thread Tools

Rate This Thread

Display

How to start from a specified number in Randam formula

Re: How to start from a specified number in Randam formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to display sequence number based on contiguous start and end dates

[SOLVED] AutoFilter - Start with any number

[SOLVED] Find number between start and End.

[SOLVED] Need a macro to add a period to start of number and at the end of the number

Copy everything before number start

Bookmarks

Bookmarks

Posting Permissions