LinkBack URL
About LinkBacks
Hi,
I have three tables (1, 2, 3), each with three columns (A, B, C), and need to consolidate those into one table 4 with three columns.
Table 1
A: Data
B: Blank
C: Blank
Table 2
A: Sometimes data, if data in B
B: Data
C: Blank
Table 3
A: Blank
B: Sometimes data, if data in C
C: Data
Table 4
A: Data from A in Table 1 and Table 2, sorted in ascending order
B: Data from B in Table 2 and Table 3, sorted in ascending order
C: Data from C in Table 3, sorted in ascending order
Table 1 is really just one column of data (A), but I have added two dummy columns to show how the data fit in with the other tables.
Table 2 is actually two columns of data (A and mainly B), but I have added dummy column C for clarity.
Table 3 is actually two columns of data (B and mainly C), but I have added dummy column A for clarity.
I need a dynamic array formula which can produce the results seen in table 4 of the attached workbook.
If it is possible to have one formula for each of the columns A, B and C of table 4, that would be great. Otherwise, one formula for all three columns is also fine.
It would also be good if the data from table 1, 2 and 3 were brought into the formula as individual columns, since the columns A, B and C in these tables won't necessarily be side by side in real use, and also the dummy columns will not be present.
A key feature of the data is that a single A can point to many Bs which again can point to many Cs (a single C can point to only one B which again can point to only one A).
Regards,
Marbleking
Register To Reply
Bookmarks