I am trying to solve a problem with no VBA at all (this is due to the limitations placed on me by my project
I have cells across spreadsheets that I need to bring under one column.
Therefore, i tried to set up lists for the data, and merge them dynamically using an If statement in an array
"Column C Count",A9:B12,2,FALSE)+0,O
However, when countc has 4 records, then countd has 5, depending on where you are in the master column, the entire row evaluates to that true or false condition
If column C has 1,2,3,4 and D has a,b,c,d,e,f
Then if you are in cell 6 of the array list, and reevaluate, you get a because the if statement evaluates to true, so it should return a, but it evaluates the false path instead, however if you uput the focus of the sheet on the first column, you get 1 as expected
attached is a sample sheet
I am not thrilled about arraylists as I think that is the issue.