Hi Reehan Saeed,

I'm not sure what the goal is. Could you put an example of what you expect?

do you want a unique number per row or per category per row? How many numbers in the unique number? can the number contain characters or just numbers?

What is the relevance of the number?

An example's shown. I attach the file.

I want this work by using Formula.

KIndly check it,

Thanks.

I Send post, But still Awaiting Moderation. Why?

Hi,

All posts from non-course members are moderated.

We don't sit in front of our PC's all day, so sometimes approving posts takes a few hours.

Phil

hi Reehan Saeed
The files don't allow me to be 100% certain of what you want to do.

• You have data in columns C and E and you want a formula to complete the data with a unique identifier that automatically increments in columns G and I?
• Or you have a sample data and you want the person not to be able to manually enter a duplicate? For this, I work with data validation.

I'll give you an example (from what I understand) in Sheet2.