This is the first time I have asked a quetion. I searched the community about finding the last occupied cell in a column and found this (=SUMPRODUCT(MAX(ROW($C$52:$C$190)*($C$52:$C$190<>"")))). It returned the row number and worked for me.
I tried to look up the functions and how it works but there was nothing about multiplying rows and “<>” and how “max” would work in this equation. Could someone explain this equation to me in detail? I like to know how things work.