| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks! I also messed around using a new column and the INDIRECT feature.
Thanks again for your help "Herbert Seidenberg" wrote: Select all data in columns B and C Insert Name Define Names in Workbook: array_u Also define these names: rown Refers to: =FLOOR(ROW()-1,5)/5+1 coln Refers to: =IF(MOD(ROW(),5)=2,1,IF(MOD(ROW(),5)=3,2,3)) Enter this formula into A1 and copy down =IF(coln<3,INDEX(array_u,rown,coln),"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
| Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
| Extracting Data from another spreadsheet | Excel Worksheet Functions | |||
| Extracting data from other columns | Excel Worksheet Functions | |||
Threaded Mode
