In this video, I demonstrate how to fix chromatic aberration or colour fringing in Affinity Photo. Normally I manage to do this quite successfully using a RAW editor - my personal preference is DXO PhotoLab. However, for whatever reason this image did not want to play game. In Affinity Photo there…
Read More
Create a Multi Column Non-Contiguous Return Array Using XLOOKUP
In this video, I demonstrate how to create a non-contiguous return array when using XLOOKUP. The CHOOSE function does the trick here as you will see in the formula below. I created an array of index numbers {1,2,3} which correspond to the columns I have selected in the value 1, value 2 and value 3…
Read MoreVBA Macro to Combine Associated Records in a Single Record
In this video I walk you through a VBA macro that combines associated records into a single record. The scenario is that we have a book club that records the reading activity of its members. Each read is recorded on a separate row: member's name in column A and book title in column B. [su_youtube url="https://youtu.be/CjnMzRwrSP4"…
Read More