| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine Two Similar Arrays
I got the basic Arrays from these discussion boards and individually they
work masterfully. However I was wondering how I can actually combine them so that I can actually have a single list of information instead of several individual ones. Below is the function codes... =IF(ROWS(S$2:S2)COUNTIF(C12:M12,"0"),"",INDEX(C$ 11:M$11,SMALL(IF(C$12:M$120,COLUMN(C$11:M$11)),RO WS(S$2:S2))-COLUMN($C11)+1)) =IF(ROWS(S$13:S13)$M$2,"",INDEX(C$18:Q$18,SMALL(I F(C$19:Q$190,COLUMN(C$18:Q$18)),ROWS(S$13:S13))-COLUMN($C18)+1)) Thanks in Advance, Rob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine Two Similar Arrays
Rob wrote:
I got the basic Arrays from these discussion boards and individually they work masterfully. However I was wondering how I can actually combine them so that I can actually have a single list of information instead of several individual ones. Below is the function codes... =IF(ROWS(S$2:S2)COUNTIF(C12:M12,"0"),"",INDEX(C$ 11:M$11,SMALL(IF(C$12:M$120,COLUMN(C$11:M$11)),RO WS(S$2:S2))-COLUMN($C11)+1)) =IF(ROWS(S$13:S13)$M$2,"",INDEX(C$18:Q$18,SMALL(I F(C$19:Q$190,COLUMN(C$18:Q$18)),ROWS(S$13:S13))-COLUMN($C18)+1)) Thanks in Advance, Rob Maybe if you provided a sample of the original data and the desired results... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine rows with similar data, but different fields in excel | Excel Discussion (Misc queries) | |||
| How to combine data from 100 similar Excel files | Excel Discussion (Misc queries) | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| How do I combine quantities of similar line items | Excel Discussion (Misc queries) | |||
| Combine query to count products with similar names | Excel Worksheet Functions | |||
Linear Mode
