S
seanc
Hi
I am struggling to make a frequency formula that gives me the count of
unique entries of one column based on the criteria of another column.
for example the worksheet looks like this
Collummn
A B
1 Jan 05
2 Jan 05
2 Jan 05
1 feb 05
2 jan 05
3 feb 05
4 feb 05
4 feb 05
If I type in Jan 05 the result will be 2
and if I type in feb 05 the result will be 3
I just cant suceed in tying the count to the month chosen.
Thanks for any help in advance.
Seanc
I am struggling to make a frequency formula that gives me the count of
unique entries of one column based on the criteria of another column.
for example the worksheet looks like this
Collummn
A B
1 Jan 05
2 Jan 05
2 Jan 05
1 feb 05
2 jan 05
3 feb 05
4 feb 05
4 feb 05
If I type in Jan 05 the result will be 2
and if I type in feb 05 the result will be 3
I just cant suceed in tying the count to the month chosen.
Thanks for any help in advance.
Seanc