Using iframe in Angular

import { Pipe, PipeTransform } from '@angular/core';
import { DomSanitizer} from '@angular/platform-browser';

@Pipe({ name: 'safe' })
export class SafePipe implements PipeTransform {
  constructor(private sanitizer: DomSanitizer) {}
  transform(url) {
    return this.sanitizer.bypassSecurityTrustResourceUrl(url);
  }
}
<iframe width="100%" height="300" [src]="url | safe"></iframe>

References
https://stackoverflow.com/questions/38037760/how-to-set-iframe-src-without-causing-unsafe-value-exception

Excel MATCH Function

MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. Often, the INDEX function is combined with MATCH to retrieve the value at the position returned by MATCH.

=MATCH(E2,B3:B11,0)
=MATCH("pq*",B3:B11,0)
=MATCH("peach",B3:B9,0)

References
https://exceljet.net/excel-functions/excel-match-function

Excel Array formula

An array formula performs an operation on multiple values instead of a single value. The final result of an array formula can be either one item or an array of items, depending on how the formula is constructed. To work correctly, many array formulas need to be entered with control + shift + enter. When you enter a formula this way, you’ll see the formula wrapped in curly braces {} in the formula bar.

{=SUM(LEN(B2:B11))}

References
https://exceljet.net/glossary/array-formula