Titus sabu
New Member
- Joined
- Nov 9, 2017
- Messages
- 7
SNO | NAME | CONTACT |
1 | PUBLIC SCHOOL 1 | 9855666 |
930000 | ||
2 | PUB SCHOOL 2 | 82899633 |
<tbody>
</tbody>
SNO | NAME | CONTACT |
1 | PUBLIC SCHOOL 1 | 9855666 |
930000 | ||
2 | PUB SCHOOL 2 | 82899633 |
=if(istext(b2),max(a$1:a1)+1,"")
Hi Titus,
assuming your first col starts from Col A, and what i understand your numbered cells to avoid are like "930000", and you want to number off from Row 2 onwards, try input the formula below in cell A2 and drag down.
=IF(AND(NOT(ISBLANK(B2)),NOT(ISNUMBER(B2))),ROWS($B$2:$B2)-COUNTBLANK($B$2:$B2)-COUNT($B$2:$B2),"")