How to get the last value of a column of data in excel

Obtaining method: First open the excel table that needs to be operated, select the specified cell; then enter the formula "=LOOKUP (9E 307, specific data range)" in the cell; finally press " Press Enter key" to get the last value of a column of data.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open the excel form

##Enter the formula =LOOKUP(9E 307,B17:B21), which means to find the last value smaller than 9 raised to the 307th power A number.

After pressing Enter to get the data, press and hold the black square in the lower right corner of the cell and pull it to the right.

also got all the results.

Related learning recommendations:

excel tutorial

The above is the detailed content of How to get the last value of a column of data in excel. For more information, please follow other related articles on the PHP Chinese website!