This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
fuss:excel [2014/12/19 22:45] – external edit 127.0.0.1 | fuss:excel [2022/04/19 08:28] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Frequency Count in Excel ====== | ||
+ | {{fuss_excel_statistical_distributions_using_frequency.gif}} | ||
+ | |||
+ | ====== Sort by String Length ====== | ||
+ | |||
+ | An interesting solution by [[http:// | ||
+ | |||
+ | Suppose you have some strings in a sheet with different lengths. All you need to do is to create a second column, select the first cell, insert the function '' | ||
+ | |||
+ | ^ A ^ B ^ | ||
+ | | absdfsdfsd | 10 | | ||
+ | | cdef | 4 | | ||
+ | | rwerwer | ||
+ | | eee | 3 | | ||
+ | | w | 1 | | ||
+ | | sdfd | 4 | | ||
+ | |||
+ | Now, by selecting both columns, go to '' | ||
+ | |||
+ | ^ A ^ B ^ | ||
+ | |w | 1 | | ||
+ | |eee | 3 | | ||
+ | |cdef | 4 | | ||
+ | |sdfd | 4 | | ||
+ | |rwerwer | 7 | | ||
+ | |absdfsdfsd | 10 | | ||
+ | |||
+ | ====== Pairwise Difference between Cells ====== | ||
+ | |||
+ | The pairwise difference between cells in a column can be calculated using the '' | ||
+ | |||
+ | ^ Values ^ Pairwise Difference ^ | ||
+ | | 9 | | | ||
+ | | 5 | '' | ||
+ | | 10 | ||
+ | | 3 | | | ||
+ | |||
+ | Applying the formula to all rows (by dragging), will result in the following table: | ||
+ | |||
+ | ^ Values ^ Pairwise Difference ^ | ||
+ | | 9 | | | ||
+ | | 5 | 4 | | ||
+ | | 10 | -5 | | ||
+ | | 3 | 7 | | ||
+ | |||
+ | You can also use '' | ||
+ | <code excel> | ||
+ | =ABS(OFFSET(C2, | ||
+ | </ | ||
+ | |||
+ | in order to avoid negative values. |