Hi all,
I am dealing with a huge amount of data on google and forums, but can't seem to place it all together.
1. I need concatenation for this, since from what I read INDIRECT() does can't open closed excel files.
2. I can't use MOREFUNC | Ashish Mathur's Blog (morefunc), cause it's on the...