|
Featured Tutorial
Featured Macro
Excel Magic Trick #176 Get Last Item in Column on Diff Sheet
See how to get the last number or word from a column on a different sheet. See how to use the LOOKUP, OFFSET, MAX and ROW functions, as well as an array formula. See the Big Number Theory of the LOOKUP function (BigNum = 9.99999999999999E+307).
See how to get the last value from column A from across multiple sheets using the LOOKUP and INDIRECT functions.
See how to get the last value from column A from across multiple sheets using the LOOKUP and INDIRECT functions.