Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hiding zero values in charts | Charts and Charting in Excel | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel |