Category: Standard functions
Standard functions that comes with Excel, plain single functions
![Cells with additional spaces](https://xlfxs.com/wp-content/uploads/2022/07/2018-01-16-19.16.33-detect-space-at-end-1-1-360x270.jpg)
Cells with additional spaces
ANmar August 4, 2022
![Searching table in 2 dimensions.](https://xlfxs.com/wp-content/uploads/2019/02/Capture_2019-01-23-11-14-13-e1548309470312-2-360x270.png)
Searching table in 2 dimensions.
ANmar July 26, 2022
![Always get 1st name (or last)](https://xlfxs.com/wp-content/uploads/2022/07/1stlast-e1658254291468-1-360x218.jpg)
Always get 1st name (or last)
ANmar July 23, 2022
![Search across sheets in function](https://xlfxs.com/wp-content/uploads/2022/07/Searching-sheets-2-360x270.jpg)
Search across sheets in function
ANmar July 22, 2022
![Min Max vehicle](https://xlfxs.com/wp-content/uploads/2022/07/MinMax-1-360x270.jpg)
Min Max vehicle
ANmar July 20, 2022
![The Excel “&” bug](https://xlfxs.com/wp-content/uploads/2022/07/2022-Excel-Bug-1-360x270.jpg)
The Excel “&” bug
ANmar July 16, 2022
![0% interest promotion](https://xlfxs.com/wp-content/uploads/2022/07/IMG_20220611_140145845-1-360x270.jpg)
0% interest promotion
ANmar July 11, 2022
![VALUE() of LEFT()](https://xlfxs.com/wp-content/uploads/2022/07/N-of-Value-1-360x270.jpg)
VALUE() of LEFT()
ANmar July 7, 2022
![Schedule column](https://xlfxs.com/wp-content/uploads/2022/07/schedule-1-360x270.png)
Schedule column
ANmar July 6, 2022
![GoLast to jump to last cell in a column](https://xlfxs.com/wp-content/uploads/2020/07/GoLast-1-360x263.jpg)
GoLast to jump to last cell in a column
ANmar July 20, 2020
![CountIf limitation](https://xlfxs.com/wp-content/uploads/2020/03/abacus-1193093-640x480-1-1-360x270.jpg)
CountIf limitation
ANmar March 30, 2020