LinkBack URL
About LinkBacks
Hello everybody!
I have an excel with 25000 rows and i wont to autonumber from this kind of table excel 1.PNG in this kind of table excel 2.PNG.
Is this posible?
If yes, how can i autonumber this excel?
Please, help me.
Best regards
Autonumbering the unique Values
Hello everybody!
I have an excel with 25000 rows and i wont to autonumber from this kind of table excel 1.PNG in this kind of table excel 2.PNG.
Is this posible?
If yes, how can i autonumber this excel?
Please, help me.
Best regards
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
Please don't upload pictures, (as per guidance in forum rules area), they don't usually help us when you have an actual workbook.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
ok i will send a part of excel because is very large (25000 row), that is why i send a foto...
Re: Autonumbering the unique Values
This is the excel without autonumber excel.xlsx.
This is a excel with manual number instered by me, till 100 rows like this excel 1.xlsx.
So this is a database with debtors, i wont to import this in access but i need an ID NUMBER, this is what i wont to create.
The empty rows are because some debtor have paid their credi. Every debtor has its empty rows because of paymants, wich must be the same nr with that person wich paid them...
I hope to be clear.
Thanks for your help.
Hi,
Enter 1 in A2
Enterin A3 and copy down.Formula:
Please Login or Register to view this content.
thank you brother you are a genius, thank youuuuuuuuuuuuu.
what a happiness. you solve my work
thank you man
Hey people this guy is a genius
Columns A and B show two different methods of counting depending upon what you need exactly.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks