dynamiczny zakres

tworzymy dynamiczny zakres dla listy:
=OFFSET(S14;0;0;COUNTA($S$14:$S$50);1)

dodajemy listę (nazwę) do Data Validation

YT - new cool functions
function link
test link
REGEX https://www.youtube.com/watch?v=YFnXV2be9eg
LAMBDA https://www.youtube.com/watch?v=Rm4y5UqauRw
TAKE https://www.youtube.com/watch?v=z66-6WVZSFY
more functions https://www.youtube.com/watch?v=VWcLM6_Q_00
PYTHON https://www.youtube.com/watch?v=FbBXtqtRnWU
NEW Checkboxes https://www.youtube.com/watch?v=DNl9DzNwjv8
important Settings https://www.youtube.com/watch?v=jLHqGRpGOPk
GROUPBY & PIVOTBY https://www.youtube.com/watch?v=mCJzhCxEQlM
"dot" trick https://www.youtube.com/watch?v=5h4wRTbmsSw
XLOOKUP "x-ref" https://www.youtube.com/watch?v=y0L-QzTkwcA
new functions to investigate

=MAP
=SCAN
=REDUCE
=LAMBDA
=TOCOL
=TOROW
=TEXTSPLIT
=TEXTBEFORE
=TEXTAFTER
=VSTACK
=HSTACK
=WRAPROWS
=TAKE
=DROP
=CHOOSECOLS
=CHOOSEROWS
=EXPAND

IBPi attribute for multiple rows

=IF(SUMIFS(C:C;A:A;A2;B:B;"kf4")=0;TRUE;FALSE)
C:C = values to check
B:B - keyfigure to match for value check
A:A - fp_code
A2 - top level col A reference

extract FULL URL from hyperlink
Function GetFullURL(rg As Range) As String
    On Error Resume Next
    If rg.Hyperlinks.Count > 0 Then
        If rg.Hyperlinks(1).SubAddress <> "" Then
            GetFullURL = rg.Hyperlinks(1).Address & "#" & rg.Hyperlinks(1).SubAddress
        Else
            GetFullURL = rg.Hyperlinks(1).Address
        End If
    Else
        GetFullURL = ""
    End If
End Function

Sub extractURLs()
With ActiveSheet
  For r = 2 To 20
    .Cells(r, 7).Value = GetFullURL(.Cells(r, 3))
  Next r
End With
End Sub