Selecting Entire Columns for VLOOKUP
Thu, 27 Sep 2012 - 12:44 PM
Is there no way to select A:B, as an example in a formula in LibreOffice? I seem to be expected to select a specific range of cells for my formula (A1:B45), but this isn’t economical when I’m handling a hundred thousand of rows of data.
SHIFT+CTRL+DOWN is one way to get around it, but if there are spaces, seperated chunks of data or any other irregularities in the list of data this can be tedious.