View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cherrynich
 
Posts: n/a
Default 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!