Basically here is the issue:
I have three independent tables, located sporadically on a sheet. Basically I want to take the entire contents of a column (not necessarily the same column) from each of tables 1,2, and 3, and turn them into a new column in a table 4 that ommits the blanks from columns in tables 1,2,3.
I came across this string which when entered into a cell, does the combination of 2 Lists(2columns from 2 independent tables): (entered with crtl+shift+enter)
{=IFERROR(INDEX(CURRENT, SMALL(IF(ISBLANK(CURRENT), "", ROW(CURRENT)-MIN(ROW(CURRENT))+1), ROW(A1))), IFERROR(INDEX(NEWCS, SMALL(IF(ISBLANK(NEWCS), "", ROW(NEWCS)-MIN(ROW(NEWCS))+1), ROW(A1)-SUMPRODUCT(--NOT((ISBLANK(CURRENT)))))), ""))}
But I need this to do three lists, "NEWCS" "CURRENT" and "NEWMF
And Place them into a new table column which can then be sorted.
Aside:
NEWCS refers to Table6[code1]
NEWMF refers to Table10[code2]
CURRENT refers to Table3[code3]
Anyone have an idea as to how what the formula would be to do this, or is there a way to modify the above formula to include "NEWMF"?
Bookmarks