conditional counting question

  • Thread starter Thread starter sonang
  • Start date Start date
S

sonang

Hi. Is it possible create a function that will count the following:

Column A has condition, but I want column D to be counted, however,
has duplicates. I want to count occurrences of D when A, but withou
counting duplicates of D. Example below:

Col A: Col D:
Unit Acct
65064 451111
65064 451111
65064 451133
65065 451144
65066 451100
65066 451100
65066 451100
65066 451101
65066 451102




Let me know if this isn't clear...thanks.

ETA: btw i'm new.. thanks for all ur help in advance :)
 
Not sure I follow. Do you want to count only unique items
in column D? It sounds like you want to count items in D if
A, but then you don't want to count similar items. It seems
you would end up with a count of 1 in D if A since you
don't want to count similar items.
 
hi. I want to count occurrences of D when A. So the results of m
example should be the following:

65064 should have a count of 2
65065 should have a count of 1
65066 should have a count of 3

i know it can be done in access, but its only for one column of a muc
larger report which will be done on a regular basis, so it would b
time consuming to have to query it in access. can this be done i
excel? thanks so much!
 
Back
Top