03-21-2019 02:55 AM - edited 03-21-2019 03:25 AM
@Detlef Lewin, @Sergei Baklan,
I have attached the new file and added ??? mark so no misunderstanding will occur.
I need to create a formula which randomly creates an article when two cells in a column are identical. The result/artnr should be pasted in the next column aside the identical numbers.
03-21-2019 03:27 AM - edited 03-21-2019 03:58 AM
But can you please put it in the excel and upload it here then? To really see that it works. I have copy/paste and didnt work.
I have though that it needs an IF(B2=B1) randbetween(0,999999) and release a value in the next column along side the identical numbers.
03-21-2019 04:06 AM