Log In
Register
Home
September 14, 2020
Offline
I Have two Columns. I want to assign unique numbers to those columns.
But, the number assign in the first column should not appear in the second column.
Which Formula will be used.
September 9, 2020
Offline
Hi Reehan Saeed,
I'm not sure what the goal is. Could you put an example of what you expect?
Trusted Members
December 20, 2019
Offline
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?
September 14, 2020
Offline
An example's shown. I attach the file.
I want this work by using Formula.
KIndly check it,
Thanks.
September 14, 2020
Offline
I Send post, But still Awaiting Moderation. Why?
October 5, 2010
Offline
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
September 9, 2020
Offline
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.
1 Guest(s)
