In large spreadsheets if you drag formulas down too far then you are increasing the calculation time and also the chances that Excel will freeze and/or crash. Continue reading
You’re trying to compare two lists of data to see what items from ‘List B’ are in ‘List A’. Sounds simple enough, right?
But some of the lookup values are not found even though you can clearly see the value in ‘List B’.
Sometimes our data isn’t perfect and we just have to deal with it. In this post you’ll see an awkward data-set from Mr Excel with a VBA solution from Bob Umlas and a formula solution from me. Continue reading
Imagine a data validation drop down list with many names that are not sorted. Trying to find a particular name in that list would get frustrating as the list grows.
Did you know that there are ways to sort text in Excel? Continue reading
This means that you can jump to a location in your data depending on conditions in the values.
This is one of my favorite ways to use an array formula! Continue reading
Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: This time I use the SUMPRODUCT function for a quicker solution. SUMPRODUCT can be used to count with conditions (within the same group).
Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: I use functions VLOOKUP, AND to identify rows if a condition is met within the same group. Continue reading