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:
ramona23 pe Simpatie
Femeie
24 ani
Bucuresti
cauta Barbat
24 - 52 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Using Incremental Numbers in Excel Tables (Crt. No / Nr. Crt) Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 787
While you can add Crt. No manually by typing 1, 2 then dragging down, you might need your table to automatically add the next number in your table column.

I am sure there are multiple solutions for this, but here is one of them:

My column B always has data in it and in every cell - no blanks from start to end of table.
The data in column B is never numeric, always some letters.

In column A9 (the first data cell of my table, after the header), I will have the automatic numbering obtained with the following formula:

=IF(ISNUMBER(B9);1;COUNTA($B$9:B9))


pus acum 3 ani
   
Pagini: 1  

Mergi la