Formula for row vs column

Hi plesa see file
Used function named as Dyn_val

=OFFSET(Sheet1!$B$22,,,,COUNT(Sheet1!$B$22:$S$22))

If it meets your requirements, mark the thread as "SOLVED", and don't forget to add reputation by pressing blue scales on the right of your screen

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save