Then, the cell gets populated with the number 1. Select the cell A5, corresponding to the first non-empty row in the range and paste the following formula – The COUNTA function is used in numbering only those rows that are not empty within a range. A serial number does not change automatically.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |