When The TRIM Function Doesn’t Work

When The TRIM Function Doesn’t Work

Invisible characters are a great threat to accurate results when working with texts. Trim functions work well to remove Char(32) [spaces] but not Char(160) [non-break space] characters. The solution to cleaning non-break spaces is using the SUBSTITUTE function....
How to SUM Data Per Week Using Pivot Table

How to SUM Data Per Week Using Pivot Table

If you love low-code solutions then sum data per week using a pivot table is the way to go. The only trick here is to remember, Pivot tables lack the Week grouping. A way around this issue is to group 7 days together. See the below Video for steps to follow: DOWNLOAD...
XOR logic in Excel

XOR logic in Excel

Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns TRUE if the number of TRUE conditions is ODD and FALSE if the number of TRUE Conditions is EVEN. Like the OR Function, at least one of the test conditions must evaluate to...
OR Logic in Excel Formula

OR Logic in Excel Formula

When testing for multiple conditions, OR logic is used to determine if ANY condition in the test is TRUE. The only time OR function evaluates to FALSE is if all conditions in a test are false =OR( 2>5, 6>5 ) will evaluate to TRUE though the first logical test...