How to combine 2 different formulas into one cell

[coolio123]

Hey Everyone,
I was hoping that i could get your help with something.
I'm trying to create a sheet that will automatically calculate the total # of items on that list as well as then randomly assign them to another list.

I've gotten as far as doing either one separately but i would like to have the formula do one then the other in the same cell so that way not only do i have a random assignment but an equal # as well divided equally amongst the other list.
These are the formulas is this possible?

=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)
=INDEX($A$1:$A$65536, INT( (ROWS(D$3:D4) -2) * nPeople / nProducts) + 1)

[sandy666]

Attach a sample workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[coolio123]

Attach a sample workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you.
I've edited the post to reflect what you have asked for. Please let me know if you have any other questions.

[sandy666]

I see nothing common between BEFORE and AFTER

btw. don't quote full posts if it is not neccessary

Name 1 17-001, 17-006, 17-010, 20-060, 21-016

I understand why Name 1 17-001
but don't iunderstand why Name 1 17-001, 17-006

you can try

=INDEX($C$2:$C$98,RANDBETWEEN(1,COUNTA($A:$A)),1)&", "&INDEX($C$2:$C$98,RANDBETWEEN(1,COUNTA($A:$A)),1)&", "&INDEX($C$2:$C$98,RANDBETWEEN(1,COUNTA($A:$A)),1)&", "&INDEX($C$2:$C$98,RANDBETWEEN(1,COUNTA($A:$A)),1)

but I'm not sure this is what you want
RANDBETWEEN() repeat values