one criteria/mult. values
I have two columns of importance in the same sheet one is acct numbers, the
other is a date. I want to produce a sheet that shows the acct number once
and then displays which date coincide with it. for instance:
acct # | date | date | date |
5 | 1/15|2/2 | 3/9 |
2 |4/11 |
3 |3/7 |3/5 |
I only want to show acct once, but show every date the acct showed up on
next to it, how many dates it occurs on differs as I tried to show in the
example. Please help!
|