Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Mar 27, 2023

COUNT ELEMENTS

Dear Experts,                      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 o...
excel
anupambit1797's avatar
anupambit1797
Iron Contributor
Mar 27, 2023

Detlef_Lewinhow to merge these multiple rows into one single row entries?

 

for example for row 3/4/5 is actually row 3 only and so on..

Thanks

Br,

Anupam

 

  • anupambit1797's avatar
    anupambit1797
    Iron Contributor
    Mar 27, 2023

    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 :-

     

    Thanks & Regards

    Anupam Shrivastava

    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Mar 27, 2023
      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.

Resources