Excel Statistics 17: Categorical Cross Tabulation with Formulas
Loading...
7,480
Loading...
see all
Video Responses
This video is a response to Excel Statistics 16: Categorical Cross Tabulation with Pivot Table
Loading...
I noticed that it's not possible to use undo when i accidently forgot to mark 'unique records' at the advanced filter. That's kind of weird...
JJTheBigDog 10 months ago
You are right! Before 1981 when the 1st spreadsheet (VisiCalc) came out, people did it by hand!
We are lucky to have spreadsheets!
ExcelIsFun 2 years ago
Various reasons, usually it becasue the formulas update instantly (PivotTables you have to refresh) and becasue people may not want to use a Pivot Table because others may not like them.
Pivot Tables are much easier than formulas. 3, 4, 5 criteria are all possible with both formulas and Pivot Tables. I have many videos if uou search my channel and I have playlists that have videos grouped.
ExcelIsFun 2 years ago