> For the complete documentation index, see [llms.txt](https://www.parapathology.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.parapathology.com/computers/excel-sheets.md).

# Excel, Sheets

## Excel, Sheets

<https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/>

> `RANK`
>
> `LEFT, RIGHT`
>
> `LEN, SEARCH`
>
> `WEEKDAY`
>
> [`DATEDIF`](https://support.google.com/docs/answer/6055612)
>
> `NOW`
>
> `IF`
>
> `IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))`
>
> `OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)`
>
> [`COUNTIF(range, criterion)`](https://support.google.com/docs/answer/3093480)
>
> [`SUMIF(range, criterion, sum_range)`](https://support.google.com/docs/answer/3093583)
>
> [`AVERAGEIF(range, criterion, average_range)`](https://support.google.com/docs/answer/3256529)
>
> [`VLOOKUP(search_key, range, index, is_sorted)`](https://support.google.com/docs/answer/3093318)
>
> [`HLOOKUP(search_key, range, index, is_sorted)`](https://support.google.com/docs/answer/3093375)
>
> [`SUMPRODUCT(array1, [array2, ...])`](https://support.google.com/docs/answer/3094294)

<https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/>

> `RANK`
>
> `LEFT, RIGHT`
>
> `LEN, SEARCH`
>
> `WEEKDAY`
>
> [`DATEDIF`](https://support.google.com/docs/answer/6055612)
>
> `NOW`
>
> `IF`
>
> `IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))`
>
> `OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)`
>
> [`COUNTIF(range, criterion)`](https://support.google.com/docs/answer/3093480)
>
> [`SUMIF(range, criterion, sum_range)`](https://support.google.com/docs/answer/3093583)
>
> [`AVERAGEIF(range, criterion, average_range)`](https://support.google.com/docs/answer/3256529)
>
> [`VLOOKUP(search_key, range, index, is_sorted)`](https://support.google.com/docs/answer/3093318)
>
> [`HLOOKUP(search_key, range, index, is_sorted)`](https://support.google.com/docs/answer/3093375)
>
> [`SUMPRODUCT(array1, [array2, ...])`](https://support.google.com/docs/answer/3094294)

## Excel, Sheets

<https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/>

> `RANK`
>
> `LEFT, RIGHT`
>
> `LEN, SEARCH`
>
> `WEEKDAY`
>
> [`DATEDIF`](https://support.google.com/docs/answer/6055612)
>
> `NOW`
>
> `IF`
>
> `IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))`
>
> `OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)`
>
> [`COUNTIF(range, criterion)`](https://support.google.com/docs/answer/3093480)
>
> [`SUMIF(range, criterion, sum_range)`](https://support.google.com/docs/answer/3093583)
>
> [`AVERAGEIF(range, criterion, average_range)`](https://support.google.com/docs/answer/3256529)
>
> [`VLOOKUP(search_key, range, index, is_sorted)`](https://support.google.com/docs/answer/3093318)
>
> [`HLOOKUP(search_key, range, index, is_sorted)`](https://support.google.com/docs/answer/3093375)
>
> [`SUMPRODUCT(array1, [array2, ...])`](https://support.google.com/docs/answer/3094294)

#### Compare two sheets

```
=IF(Sheet1!A1<> Sheet2!A1, Sheet1!A1&" | "&Sheet2!A1, "")
```