Big data is a term used since the early 1990s to describe “huge, overwhelming, and uncontrollable amounts of information”. The rapid rise of the internet has meant the volume of data has increased exponentially over the past two decades. There…
Excel’s FILTER function filters a set of data based on defined criteria. However, it doesn’t allow for partial matches that use wildcards. What are the wildcard characters? One workaround is to use FILTER in conjunction with ISNUMBER and SEARCH in…
Staring at a worksheet with a plethora of errors is not sightly, but it can be your saving grace for diagnosing formula problems. Over a dozen error types exist, and chances are you will have seen most of them at…
End of content
End of content
