My business is in need of an auditing tool that randomizes a location and does not duplicate it over the year. We currently have a worksheet with a collection of locations (columns A:M with different row counts) which we print, cut into little pieces of paper and pick from a hat. Yes....it is that archaic. I would like to develop a formula that would generate a random cell from the provided range (Avoiding blanks) and have it deleted from future use. This would eliminate duplicate audits over the year.
Currently, I have the following in sheet 2 which is providing a randomized cell BUT I do not know how to use this to delete the reported cell from the range. As with everything in Excel, this is fragmented from what I have gathered through forums.
=INDEX(List!$A:$M,RANDBETWEEN(1,COUNTA(List!$A2:$A65536)),RANDBETWEEN(0,13))
Any help is appreciated.
Thanks,
Brad
Currently, I have the following in sheet 2 which is providing a randomized cell BUT I do not know how to use this to delete the reported cell from the range. As with everything in Excel, this is fragmented from what I have gathered through forums.
=INDEX(List!$A:$M,RANDBETWEEN(1,COUNTA(List!$A2:$A65536)),RANDBETWEEN(0,13))
Any help is appreciated.
Thanks,
Brad