COUNT ELEMENTS

Question

Dear Experts,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I want to create a column , that counts the number of elements in the previous column as below:-So , if we have 3 elements, then count should be 3 and so on.&nbsp;Thanks &amp; RegardsAnupam Shrivastava&nbsp;

detlef_lewin · Answer

anupambit1797&nbsp;=COUNTA(TEXTSPLIT(A3,","))&nbsp;

anupambit1797 · Answer

Detlef_Lewinhow to merge these multiple rows into one single row entries?&nbsp;for example for row 3/4/5 is actually row 3 only and so on..ThanksBr,Anupam&nbsp;

detlef_lewin · Answer

anupambit1797&nbsp;The cells are already merged.&nbsp;&nbsp;

anupambit1797 · Answer

Detlef_Lewin, what I was trying to say is like if I extend this formula to other cells then it's not allowing me to do so with below error :-&nbsp;Thanks &amp; RegardsAnupam Shrivastava

patrick2788 · Answer

Merging cells is not a best practice for reasons such as this with the formula. It might be best to select the entire sheet and unmerge all.

Forum Discussion

COUNT ELEMENTS

5 Replies

Resources