Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff. 		Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat. 		Nou pe simpatie:
MarenD pe Simpatie
Femeie
19 ani
Giurgiu
cauta Barbat
28 - 48 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] How to Automatically Add Cur No / Nr Crt to a Table Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
TRaP
Moderator

Inregistrat: acum 7 ani
Postari: 811
You have an Excel Table (obtained with CTRL+T or Insert - Table) and you must add an incremental column usually named Cur. No. in English or Nr. Crt. in Romanian.

You want a formula to do it so each time you add a new row it's already numbered.

Use this formula in the first row of your table:

=ROW(A26)-ROW(A$25)

where 25 represents the number of rows above row 1 of the table.

For example if your table has its header in A1, then the formula above becomes:

=ROW(A2)-ROW(A$1)
pus acum 3 ani
   
Pagini: 1  

Mergi la