Drug and drop with tables

[komhs]

Hi to all,

I have a question to ask. I think that it doesn't need an Xl2bb sheet. It is a core knowledge that obviously I don't have.

I don't know how to keep stable columns of a table in a function or how to keep some columns stable and some other dynamic.

Example1:
=MAX(FREQUENCY(IF(Table4[Column4]<>"",ROW(Table4[Column4])),IF(Table4[Column4]="",ROW(Table4[Column4]))))
If i drag it horizontally it keeps Column4 to all cells of the row, but I want to keep counting the columns Column5, Column 6 etc.

Example 2:
=SUMPRODUCT((Table9[Νο 1]=$I$2)*(Table9[Secondary]<=90)*(Table9[[Νο 2]:[Νο 5]]=J4))
On the other hand in this function, if I will take the same action, drag horizontally to other cells, for some reason it is changing the No 1 and Secondary (they are columns of a table), but I want to keep them stable.

Any ideas please?

Thanks in advance

 

[Peter_SSs]

I don't know how to keep stable columns of a table in a function or how to keep some columns stable and some other dynamic.

See if this helps

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[komhs]

See if this helps

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Yes, this is the knowledge that I was looking for. Thank you so much and I updated the Account details.

 

[Peter_SSs]

You're welcome.
.. and thanks for updating your profile.