Hi all,

Im trying to create a mock up injury report in the format "Injury 1, Injury 2" i am using this formula i painstakingly made:

=CONCATENATE(IF(RANDBETWEEN(1,25)=1,"Neck",IF(RANDBETWEEN(1,25)=2,"Left shoulder",IF(RANDBETWEEN(1,25)=3,"Right shoulder",IF(RANDBETWEEN(1,25)=4,"Upper back",IF(RANDBETWEEN(1,25)=5,"Lower back",IF(RANDBETWEEN(1,25)=6,"Left hip",IF(RANDBETWEEN(1,25)=7,"Right hip",IF(RANDBETWEEN(1,25)=8,"Abdomen",IF(RANDBETWEEN(1,25)=9,"Left groin",IF(RANDBETWEEN(1,25)=10,"Right groin",IF(RANDBETWEEN(1,25)=11,"Left buttock",IF(RANDBETWEEN(1,25)=12,"Right buttock",IF(RANDBETWEEN(1,25)=13,"Left hamstring",IF(RANDBETWEEN(1,25)=14,"Right hamstring",IF(RANDBETWEEN(1,25)=15,"Left thigh",IF(RANDBETWEEN(1,25)=16,"Right thigh",IF(RANDBETWEEN(1,25)=17,"Left knee",IF(RANDBETWEEN(1,25)=18,"Right knee",IF(RANDBETWEEN(1,25)=19,"Left calf",IF(RANDBETWEEN(1,25)=20,"Right calf",IF(RANDBETWEEN(1,25)=21,"Left shin",IF(RANDBETWEEN(1,25)=22,"Right shin",IF(RANDBETWEEN(1,25)=23,"Left ankle",IF(RANDBETWEEN(1,25)=24,"Right ankle",IF(RANDBETWEEN(1,25)=25,"Left foot","Right foot"))))))))))))))))))))))))),", ",IF(RANDBETWEEN(1,25)=1,"Neck",IF(RANDBETWEEN(1,25)=2,"Left shoulder",IF(RANDBETWEEN(1,25)=3,"Right shoulder",IF(RANDBETWEEN(1,25)=4,"Upper back",IF(RANDBETWEEN(1,25)=5,"Lower back",IF(RANDBETWEEN(1,25)=6,"Left hip",IF(RANDBETWEEN(1,25)=7,"Right hip",IF(RANDBETWEEN(1,25)=8,"Abdomen",IF(RANDBETWEEN(1,25)=9,"Left groin",IF(RANDBETWEEN(1,25)=10,"Right groin",IF(RANDBETWEEN(1,25)=11,"Left buttock",IF(RANDBETWEEN(1,25)=12,"Right buttock",IF(RANDBETWEEN(1,25)=13,"Left hamstring",IF(RANDBETWEEN(1,25)=14,"Right hamstring",IF(RANDBETWEEN(1,25)=15,"Left thigh",IF(RANDBETWEEN(1,25)=16,"Right thigh",IF(RANDBETWEEN(1,25)=17,"Left knee",IF(RANDBETWEEN(1,25)=18,"Right knee",IF(RANDBETWEEN(1,25)=19,"Left calf",IF(RANDBETWEEN(1,25)=20,"Right calf",IF(RANDBETWEEN(1,25)=21,"Left shin",IF(RANDBETWEEN(1,25)=22,"Right shin",IF(RANDBETWEEN(1,25)=23,"Left ankle",IF(RANDBETWEEN(1,25)=24,"Right ankle",IF(RANDBETWEEN(1,25)=25,"Left foot","Right foot"))))))))))))))))))))))))))

However i keep getting results like "Right foot, Right foot". is there a way i can stop this from duplicating?

Thanks
Will