Excel’s TAKE function will let you extract the first, last, or specific columns or rows from a table. For example, you might want to extract the data from the last three days or display the top ranked individuals. Let’s look into this in more detail.