Mar 20 2019 09:55 AM
Mar 21 2019 01:44 AM
Hello
Thank you. I have taken that and inserted it but it doesnt work. The thing is that I want only to generate some random number to use for article number. Is there such a way to do it?
Mar 21 2019 02:55 AM - edited Mar 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.
Mar 21 2019 03:25 AM
SolutionMar 21 2019 03:27 AM - edited Mar 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.
Mar 21 2019 03:47 AM
Mar 21 2019 04:06 AM
Mar 21 2019 04:18 AM
RAND() and RANDBETWEEN() always recalculate when something changes in the workbook.
So every time you type in new data the value in SKU Main C will change.
Mar 21 2019 04:43 AM
Mar 21 2019 03:25 AM
SolutionI believe my formula does exactly what you want.
Maybe someone else can bring in some light.