Hi,
I need to get random numbers to appear down seperate columns, without doubling up.
I have 80 numbers to fit into 80 cells.
I can not let them be used more than once.
I need to create random numbers from C1-C40 and again from F1-F40.
I can use VBA.
Also, once this is done, I need the cells in D1-D40 and E1-E40 to lookup Column A to find the number and display what is written in Column B. As in, what is if 13 came out for C1, then I'd need what is written in B13 to go into D1. (this is where 1-80 are in order from A1-A80)...
Does this make sense?
I need to get random numbers to appear down seperate columns, without doubling up.
I have 80 numbers to fit into 80 cells.
I can not let them be used more than once.
I need to create random numbers from C1-C40 and again from F1-F40.
I can use VBA.
Also, once this is done, I need the cells in D1-D40 and E1-E40 to lookup Column A to find the number and display what is written in Column B. As in, what is if 13 came out for C1, then I'd need what is written in B13 to go into D1. (this is where 1-80 are in order from A1-A80)...
Does this make sense?