Filter cells that have notes

javifelices The script below filters a table named TB_Test (on Sheet2), for cells in column "Summary" containing a comment:

function main(workbook: ExcelScript.Workbook) {
  // Your code here

  let tableCells = workbook.getWorksheet("Sheet2").getTable("TB_Test").getColumnByName("Summary").getRangeBetweenHeaderAndTotal();
  let cellCount = tableCells.getRowCount();
  let allComments = workbook.getComments();
  let commentCell: ExcelScript.Range;
  tableCells.setRowHidden(true);
  for (let i = 0; i < allComments.length; i++) {
    try {
      let commentCell = tableCells.getIntersection(allComments[i].getLocation());
      console.log(commentCell.getAddress());
      commentCell.getEntireRow().setRowHidden(false);
    } catch {}

  }
}