• 510K Members
• 6,463 Online
• 607K Conversations
SOLVED

## Help me create a formula please.

Occasional Contributor

# Help me create a formula please.

Hello

Please see attached and help me if you can.

BR/Clau

9 Replies

# Re: Help me create a formula please.

`=B2&IF(COUNTIFS(\$B\$2:\$B\$12,B2,\$K\$2:\$K\$12,K2)>1,"A"&COUNTIFS(B\$2:B2,B2,K\$2:K2,K2)&"A","")`

# Re: Help me create a formula please.

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?

# Re: Help me create a formula please.

@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.

Solution

# Re: Help me create a formula please.

I believe my formula does exactly what you want.

Maybe someone else can bring in some light.

# Re: Help me create a formula please.

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.

Here is quick method to generate randomly alphanumeric texts in Excel. A good lesson for beginners. The following formulas can help you generate random numbers, letters and alphanumeric values in a range in Excel. 1. To create a random 5-digit number between 10000 and 99999, use this formula: ...

# Re: Help me create a formula please.

What exactly did not work?

# Re: Help me create a formula please.

Hello
Sorry for not specify better, I wanted to generate a random number A1A was an example only. Your formula works and I think I would be able to use it but what do you think about my thoughts here in comment?

"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.

# Re: Help me create a formula please.

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.

# Re: Help me create a formula please.

How would you then create a formula with randbetween to get what we want to achieve?
Related Conversations