Hello,
I can't figure out how to write a formula to count unique entries in different groups.
My goal is to have a non-excel user to just paste the content of a worksheet ( monthly) and get the stats done automatically. I am not sure if this can be achieved by Pivot Table because I did not see it....... :|
I got this:
{=SUM(IF(Monthly_Transaction!F:F="DISTANCE",IF(FREQUENCY(IF(LEN(Monthly_Transaction!C:C)>0,MATCH(Monthly_Transaction!C:C,Monthly_Transaction!C:C,0),""), IF(LEN(Monthly_Transaction!C:C)>0,MATCH(Monthly_Transaction!C:C,Monthly_Transaction!C:C,0),""))>0,1)))}
and it worked. However, when I change the content of the reference sheet, this will not work.
I will probably have to give up if I can't get this done in the next week. sigh
Configuration: Windows XP Firefox 3.0.5
I found these 2 sites to be very useful - solved all my problems. Hope they help you as well. I sure thank
|
"ms excel" count dates <=a specific date Combine two excel files and highlight differences Count unique values excel 2008 Excel 2007 count unique values Excel count cells greater than Excel count cells with similar criterias formulae Excel count column a only if column b is empty Excel count days Excel count how many times a word appears Excel count weekends between two dates Excel create data entry form template Excel formula sumif cells different sheets Excel formula to calculate different values in rows Excel make cell text different color if values is less than Excel vba count unique How can i count names in different columns and rows in excel? Vba excel count duplicate values Vba excel userform "data entry"