>>647660It's all good.
>but good dumb, not bad dumb.I can definitely get behind that. Excel is so fucking deep - I've been working with it for the last 10 years pretty much every day and I probably don't know half about it. Definitely haven't even gotten into pivot tables or VBA which is - as professionals continue to assure me - where the actual wizardry begins.
You can definitely do it the way you originally suggested as well, btw (finding a cell, then reading the next 10 below). It's just a little more complicated. Looking up the cell and reading from it the row and column of its address is a task on its own. Then you can re-assemble new addresses dynamically in the pattern =indirect(address(row()+1,column())) for each line to transfer the contents of your larger list.
sumproduct() is really only for numbers, but I have a massive soft spot for it. If you want to read text you definitely should delve into vlookup(), match() and stuff like that.
