power query

This post solves a tricky issue of removing offset duplicates or, in other words, removing items from a list that exist not only in a different column, but also on different rows. Problem History This data format is based on … Continue reading →

Excel, of course, is quite capable of providing simple statistical summaries and analyses. However, there are occasions when bigger guns must be brought to bear on a statistical problem, and Excel