Automatically insert serial number if adjacent cell non blank in excel.
Автор: WebTechPool
Загружено: 2020-06-13
Просмотров: 50782
Описание:
This video to related to appear serial number for only non blank cell.
Sometimes we need to insert serial number automatically according to adjacent cell and only for non blank cell( Means where any data available).
insert serial number
insert serial number automatically in worksheet excel vba
insert serial number in excel
insert serial number only for non blank cell
show count only for non blank cell in excel
insert serial number in excel column
automatically insert serial number in excel
serial number in excel automatic
serial number in excel
how to type serial number in excel automatically
how to get automatically serial number in excel for non blank cell only
Formula of video...
If the serial number column is "B"
, Data in Column "C"
and data starts from row number "3"
Then formula will be as per below
=IF(C3="","",COUNTA($C$3:C3))
Note:-here I have used alphabetical data in for count serial number that why used COUNTA if you have data in numeric form then you can use only COUNT.
THANKS FOR WATCHING
PLEASE LIKE AND SUBSCRIBE
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: