Thank u 🎉

Delete works only if we delete using right click context menu 😢... Not by hitting del key 🗝

@o-skh

Ай бұрын

You can use keyboard cntl and - key

Plz add Tibet in country list. Thanks 🙏

How it's possible in different column in one table with continues number like one column 1-20 another one 21-40

Thanks for sharing

Can also be done by using if + counta

@lazyreviewssupport9811

Ай бұрын

Could you explain

@o-skh

Ай бұрын

​@lazyreviewssupport9811 Let's say your serial number start in A2 And data start in B2 Use this in A2 cell =IF(B2"", COUNTA($B$2:B2), "") Then drag it down to your desire range. This formula checks if cell B2 is not empty (""). If it contains data, it counts the number of non-empty cells from $B$2 to the current cell B2 using COUNTA($B$2:B2). This count is used as the serial number. If cell B2 is empty, it returns an empty string ("").

What is 1here?

How date will come automatice base on a other column

i want it in this way, if you can help. SR.No in column A. If i enter a value in column B, then it generates SR.No. in column A. Also their are blank rows in Column B (if i enter a value in B1, then it Auto generates SR.No._1 in A1, then i enter value in B6, and it Auto genarates SR.No._2 in A6, and so on........

@o-skh

Ай бұрын

Put this formula in A2 =IF(B2"", COUNTA($B$2:B2), "") Then drag the formula in A2 down to the end of your desired range.

Its not working