Tuesday, December 6, 2022

Excel Concatenate & compare rows

 Concatenate 

="select '"&B13&"' as TableName, count(*) as Ctr from "&A13&".dbo."&B13&" with (nolock) union all"


Compare rows to list


=NOT(ISERROR(MATCH(J3,$A$3:$A$46,0)))

No comments:

Post a Comment