Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining multiple lists into one !
I would greatly appreciate anybodies help with this:
I have 6 lists (defined as Nicki, Cathy, Dawn, Alison, PatJoy and MikePauline). I downloaded an example from Contexture, (http://www.contextures.com/excelfiles.html) as to how to combine the lists, which I have attempted to do. However, I am stuck as the example given only reflects how to do this for three lists. The formula below megers data from 3 columns/lists to one: =IF(ROW()COUNTA(Nicki)+COUNTA(Cathy),OFFSET(Dawn, ROW()-1-COUNTA(Nicki)-COUNTA(Cathy),0,1,1),IF(ROW()COUNTA(Nicki),OFFSET (Cathy,ROW()-1-COUNTA(Nicki),0,1,1),OFFSET(Nicki,ROW()-1,0,1,1))) how do i incorparte the other 3 lists ?? Thanks in advance for any help ! Kind Regards Adam194 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Multiple Columns into One | Excel Worksheet Functions | |||
Combining 2 lists | New Users to Excel | |||
Combining 4 lists of data | Excel Worksheet Functions | |||
Pivot Tables with Multiple Lists | Excel Discussion (Misc queries) | |||
creating drop down lists where you can select multiple values | Excel Discussion (Misc queries) |