function main(workbook: ExcelScript.Workbook) {
let ws1 = workbook.getActiveWorksheet();
let range1 = ws1.getUsedRange();
range1.find(80, {
completeMatch: true,
matchCase: false,
})
}
function main(workbook: ExcelScript.Workbook) {
let ws1 = workbook.getActiveWorksheet();
let table1 = ws1.getTable("Completed");
const table1address = table1.getRangeBetweenHeaderAndTotal().getColumn(0).getValues();
console.log(table1address.flat())
console.log(table1address.findIndex(e => e[1] == 70))
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.