Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
one criteria/mult. values
One way.
With your acct#'s in A39:A43 and the dates in B, C, D columns. Select four cells in a row and while selected type in this formula. While still selected hit Ctrl -Shift - Enter. (array entered) =VLOOKUP(F39,A39:E43,{2,3,4,5},0) Enter you lookup acct# in F39 This will return up to four dates for any given acct#. If an acct# has only two dates, you will get two dates and two 0's. Any time you want to change the formula, you will have to select all four cells and make the change to the one shown in the formula bar and re-enter using Ctrl-Shift-Enter. This formula would return 9 values. You would have to select 9 cells in a row to enter as above. =VLOOKUP(F39,A39:J43,{2,3,4,5,6,7,8,9,10},0) HTH Regards, Howard "cherrynich" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |