I want to put a duplicate serial number in case it was the same name
I want to put a duplicate serial number in case it was the same name
c2=if(countif($B$2:$B2,$B2)>1,"duplicated value","")
See the attached file
You are working from Right to Left?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Unfortunately Mister "oeldere"
I want to write the sequence ، no repetition
I want a special sequence such as found in the column "A"
Last edited by shimaa01234; 09-10-2014 at 09:06 AM.
Your explanation is not quite clear enough. Suggest you provide step by step, what is happening and what you want the result to be -- step by step.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I want automatic numbering, in the column "A" facility, such as Attachment "Test"
I need to special AutoNumber
Such as found in the column "A"
instead using text to explain, add the result manualy in the sheet and post it on the forum.
The result has already been sent in the example "# 1"
It is located in the column "A"
I need to special AutoNumber
Such as found in the column "A"
Last edited by shimaa01234; 09-10-2014 at 12:56 PM.
Se the attached file.
Unfortunately, Mister (oeldere)
I want to like the result column "C"
See the green cells in the attached file.
I do not want to bring this column by writing it down, then use the formula "VLOOKUP"
But I want the numbering of the column "B" ، Relying on the repetition of names in column "B"
I am interested in your better solution.
If you found it, I hope you take the time to post it on this forum.
You are a genius man, and I learn from you
I am waiting for the solution from you
Try this sheet
dont forget CTRL+SHIFT+ENTER
This is a way to solve the presented by Egyptian man
Is there a simpler ideas of this solution?
You get 3 solutions to your question.
So what is your question right now:
My question to you is: do you understand the formula in:
#13 (Oeldere) ?
#15 (Vivek123) ?
#16 (Egyptian man) ?
Can you simplify the formula in the solution number "# 16"
Or Are there other ways to resolve
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
Crossposted: http://www.mrexcel.com/forum/excel-q...utonumber.html
I repeat my question in #17 (since you don't answer this question).
My question to you is: do you understand the formula in:
#13 (Oeldere) ?
#15 (Vivek123) ?
#16 (Egyptian man) ?
You can try this in A2, then drag down
Please Login or Register to view this content.
Yes, Mister "Kvsrinivasamurthy"
You did it ، a wonderful formula
Thank you very much
@shimaa01234
is there a specific reason you don't reply on my questions in #20 (and #17)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks