Скачать или смотреть SOLVED: ‘You Can’t Change Part of an Array’ Error in Excel – How to Sort UNIQUE Formulas

I know there are better ways to do this rather than using unique formulas but sometimes I need to use a unique formulas and found a way to sort the list. Hope you find it useful!

P.S. ignore my comment about Power Query Editor being a back end version of pivot tables idk what I was thinking.

Query code used in the video:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim MonitoredRange As Range
Set MonitoredRange = Me.Range("B4:C35")
If Not Intersect(Target, MonitoredRange) Is Nothing Then

Application.EnableEvents = False ' Prevent re-triggering

ThisWorkbook.Connections("Query - Table").Refresh

Application.EnableEvents = True ' Re-enable events

End If

#excel #exceltutorial #exceltips #learning #office