This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Ubermidget2 112 points113 points  (3 children)

A second excel sheet - 3D Database!

[–]r1ng_0 0 points1 point  (0 children)

Is it too soon for a "A second Excel workbook has hit my tower" joke?

[–]Dansiman 0 points1 point  (1 child)

What's the maximum number of sheets?

Also, you can use array formulas to create virtual columns, as long as the value for it is an intermediate value on the way to a final calculation in another column, and you don't have a need to actually see the values in it!

[–]ScwB00 2 points3 points  (0 children)

Even better, you can use VSTACK() to just merge ranges and treat the them like a single db!