• 464K Members
• 11.2K Online
• 561K 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.

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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies