Hi,
I want to create random numbers in cells A1 to A9 that would add up to 146501.
Any ideas?
Hi,
I want to create random numbers in cells A1 to A9 that would add up to 146501.
Any ideas?
Copy the code to a code module, select A1:A9, and confirm with Ctrl+Shift+Enter:Please Login or Register to view this content.
=RandLen(146501)
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks