This post is a little fun, not much of a Struggle I guess. In excel, we use permutations more often than we realize. Say you have twenty performance metrics and you’d like to monitor them for each month, imagine how much copy pasting and concatenating would need being done to get your column header namesContinue reading “Mix And Match – Get all possible permutations of an unlimited number of lists in Excel”
Tag Archives: Selection
Select Similar Coloured Cells in a Range
If you’d like to loop through all the cells in a sheet, it is very tempting to use something like the following: