How to count number of unique values on a pivot table when running excell on MacOS

 

If you are trying to identity how many items you have on a certain category using a pivot table like the example in green above, you will need to do a work around on a Mac, since there is no simple way to do that on a Mav (vs Windows where you can use a simple pivo table function). The work-around is create an extra column on your original data file. 

This video explain how to do it. Basically, you will create an extra colum on your pivotable with the following formula: "=1/COUNTIF(SalesStateRange,BCellValue)

This will result in a column with a fractional value that represents a share of the number of times a certain value shows on the complete range, when you add those as a Sum on your pivot table you get a total number of unique values. 

If you are in doubt, just watch the video. 

How to Open Excel files on separate windows (Windows 7 and Excell 2007)

For over a year I have struggled with Excel opening all my spreadsheets on the same window. I know you can use View to split/arrange/move the open spreadsheets around but sometimes I just prefer to have 2 separated independent windows like what happens with Word files...I looked into multiple  solutions, some even suggesting register changes but I found the answer in a MS forum here and it is so simple I have clipped the answer that solved my problem below (Thanks Bananarama_1 whoever you are!) so you don't need to look for the right answer in the forum.

Just open another Excel instance by simply clickink the Excel icon on the task bar with the mouse wheel and voila, you have an independent Excel instance you can use to open another file!