Public Function ПОИСКОБР( _ ByVal StringCheck As String, _ ByVal StringMatch As String, _ Optional ByVal Start As Integer = -1 _ ) As Integer ПОИСКОБР = InStrRev(StringCheck, StringMatch, Start) End FunctionВсе, используем ее в формулах книги.


Public Function ПОИСКОБР( _ ByVal StringCheck As String, _ ByVal StringMatch As String, _ Optional ByVal Start As Integer = -1 _ ) As Integer ПОИСКОБР = InStrRev(StringCheck, StringMatch, Start) End FunctionВсе, используем ее в формулах книги.
select * from (select * from (values(0,1,1,1,4), (5,6,6,6,9)) t (id1, id2, id3, id4, id5))t unpivot (value for columnName in (id1, id2, id3, id4, id5)) ttt
value columnName 0 id1 1 id2 1 id3 1 id4 4 id5 5 id1 6 id2 6 id3 6 id4 9 id5